cancel
Showing results for 
Search instead for 
Did you mean: 

sqlplus starting issue

shirish11
Advisor

sqlplus starting issue

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
7 REPLIES
Horia Chirculescu
Honored Contributor

Re: sqlplus starting issue

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.
Best regards from Romania,
Horia.
shirish11
Advisor

Re: sqlplus starting issue

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
Horia Chirculescu
Honored Contributor

Re: sqlplus starting issue

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.
Best regards from Romania,
Horia.
Raj D.
Honored Contributor

Re: sqlplus starting issue

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.
" If u think u can , If u think u cannot , - You are always Right . "
shirish11
Advisor

Re: sqlplus starting issue

I got a sol when i set ld_lib_path properly
Thanks
Horia Chirculescu
Honored Contributor

Re: sqlplus starting issue

>I got a sol when i set ld_lib_path properly

You mean LD_LIBRARY_PATH, right?

Best regards
Horia.
Best regards from Romania,
Horia.
shirish11
Advisor

Re: sqlplus starting issue

yes