on 05-07-2012 9:20 AM
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
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 .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Fix the environment variable in user profiles (/home/sidadm, /home/orasid)
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.