Operating System - HP-UX
1748123 Members
3260 Online
108758 Solutions
New Discussion юеВ

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

 
SOLVED
Go to solution
Sanjay Kumar Suri
Honored Contributor

Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

We have done R3copy from a live production system to a test system with a new sid and hostname.

Both the system have the same version of Oracle(9.2.0.5) and HP-UX (11.11).

Now are able to start Oracle from ora. However it is not starting using adm and give the following errror in startdb.log:

/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.9.0'.
/usr/sap/QEW/SYS/exe/run/startdb[228]: 12835 Killed

Similarly while trying to stop SAP/Oracle from adm we are getting the following error in stopdb.log:

/usr/lib/pa20_64/dld.sl: Unable to find library 'libwtc9.sl'.
/usr/sap/QEW/SYS/exe/run/stopdb[2]: 12306 Killed

Urgent help will be highly appreciated.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
24 REPLIES 24
Indira Aramandla
Honored Contributor

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

Hi SKS,

This could be because you do not have any reference to $ORACLE_HOME/lib in your LD_LIBRARY_PATH or any links to $ORACLE_HOME/lib, so the command cannot find libclntsh.sl.9.0.

You can either set your LD_LIBRARY_PATH or link to your $ORACLE_HOME/lib from
/usr/lib.

Then create a link from the libclntsh alias under /usr/lib to the libclntsh file in the $ORACLE_HOME/lib directory.

ln -s $ORACLE_HOME/lib/libclntsh.so.1.0 /usr/lib/libclntsh.so.1.0

check the ldd command

I hope this helps

Indira A
Never give up, Keep Trying
Eric Antunes
Honored Contributor

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

Hi Sanjay,

See this thread on Metalink:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=504521.994

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Yogeeraj_1
Honored Contributor

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

hi,

below a quote from man ld:


Some restrictions exist for 64-bit mode with executables built with shared libraries and with S-bit set (through +s enabled). The behavior of 64-bit executables does not match the behavior of equivalent 32-bit executables or executables built with +compat. For any setuid or setgid programs, dld disables any dynamic library searching through environment variables, SHLIB_PATH for 32-bit and 64-bit mode, and LD_LIBRARY_PATH for 64-bit mode. If a library only exists in the directory specified in SHLIB_PATH (or LD_LIBRARY_PATH),
you get the runtime error "library not found" if the program is a setuid program (that is, uid not equal to euid or gid not equal to
eguid) and it depends on that library. dld uses the dynamic path lookup (with SHLIB_PATH) only if the following conditions are satisfied: getuid () == geteuid () && getgid () == getegid (). That is, if the uid or gid does not match its effective counterpart, dld searches only the recorded library path. As a result, dld does not check the SHLIB_PATH which causes the runtime error "library not found".



this can be related...

hope this helps too!

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Fred Ruffet
Honored Contributor

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

Hi,

Your adm user must have $LD_LIBRARY_PATH with $ORACLE_HOME/lib included in his env.
A line like this in his profile sould be ok :
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Sanjay Kumar Suri
Honored Contributor

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

Hello Indira

As suggested we did the following:

1. Defined LD_LIBRARY_PATH in .dbenv_.csh
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib

2. cd /usr/lib
ln -s $ORACLE_HOME/lib/libclntsh.so.1.0 /usr/lib/libclntsh.so.1.0

Now when starting Oracle database the message is:

/usr/lib/pa20_64/dld.sl: Unable to find library 'libodm9.sl'.

We again did the ln -s for 'libodm9.sl' but same error. Any more clues?

We are not sure on ldd command.

Dear Eric: We don't have Oracle support. Can you download and send the page as an attachment.

Dear Yogi: Not able to process your reply. Need more inputs.

Dear Fred: Thanks.


sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Fred Ruffet
Honored Contributor

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

Making links for all libs may not be a solution cause there are really a lot...

What can be done is to issue the command
ldd $ORACLE_HOME/bin/oracle
with oracle user and adm user.

First one will resolve all dependances, whereas second will show you missing dependances. Adding pathes to adm $PATH var will probably solve the problem.

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Sanjay Kumar Suri
Honored Contributor

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

Hello Fred

Using the adm user (ldd output is)
ldd oracle
Unable to find library 'libodm9.sl'.

What next?


sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Fred Ruffet
Honored Contributor

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

You said you made a copy of Oracle from a server to another... On the same PATH ? Did you relink oracle kernel ?

if not, stop all running DBs, and issue "relink all" connected as oracle user.

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Eric Antunes
Honored Contributor

Re: Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

Hi Sanjay,

Here is the thread in attach.

I really hope this will help you but, reading it I didn't understood much...!

Eric

Each and every day is a good day to learn.