topic sqlplus starting issue in Operating System - HP-UX

sqlplus starting issue

shirish11 — Mon, 21 Mar 2011 04:08:13 GMT

for starting sqlplus in HP-UX 11.23 9000/800
getting issue?
/usr/lib/pa20_64/dld.sl: Unsatisfied data symbol 'nltrc_exit' in load module '/oracle/10.2.0/product/lib/libnnz10.sl'.
/usr/lib/pa20_64/dld.sl: Unsatisfied data symbol 'nltrc_entry' in load module '/oracle/10.2.0/product/lib/libnnz10.sl'.
/usr/lib/pa20_64/dld.sl: Unsatisfied data symbol 'nzdacvalue' in load module '/oracle/10.2.0/product/lib/libnnz10.sl'.
Killed

Re: sqlplus starting issue

Horia Chirculescu — Mon, 21 Mar 2011 04:53:11 GMT

Maybe you have something wrong with the library paths? Did you try to migrate from PA-RISC to Itanium? Is it a new ORACLE installation?

You could run ldd against sqlplus in order to find out which libraries are supposed to be linked dinamically (and from where):

ldd /absolute_path_to_sqlplus_binary/sqlplus

Best regards from Romania,
Horia.

Re: sqlplus starting issue

shirish11 — Mon, 21 Mar 2011 04:55:07 GMT

hi I just check In hp is shlib_path or ld_library_path needed to set that i Have a confusion on that..which one it will take on high priority?
thanks

Re: sqlplus starting issue

Horia Chirculescu — Mon, 21 Mar 2011 05:01:28 GMT

Hello,

As ususal, read the docs:

man dld.sl

The LD_LIBRARY_PATH will be searched 1st and SHLIB_PATH next.

LD_LIBRARY_PATH is the "new" thing. You should add new paths there.

Best regards
Horia.

Re: sqlplus starting issue

Raj D. — Mon, 21 Mar 2011 05:14:26 GMT

shirish11,
Please check ,

$ echo $PATH
$ echo $ORACLE_HOME
$ echo $LD_LIBRARY_PATH

$ ls -l /usr/lib/pa20_64/dld.sl
$ ls -l /oracle/10.2.0/product/lib/libnnz10.sl
$ ldd -d /oracle/10.2.0/product/lib/libnnz10.sl

Seems some issue with the path, and not defined properly

Hth,
Raj.

Re: sqlplus starting issue

shirish11 — Mon, 21 Mar 2011 05:16:33 GMT

I got a sol when i set ld_lib_path properly
Thanks

Re: sqlplus starting issue

Horia Chirculescu — Mon, 21 Mar 2011 05:20:09 GMT

>I got a sol when i set ld_lib_path properly

You mean LD_LIBRARY_PATH, right?

Best regards
Horia.

Re: sqlplus starting issue

shirish11 — Mon, 21 Mar 2011 08:26:53 GMT

yes