Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
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