I am not able to shutdown the database by using stopsap

[Former Member]

Dear all,

As mentioned in the subject "I am not able to shutdown the database by using stopsap". I am getting the following errors:

exec(): 0509-036 Cannot load program oracle<SID> because of the following errors:

0509-150 Dependent module libjox9.a(shr.o) could not be loaded.

0509-022 Cannot load module libjox9.a(shr.o).

0509-026 System error: A file or directory in the path name does not exist

R3 is terminated correctly by using the command stopsap and also I am able to shutdown the database normally by using the SQL command.

Thanks for your cooperation.

Maher

[Former Member · Accepted solution]

Hi Maher,

i'm afraid you don't have really a chance to get an answer to this question in this forum.

Maybe you repost it at

Regards

Stefan

Message was edited by: Mark Finnern

Thanks Stefan. I moved the thread, Mark.

[Former Member · Accepted solution]

Thank you Stefan

[Former Member]

Check the user environment for your Web AS user <SID>adm and your Oracle user ora<SID>.

Can you stop/start the DB from <SID>adm using:

sqlplus /nolog

connect / as sysdba

shutdown normal

???

Depending on your OS you are missing LIBPATH or LD_LIBRARY_PATH (the path to your libraries)

Nick

[Former Member]

Hi Nick,

I am able to startup and shudown the database by using:

sqlplus "/ as sysdba"

shutdown normal

startup

I Checked LIBPATH, it is there for both users <SID>ADM and ORA<SID>.

Thank you.

[Former Member]

Can you do the manual start/stop as both app and ora user?

Is LIBPATH the same for both users?

Can you check ownership/permission of the two files?

Nick

[Former Member]

Thank you Nick for your care.

I will test start/stop manually later; because the system is active and used by the users for testing purpose (not production).

Yes, LIBPATH is the same for both users.

The ownership/permisssion for the both files is

-rwxr-xr-x 1 <SID>adm sapsys stopdb

-rwxr-xr-x 1 <SID>adm sapsys startdb

I compared with production, it seems ok.

*****

I started DBCheck by using the transaction DB13 and also it failed due to same errors.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000272, user name ****)

No application server found on database host

Execute logical command BRCONNECT On host *******

Parameters: -u / -c -f check

BR801I BRCONNECT 6.20 (113)

exec(): 0509-036 Cannot load program oracle<SID>because of the following errors:

#0509-150 Dependent module libjox9.a(shr.o) could not be loaded.

#0509-022 Cannot load module libjox9.a(shr.o).

#0509-026 System error: A file or directory in the path name does not exist.

BR805I Start of BRCONNECT processing: cdnybrme.chk 2004-08-11 08.27.04

exec(): 0509-036 Cannot load program oracle<SID> because of the following errors:

#0509-150 Dependent module libjox9.a(shr.o) could not be loaded.

#0509-022 Cannot load module libjox9.a(shr.o).

#0509-026 System error: A file or directory in the path name does not exist.

BR280I Time stamp 2004-08-11 08.27.07

BR301E SQL error -12547 at location db_connect-2

ORA-12547: TNS:lost contact

BR310E Connect to database instance <SID> failed

exec(): 0509-036 Cannot load program oracle<SID> because of the following errors:

#0509-150 Dependent module libjox9.a(shr.o) could not be loaded.

#0509-022 Cannot load module libjox9.a(shr.o).

#0509-026 System error: A file or directory in the path name does not exist.

BR280I Time stamp 2004-08-11 08.27.07

BR301E SQL error -12547 at location thr_db_connect-4

ORA-12547: TNS:lost contact

BR310E Connect to database instance <SID> failed

BR806I End of BRCONNECT processing: cdnybrme.chk 2004-08-11 08.27.07

BR280I Time stamp 2004-08-11 08.27.07

BR804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Do you think that we need to rebuild the Oracle Software ?

Thank in advance for your cooperation.

Maher.

Message was edited by: Maher M.