Can not start instance SAP - ABAP Database is not available via R3trans

[Former Member]

Dear all !

My OS : Linux RHEL 4U7 32bit

Oracle 10G R2 32bit 10.2.0.2

when system running but power off suddenly

and when power on ->

i am having problem as below when i start instance SAP (Databse Oracle Started)

Step 1 : I login user (ora<sid>) of Oracel to start up database

Database startup -> OK

then i tried to shutdown database -> OK too

and start up again -> OK

Query -> OK

I think Database do not problem

Step 2: start listener -> OK

Step 3: i login user (<sid>adm) and startup instance SAP (command : startsap r3) with error:

*******************************************************************************************

Checking SED Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

11:11:48 10.02.2010 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.90 700 - Intel x86 with Linux, PL:75, Aug 29 2006

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 6870) is already running .....

************************************************************************

saposcol already running

ABAP Database SED must be started first

********************************************************************************************

Please help me to resolve this problem

Thanks for your advice

[Former Member · Accepted solution]

Dear all

1. output listener.ora :

***********************************************************************************************************************************************************

1. listener.ora Network Configuration File: /oracle/SED/102_32/network/admin/listener.ora

2. Generated by Oracle configuration tools.

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle/SED/102_32)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = sapsed.fes.com.vn)(PORT = 1527))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

)

***********************************************************************************************************************************************************

2. output tnsname.ora:

***********************************************************************************************************************************************************

1. tnsnames.ora Network Configuration File: /oracle/SED/102_32/network/admin/tnsnames.ora

2. Generated by Oracle configuration tools.

################

1. Filename......: tnsnames.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

SED.WORLD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = sapsed)(PORT = 1527))

)

(CONNECT_DATA =

(SID = SED)

(GLOBAL_NAME = SED.WORLD)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

***********************************************************************************************************************************************************

Attention : I noticed that all of the group sapinst -> converted -> group 501 (I do not know the cause because I do not convert them)

example :

-rw-r-x--- 1 root sapinst 4291 Jan 18 12:17 initSED.2.ora (previously)

-rw-r-x--- 1 root 501 4291 Jan 18 12:17 initSED.2.ora (presently)

thanks for your advice

[former_member227283 · Accepted solution]

Hi,

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/SED/102_32)
      (PROGRAM = extproc)

what is a reason of keeping SID_NAME = PLSExrProc

it should SID_NAME = SED

Replace the above entry

then STOP database , Stop listner again start listner first then start database and run R3trans -d let us know what output come to re3trans command .

ouput should be return code 0

Thanks

Anil

[Former Member · Accepted solution]

A lot of things seem to have been messed up here.

TNS_ADMIN=/usr/sap/SED/SYS/profile/oracle

So user sedadm is using the tnsnames.ora file from the directory above, not the one you showed us.

And regarding changed groups:

Are all of your file systems local, or are some of them mounted over NFS?

[Former Member]

Dear all

My problem was resolved following :

I copy content of listener.ora and tnsname.ora of another system and then i changed SID

I started isntance SAP -> OK

thanks so much to Anil and others helped me

[Former Member]

Dear all !

1. output of tnsping SED :

***********************************************************************************************************************************************************

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 11-FEB-2010 13:51:24

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/oracle/SED/102_32/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = sapsed)(PORT = 1527))) (CONNECT_DATA = (SID = SED) (GLOBAL_NAME = SED.WORLD)))

OK (0 msec)

***********************************************************************************************************************************************************

2. output startsap_.log

***********************************************************************************************************************************************************

Checking SED Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

saposcol already running

ABAP Database SED must be started first

**********************************************************************************************************************************************************

---> output above repeats many

3. output trans.log

*******************************************************************************************************************************************************

4 ETW000 R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 11.02.2010 - 13:49:36

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Thu Feb 11 13:49:36 2010 159 0.000159

4 ETW000 [dev trc ,00000] db_con_init called 27 0.000186

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 55 0.000241

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SED/SYS/exe/run/dboraslib.so' ...

4 ETW000 63 0.000304

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/SED/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 16430 0.016734

4 ETW000 [dev trc ,00000] Library '/usr/sap/SED/SYS/exe/run/dboraslib.so' loaded

4 ETW000 56 0.016790

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/SED/SYS/exe/run/dboraslib.so

4 ETW000 41 0.016831

4 ETW000 [dev trc ,00000] Version of '/usr/sap/SED/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.73)

4 ETW000 94 0.016925

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/SED/SYS/exe/run/dboraslib.so

4 ETW000 38 0.016963

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/SED/SYS/exe/run/dboraslib.so

4 ETW000 68 0.017031

4 ETW000 [dev trc ,00000] New connection 0 created 44 0.017075

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 46 0.017121

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 38 0.017159

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 37 0.017196

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 39 0.017235

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 480 0.017715

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 42 0.017757

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 3789 0.021546

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 48 0.021594

4 ETW000 [dev trc ,00000] Connecting as /@SED on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 51 0.021645

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 43 0.021688

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x9511ea0 0x951750c 0x9516d94

4 ETW000 40 0.021728

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 40 0.021768

4 ETW000 [dev trc ,00000] Allocating server context handle 52 0.021820

4 ETW000 [dev trc ,00000] Attaching to DB Server SED (con_hdl=0,svchp=0x9516d20,svrhp=0x9528504)

4 ETW000 88 0.021908

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12505

4 ETW000 4712 0.026620

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12505'

4 ETW000 49 0.026669

4 ETW000 [dev trc ,00000] Try to connect with default password 62 0.026731

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@SED on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 39 0.026770

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 56 0.026826

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x9511ea0 0x951750c 0x9516d94

4 ETW000 47 0.026873

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x9528504)

4 ETW000 37 0.026910

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x9516d20,srvhp=0x9528504)

4 ETW000 37 0.026947

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x9528504 45 0.026992

4 ETW000 [dev trc ,00000] Allocating server context handle 48 0.027040

4 ETW000 [dev trc ,00000] Attaching to DB Server SED (con_hdl=0,svchp=0x9516d20,svrhp=0x9528504)

4 ETW000 60 0.027100

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12505

4 ETW000 1538 0.028638

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12505'

4 ETW000 41 0.028679

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12505 performing CON [dblink#3 @ 431]

4 ETW000 131 0.028810

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12505: TNS:listener does not currently know of SID given in connect descriptor [dblink#3 @ 431]

4 ETW000 39 0.028849

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SED'"

*******************************************************************************************************************************************************

thansk for your help

Edited by: myfriend280985 on Feb 11, 2010 7:53 AM

[former_member227283]

Hi,

You are already out of the oracle client error , you are getting know some different error

ETW000                                                                              88  0.021908
4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12505
4 ETW000                                                                            4712  0.026620
4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '12505'

paste the content of tnsname.ora and listner.ora in forum.

Thanks

Anil

[Former Member]

hi Anil

output:

*********************************************************************************************************************************************************

TERM=vt100

HOME=/home/sedadm

SHELL=/bin/csh

USER=sedadm

LOGNAME=sedadm

PATH=/oracle/SED/102_32/bin:/usr/java/j2sdk1.4.2_12/bin:.:/home/sedadm:/usr/sap/SED/SYS/exe/run:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin

HOSTTYPE=i386-linux

VENDOR=intel

OSTYPE=linux

MACHTYPE=i386

SHLVL=1

PWD=/home/sedadm

GROUP=sapsys

HOST=sapsed

REMOTEHOST=10.86.254.202

MAIL=/var/spool/mail/sedadm

HOSTNAME=sapsed

INPUTRC=/etc/inputrc

LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:.cmd=01;32:.exe=01;32:.com=01;32:.btm=01;32:.bat=01;32:.sh=01;32:.csh=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.zip=01;31:.z=01;31:.Z=01;31:.gz=01;31:.bz2=01;31:.bz=01;31:.tz=01;31:.rpm=01;31:.cpio=01;31:.jpg=01;35:.gif=01;35:.bmp=01;35:.xbm=01;35:.xpm=01;35:.png=01;35:.tif=01;35:

G_BROKEN_FILENAMES=1

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

KDEDIR=/usr

LANG=en_US.UTF-8

SUPPORTED=en_US.UTF-8:en_US:en

LESSOPEN=|/usr/bin/lesspipe.sh %s

SAPSYSTEMNAME=SED

DIR_LIBRARY=/usr/sap/SED/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/SED/SYS/exe/run:/oracle/client/10x_32/instantclient

JAVA_HOME=/usr/java/j2sdk1.4.2_12

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=SED

dbs_ora_schema=SAPSR3

ORACLE_SID=SED

DB_SID=SED

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/SED/SYS/profile/oracle

ORACLE_HOME=/oracle/SED/102_32

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/SED

*******************************************************************************************************************************************************

thanks for your advice

[Former Member]

Hi,

Eviornment variable are looking fine..

Can you also post trans.log and all startsap_.log file from home directory of SIDADM user.

Also post out put of tnsping SED

One more thing you can do, if you have backup of Kernel (SAR files), re-upgrade it... or Upgrade it with latest version..

At least R3Tools...

(I guess there may be some problem with kernel/R3tools because of sudden power down...)

Regards.

Edited by: Rajesh Narkhede on Feb 11, 2010 12:15 PM

Edited by: Rajesh Narkhede on Feb 11, 2010 12:16 PM

[former_member227283]

Hi,

Goto location /usr/sap/SED/SYS/exe/run and run following command and provide ouput on forum.

file dboraslib.so

Thanks

Anil

[Former Member]

Dear Rajesh Narkhede and Anil Bhandary

i am having more information after i did anythings below:

1. @ Rajesh

I did your comments

2. @ Anil

I type command ls -ltr and check softlink created for instantclient -> softlink not lose but I did to follow you

and outout command of R3trans -d below :

sapsed:sedadm 1> R3trans -d

This is R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SED'"

R3trans finished (0012).

output command of ldd `which dboraslib.so`| grep libclnt below :

sapsed:orased 1> ldd `which dboraslib.so`| grep libclnt

libclntsh.so.10.1 => /oracle/SED/102_32/lib/libclntsh.so.10.1 (0x00f38000)

But error remain

thanks for your help

[former_member227283]

Hi,

Login to OS with sedadm and type the below command

env

and proced the output on forum.

Thanks

Anil

[Former Member]

Dear all

output of commands following :

1. What is the output of this in Linux, as root user:

find / -name libclntsh.so.10.1

---> [root@sapsed ~]# find / -name libclntsh.so.10.1

/oracle/SED/102_32/lib/libclntsh.so.10.1

/oracle/client/10x_32/instantclient_10202/libclntsh.so.10.1

2. What is the output of this in Linux, as <sid>adm user:

ldd `which dboraslib.so`| grep libclnt

---> [root@sapsed ~]# su - sedadm

sapsed:sedadm 1> ldd `which dboraslib.so`| grep libclnt

libclntsh.so.10.1 => not found

maybe this problem !!!

thanks for your advice

[Former Member]

Hi,

It seems that there is some linking problem for "libclntsh.so.10.1"...

Just log in as ora<SID>

go to $ORACLE_HOME/bin directory

give #relink all command

It will resolve any linking problem or oracle binaries...

then stop all (listner, database, sap, etc ) and start it again with sequence LISTENER, DATABASE, SAP...

Regards.

Rajesh Narkhede

[former_member227283]

Hi,

---> root@sapsed ~# find / -name libclntsh.so.10.1
/oracle/SED/102_32/lib/libclntsh.so.10.1
/oracle/client/10x_32/instantclient_10202/libclntsh.so.10.1

2. What is the output of this in Linux, as <sid>adm user:
ldd `which dboraslib.so`| grep libclnt

---> root@sapsed ~# su - sedadm
sapsed:sedadm 1> ldd `which dboraslib.so`| grep libclnt
libclntsh.so.10.1 => not found

just to resolve your problem you can do the following steps

1. login to OS with orased

2. goto folder /oracle/client/10x_32

cd /oracle/client/10x_32

3. give command ls -ltr and check is there softlink created for instantclient , if there is no softlink then create the softlink as below

4. give the command as below

ln -s /oracle/client/10x_64/instantclient_10202 instantclient

5. check again the softlink is created or not , it should be look as below

instantclient -> /oracle/client/10x_64/instantclient_10202

6. now agin the check the command as gaurav provided earlier

ldd `which dboraslib.so`| grep libclnt

if it shows the proper out , then R3trans -d should work now

Other wise the best option is to RELINK the oracle binaries as said y RAJESH

Thanks

Anil

Edited by: Anil Bhandary on Feb 11, 2010 5:47 AM

[Former Member]

There seems to be a problem with file libclntsh.so.10.1

What is the output of this in Linux, as root user:

find / -name libclntsh.so.10.1

And expanding on Gaurav 's idea (I hadn't thought of ldd command):

What is the output of this in Linux, as <sid>adm user:

ldd `which dboraslib.so`| grep libclnt

[Former Member]

Dear all!

I did anythings in Note of Anil but can't not start instance SAP

thanks for your advice

[Former Member]

Hi,

try the following

go to exe directory with cdexe

then execute below command

ldd R3trans

see if it shows any file as not found.

the above command will check if all necessary lib files necessary for r3trans are available based on your environment settings.

Regards

Gaurav

-

---

[Former Member]

Hi,

one more suggestion Please try to check Oracle Client in /oracle/client

this folder will have 10x_64 or 92x_64 . in this folder required liberies are present to make connection with DB.

BR,

Vinod

[Former Member]

Hi,

One thing you can check...

Please backup your /sapmnt/<SID>/profile/oracle directory...

and copy sqlnet.ora, tnsnames.ora files from /oracle/<SID>/102_64/network/admin to /sapmnt/<SID>/profile/oracle

The try it should work...

Actually files from the both location should be identical..

Regards.

Rajesh Narkhede

[msrao67]

This resolved the issue.

[Former Member]

Dear all !

I checked at operating system level 5

All file systems properly mounted -> Yes

File /usr/sap/SED/SYS/exe/run/dboraslib.so existing -> Yes

Please help me

Thanks

[Former Member]

I still think that something might have got lost at power off.

In this case I think your best choice will be to follow the note mentioned by Anil above.

And by the way, check Linux log files for error messages at boot time.

Edited by: Joe Bo. on Feb 10, 2010 2:17 PM

[Former Member]

Dear !

i don't change any in /sapmnt/<SID>/exe and others

when system running but power off suddenly

and when power on -> error

I don't use storage

thanks

[former_member227283]

Hi,

refer the below note for the error which you are getting in R3trans -d

Note 538849 - UNIX: DLENOACCESS when loading dboraslib and libclntsh

pls do the activity as per point 10 present in SAP note.

Thanks

Anil

[Former Member]

when system running but power off suddenly
and when power on -> error

In case of a sudden power off, you may have lost some files or mount points.

This happens hardly ever, but it does happen sometimes.

Did you check at operating system level?

All file systems properly mounted?

File /usr/sap/SED/SYS/exe/run/dboraslib.so existing?

[Former Member]

Dear all!

More extra information :

logs trans.log file

***********************************************************************************************************************************************************

sapsed:sedadm 6> cat trans.log

4 ETW000 /sapmnt/SED/exe/R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 10.02.2010 - 15:25:51

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: /sapmnt/SED/exe/R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Feb 10 15:25:51 2010 160 0.000160

4 ETW000 [dev trc ,00000] db_con_init called 28 0.000188

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 54 0.000242

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SED/SYS/exe/run/dboraslib.so' ...

4 ETW000 64 0.000306

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= libclntsh.so.10.1: cannot open shared object file: No such file or directory -> DLENOACCESS (0,Success)

4 ETW000 521 0.000827

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/SED/SYS/exe/run/dboraslib.so'

4 ETW000 45 0.000872

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SED/SYS/exe/run') or dbms_type ('ORA')"

*******************************************************************************************************************************************************

Thanks for your advice

[former_member227283]

Hi,

Did you made any change in /sapmnt/<SID>/exe ??

did you update any kernel file i.e any file of /sapmnt/<SID>/exe

Thanks

Anil

[nirmal_konchada]

Are your mount points on storage??????????

If yes then please check whether all the mount points are still in tact and your storage is up and running.

Regards,

Nirmal.K

[Former Member]

Dear all

1. logs in dev_w0 file :

***********************************************************************************************************************************************************

M Mon Feb 8 14:50:25 2010

M *** WARNING => ThSndDelUser: delete client/user 001/THUYNTT (T21) on server sapsed_SED_00

A

A Tue Feb 9 01:01:42 2010

A generated report /1BCF41/TVBUR with fingerprint DE242C52C7D4C5E3BA15E33C1DACA942| 19389

A

A Tue Feb 9 01:04:29 2010

A generated report SAPLWR22 with fingerprint 29FEBE593B0E9B336D237F2372D2737B| 334343

A

A Tue Feb 9 01:15:21 2010

A generated report SAPLSPROJECT_SOLAR_BASIS with fingerprint 5D513EF9B44B2B54C20F800CDC13862C| 25503

A

A Tue Feb 9 01:16:29 2010

A generated report PCA_TP_FIND with fingerprint A1135F2B8B458780F9FCEFC0E0AAB613| 150491

A

A Tue Feb 9 01:16:37 2010

A generated report %_CGSTC with fingerprint 0FE0BE95B30588F6093A9E326DA8C64F| 6139

A generated report SAPLPCA_SD with fingerprint EB573F780694FE352ECB3C162968BA9B| 18232

A

A Tue Feb 9 01:16:38 2010

A generated report SAPLPCA_TPVAR with fingerprint 94C32444EE6435B18C5ABC5A7E88CBE1| 13820

A

A Tue Feb 9 14:01:04 2010

A generated report SAPLKAPS with fingerprint 4BF4F7B8EF5F62C200D1989D75775C7A| 21814

A

A Tue Feb 9 14:01:11 2010

A generated report SAPLKALL with fingerprint 64BF7719421A90917D38DEE90FEFA77A| 76530

X

X Tue Feb 9 14:13:21 2010

X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1

X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1

X

X Tue Feb 9 14:13:22 2010

X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1

X

X Tue Feb 9 14:13:23 2010

X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1

X

X Tue Feb 9 14:15:02 2010

X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1

X

X Tue Feb 9 14:15:10 2010

X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1

A

A Tue Feb 9 15:26:02 2010

A generated report /1BCF41/TVPT with fingerprint 59DB37C5D9459C6510C10DF54CD7C7A1| 15909

A

A Tue Feb 9 15:31:30 2010

A generated report /1BCF41/T087G with fingerprint 8F1ED0BA04D126653333B29C7992ACFF| 15685

A

A Tue Feb 9 16:20:53 2010

A Negative refCount for object x SAPLSDIFRUNTIME .

A Negative refCount for object v DD05M .

A Negative refCount for object x SAPLSDTB .

A Negative refCount for object v DDFTX .

A Negative refCount for object x SAPLSENA .

A Negative refCount for object x CL_GUI_CONTAINER==============CP .

***********************************************************************************************************************************************************

2. Output command R3trans -d

*******************************************************************************************************************************************************

This is /sapmnt/SED/exe/R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SED/SYS/exe/run') or dbms_type ('ORA')"

/sapmnt/SED/exe/R3trans finished (0012).

*******************************************************************************************************************************************************

Thanks for your advice

[Former Member]

Dear all!

my database running -> OK

Step 1: I login user ora<sid> and start database following:

ora<sid> # sqlplus / as sysdba

sql > startup; -> OK (database Open)

and then I tried to shutdown databse with command

sql > shutdown immediate -> OK

my database do not at Mount mode

Step 2: start listener -> OK

Step 3: start instance SAP -> with error

I don't find dev_w0 log, where ? please show me path

thanks

[former_member227283]

Hi,

goto to following path /usr/sap/<SID>/DVEBMGS<NN>/work/

AS well can u check the below command

R3trans -d

check the ouput , if you get the error for above command then paste the error present in trans.log file.

file will in the location from where you have run the above command

Thanks

Anil

Edited by: Anil Bhandary on Feb 10, 2010 8:20 AM

[former_member227283]

Hi,

As BABU said check your database status.

it might be sudden restart of your OS , you database may have gone in recovery mode.

If your database is in recovery mode , the startup command provided by BABU will make instant recover of your database.

once database is started you can start you SAP , using startsap command.

Thanks

Anil

[Former Member]

Hi,

From the error log understand that SED is your SID. Please check if the database is completely open or in mount state.

Also, check the error log in dev_w0 and paste the log here. Before that, please start the database manually and see if it is completely opening the database or only up to mount state.

To shutdown the database

sqlplus /nolog

conn / as sysdba

Shutdown Immediate

To start the database

Sqlplus /nolog

conn / as sysdba

Startup

See if it says database opened and then you start the SAP. Even then any issue comes up then check the log in dev_W0 abd paste it here.

Thanks & Regards,

Sharath Babu M