cancel
Showing results for 
Search instead for 
Did you mean: 

LD_LIBRARY_PATH is not set

Former Member
0 Kudos

Hi All,

I had recently updated oracle server from 10G to 11G. but sap is not up when checked R3trans -d it gives me return code 12.

further i checked all the environment variable and found tha it is taking oracle 10G client after that i have set following environment variable,

setenv LD_LIBRARY_PATH /usr/sap/SID/SYS/exe/run:/oracle/client/10x_64/instantclient

and problem resolved. but i think so setenv set temporary so how to set this value permenently.

i am facing this problem on HP-UNIX.

From,

Ketan Kapadi

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Ketan ,

Login to the server as ORA<SID> and change to the home directory .

You can set the change as permanent by editing the value in the .dbenv_<server_name>.sh file . This is a hidden file and hence use the -a option in ls command to view the same .

To ensure that there are not any other files in which this change should be made , try the below command for searching the files which have the value.

find . -type f -exec grep -l "LD_LIBRARY_PATH" {} /dev/null \;

and make the changes in the required .sh and .csh files

the command should be run in the ORASID home directory .

Hope this helps .

Former Member
0 Kudos

I have updated from 10G to 11G afterword i am getting this problem. now after restart i am again facing the proble and set the LD_LIBRARY_PATH as well as SHLIB_PATH and checked the following files

Using the vi editor to edit all the sh and csh files, search and replace 102_64 with 112_64 and 10x_64 with 11x_64 for both user sidadm and orasid.

Available in following files

.dbenv.csh

.dbenv_ep2dev.sh

.dbenv.sh

.dbenv_ep2dev.csh

still when i excute getting the following error,

ETW000  [    dlux.c  ,00000]  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("

/usr/sap/BD1/SYS/exe/run/dboraslib.so") FAILED

4 ETW000                          "Unable to find library 'libclntsh.so.10.1'."

                         993  0.001381

4 ETW000  [    dbcon.c ,00000]  *** ERROR => Couldn't load library '/usr/sap/BD1

/SYS/exe/run/dboraslib.so'

@

Please check and update.

From,

Ketan Kapadi

Former Member
0 Kudos

Hi Ketan,

Execute the command, below;

ln -s /oracle/client/11x_64 /oracle/client/10x_64

Best regards,

Orkun Gedik

Former Member
0 Kudos

Dear Orkun,

During Upgrade we have link as below,

create a symbolic link in $ORACLE_HOME/lib as follows:

cd $ORACLE_HOME/lib

ln –s libnnz11.so libnnz10.so

Execute the following commands as ora<dbsid> user:

cd $ORACLE_HOME/lib

ls -l libnnz*

ln -s libnnz11.so libnnz10.so

ls -l libnnz*

Create a symbolic link from 'instantclient_<release>' to 'instantclient' with the following command:

ln -s instantclient_<release> instantclient

and when i add $ORACLE_HOME/lib to variable LD_LIBRARY_PATH sap is starting temp. but once i restart the server i need to to set the again same variable.

as 10g  we are not using what is the need of the

ln -s /oracle/client/11x_64 /oracle/client/10x_64

because we have updated with the same procedure in another development server and it is running fine.  Request you to update on the same.

From,

Ketan Kapadi

Former Member
0 Kudos

Additionally, check the note Note 819829 - Oracle Instant Client Installation and Configuration on Unix

Best regards,

Orkun Gedik

Former Member
0 Kudos

thanks for checking for both SIDADM and ORASID .

in addition to the files you mentioned , you may also have to update the value of the Environment variable in the

.sapenv.csh

.sapenv_ep2dev.sh

.sapenv.sh

.sapenv_ep2dev.csh

files .

Former Member
0 Kudos

For HP-UX SHLIB_PATH is used instead of LD_LIBRARY_PATH.

You can find the files where you have to change with the grep command:

cd; grep SHLIB_PATH .*

Cheers Michael

Former Member
0 Kudos

Fix the environment variable in user profiles (/home/sidadm, /home/orasid)

Regards,

Nick Loy