on 06-26-2012 8:58 AM
hi all,
I have upgraded oracle from 10.2.0.2 to 10.2.0.5 while the version of oracle client is still showing 10.2.0.2. now I want to upgrade the version of Oracle client from 10.2.0.2 to 10.2.0.5. I am following SAP Note 819829 while please check the steps and guide/correct me.
i. stopsap all
ii. lsnrctl stop
iii. saposcol -k
3. Change to this directory and extract the instant client package with
root>./SAPCAR -xvf OCL10264.SAR
output folder: instantclient_10205
4. Create a symbolic link from 'instantclient_<release>' to
'instantclient' with the following command:
OS> ln -s instantclient_<release> instantclient
[root@saplinux OCL10205]# ln -s /PRD/10205/OCL10205/instantclient_10205 /oracle/client/10x_64/instantclient
5.
Check if the SAP DBSL can load the newly installed instant client
correctly. Change to the exe directory as user <sapsid>adm and run the
ldd command on dboraslib.so:
[root@saplinux exe]# su lnxadm
saplinux:lnxadm 2> ldd dboraslib.so
libdl.so.2 => /lib64/libdl.so.2 (0x00002aaaaaf3e000)
librt.so.1 => /lib64/librt.so.1 (0x00002aaaab142000)
libclntsh.so.10.1 => not found
libnnz10.so => not found
libc.so.6 => /lib64/libc.so.6 (0x00002aaaab34c000)
libstdc++.so.5 => /usr/lib64/libstdc++.so.5 (0x00002aaaab69c000)
libm.so.6 => /lib64/libm.so.6 (0x00002aaaab978000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002aaaabbfb000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00002aaaabe09000)
/lib64/ld-linux-x86-64.so.2 (0x0000555555554000)
If that succeeds, verify that the SAP system is able to connect to the
database with
OS> R3trans -x
at this stage: the sqlplus is down and lsnrctl service is stopped. So, I have to start the lsnrctl and sqlplus if i want to check the the status of R3trans
Operating in Instant Client mode.
Small timezone file = timezone_14.dat
Large timezone file = timezlrg_14.dat
and
Operating in ORACLE_HOME environment.
Small timezone file = <ORACLE_HOME>/oracore/zoneinfo/timezone_14.dat
Large timezone file = <ORACLE_HOME>/oracore/zoneinfo/timezlrg_14.dat
how and where I have to set Small/Large timezone file?
what is the Operating in Instant Client mode and Operating in ORACLE_HOME environment?
Regards,
When you are in the Instant Client mode then it means that you have set the environment variable pointing to the path in which instantclinet shared libraries. Check the following environmet variables -:
LD_LIBRARY_PATH, LIBPATH on AIX, and SHLIB_PATH on HP-UX
If in the oracle home mode then the environment variable would point to the oracle home libraries which menas that these libraries are to be used.
For the Small/Large timezone file check the following path $ORACLE_HOME/oracore/zoneinfo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Faiz,
I am trying to upgrade Oracle client on RHEL.
how and where I have set these variable mean in .bash_profile file or simply I can set with export command.
while the value of above parameters is :
with root user:
[root@saplinux ~]# echo $ORACLE_HOME
[root@saplinux ~]# su lnxadm
with SIDadm user:
saplinux:lnxadm 2> echo $ORACLE_HOME
/oracle/LNX/102_64
saplinux:lnxadm 5> echo $LD_LIBRARY_PATH
/usr/sap/LNX/DVEBMGS00/exe:/usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient
saplinux:lnxadm 6> echo $LIBPATH
/usr/sap/LNX/DVEBMGS00/exe:
now what is next step to complete.
Regards,
Dear Jamil,
Check the shell from the following command at the OS level -:
echo $SHELL
if it displays -: /bin/csh then you can user the setenv command to set the environment varaibles.
example -: setenv LD_LIBRARY_PATH
/usr/sap/LNX/DVEBMGS00/exe:/usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient
For the details regarding what environment variables to set the below mentioned notes can be referred -:
96858 , 602843
Regards,
Faiz
Here are some of the Environment Variable Examples for <SID>adm user -:
DIR_LIBRARY Like -> /usr/sap/<SID>/SYS/exe/run
LD_LIBRARY_PATH Like -> /usr/sap/<SID>/SYS/exe/run:/usr/sap/<SID>/SYS/exe/uc/linuxx86_64:/oracle/client/11x_64/instantclient
SAPEXE Like -> /usr/sap/<SID>/SYS/exe/run
dbms_type Like -> ORA
dbs_ora_tnsname Like-> <SID>
dbs_ora_schema Like-> SAPSR3
ORACLE_SID Like-> <SID>
DB_SID Like -> <SID>
ORACLE_BASE Like-> /oracle
TNS_ADMIN Like -> /usr/sap/<SID>/SYS/profile/oracle
ORACLE_HOME Like -> /oracle/<SID>/112_64
NLS_LANG Like -> AMERICAN_AMERICA.UTF8
SAPDATA_HOME Like -> /oracle/<SID>
Dear Faiz,
thanks for reply,
here out of said command:
[root@saplinux ~]# echo $SHELL
/bin/bash
here showing /bin/bash mean I can set parameter with the help of export command
please tell me that where I have to set these parameters mean I can set with export command or I have to put these value in .bash_profile
now.. when i am trying to startsap db/r3/all then getting following error:
/usr/sap/LNX/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed
while the status of LD_LIBRARY_PATH.
root user:
[root@saplinux ~]# echo $LD_LIBRARY_PATH
/usr/sap/LNX/DVEBMGS00/exe:/usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient
oraSID user
saplinux:oralnx 1> echo $LD_LIBRARY_PATH
/usr/sap/LNX/DVEBMGS00/exe:/usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient:/oracle/LNX/102_64/lib
SIDadm User
saplinux:lnxadm 1> echo $LD_LIBRARY_PATH
/usr/sap/LNX/DVEBMGS00/exe:/usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient
Regards,
Dear Faiz,
now I am getting following errors:
startsap all
/usr/sap/LNX/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed
while
saposcol -k
saplinux:lnxadm 2> saposcol -k
Setting Stop Flag :
17:01:22 02.07.2012 LOG: ==== Stop Flag was set by saposcol (kill_collector()).
17:01:22 02.07.2012 LOG: ==== The collection process will stop as soon as possible
Collecting process has stopped.
17:01:23 02.07.2012 ERROR: ShmCleanup failed (rtc = 1)
Regards,
hi Roman,
Dear, please find the logs
startdb.log
Connect to the database to verify, that the database is now open
R3trans check finished with return code: 12
*** ERROR: Startup of database failed
Notify Database Administrator.
Trans.log
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Tue Jul 3 12:15:45 2012 110 0.000110
4 ETW000 [dev trc ,00000] db_con_init called 22 0.000132
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 33 0.000165
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/LNX/SYS/exe/run/dboraslib.so' ... 48 0.000213
4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/LNX/SYS/exe/run/dboraslib.so") FAILED
4 ETW000 "libclntsh.so.10.1: cannot open shared object file: No such file or directory"
4 ETW000 360 0.000573
4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/LNX/SYS/exe/run/dboraslib.so'
4 ETW000 86 0.000659
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/LNX/SYS/exe/run') or dbms_type ('ORA')"
while the status of parameters is:
[root@saplinux exe]# su lnxadm
saplinux:lnxadm 1> echo $dbms_type
ORA
saplinux:lnxadm 2> echo $DIR_LIBRARY
/usr/sap/LNX/SYS/exe/run
while
status of ldd dboraslib.so is :
[root@saplinux exe]# ldd dboraslib.so
libdl.so.2 => /lib64/libdl.so.2 (0x00002aaaaaf50000)
librt.so.1 => /lib64/librt.so.1 (0x00002aaaab154000)
libclntsh.so.10.1 => not found
libnnz10.so => not found
libc.so.6 => /lib64/libc.so.6 (0x00002aaaab35e000)
libstdc++.so.5 => /usr/lib64/libstdc++.so.5 (0x00002aaaab6ae000)
libm.so.6 => /lib64/libm.so.6 (0x00002aaaab98a000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002aaaabc0d000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00002aaaabe1b000)
/lib64/ld-linux-x86-64.so.2 (0x0000555555554000)
the status of startsap all and stopsap all
startsap all
Starting SAP Instance DVEBMGS00
------------------------------
Startup-Log is written to /home/lnxadm/startsap_DVEBMGS00.log
Instance Service on host saplinux started
Instance on host saplinux started
stopsap all
/usr/sap/LNX/SYS/exe/run/stopdb completed successfully
Checking LNX Database
------------------------------
ABAP Database is not available via R3trans (why db is not available via R3trans)
when I reboot my system then I got again same error.
/usr/sap/LNX/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed
I hope, I am getting above issue due to some environmental variables which are not permanently saved.
There are .bash_profile some others files exist in /root and /home/sidadm directories. now where and inwhich file I have to put the variable and which variable for permanent setting.
Regards,
Dear Jamil,
Please provide the following additional output also -:
cd /usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient
ls -lrt
cd /usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient/instantclient_10205
ls -lrt
From the current working directory execute the following -:
./genezi -v
Regards,
Faiz
Ah ,, sorry I missed the proper path in my previous reply -:
Please provide the following additional output also -:
cd /oracle/client/10x_64/instantclient
ls -lrt
cd /oracle/client/10x_64/instantclient/instantclient_10205
ls -lrt
From the current working directory execute the following -:
./genezi -v
Now it seems to be correct.
hi Faiz,
Dear,
I already told you that instantclient folder doest not exit under /oracle/client/10x_64 while the result of said command.
[root@saplinux instantclient]# ls -lrt
total 104316
-r-xr-xr-x 1 root root 75168 Mar 15 16:15 genezi
-r-xr-xr-x 1 root root 67534929 Mar 15 16:15 libociei.so
-r--r--r-- 1 root root 2734875 Mar 15 16:15 ojdbc6.jar
-r--r--r-- 1 root root 1579055 Mar 15 16:15 ojdbc14.jar
-r-xr-xr-x 1 root root 7847025 Mar 15 16:15 libnnz10.so
-r--r--r-- 1 root root 1629710 Mar 15 16:15 classes12.jar
-rwxrwxrwx 1 root root 25261176 Mar 15 16:15 libclntsh.so.10.1
-r--r--r-- 1 root root 5013 Mar 15 16:15 SAPIC_README
lrwxrwxrwx 1 root root 17 Jul 3 10:05 libclntsh.so -> libclntsh.so.10.1
and
[root@saplinux instantclient_10205]# ls -lrt
total 104316
-r-xr-xr-x 1 root root 75168 Mar 15 16:15 genezi
-r-xr-xr-x 1 root root 67534929 Mar 15 16:15 libociei.so
-r--r--r-- 1 root root 2734875 Mar 15 16:15 ojdbc6.jar
-r--r--r-- 1 root root 1579055 Mar 15 16:15 ojdbc14.jar
-r-xr-xr-x 1 root root 7847025 Mar 15 16:15 libnnz10.so
-r--r--r-- 1 root root 1629710 Mar 15 16:15 classes12.jar
-rwxrwxrwx 1 root root 25261176 Mar 15 16:15 libclntsh.so.10.1
-r--r--r-- 1 root root 5013 Mar 15 16:15 SAPIC_README
lrwxrwxrwx 1 root root 17 Jul 3 10:05 libclntsh.so -> libclntsh.so.10.1
saplinux:lnxadm 2> ./genezi -v
Client Shared Library 64-bit - 10.2.0.5.0
System name: Linux
Release: 2.6.18-53.el5xen
Version: #1 SMP Wed Oct 10 16:48:44 EDT 2007
Machine: x86_64
while still getting ABAP Database is not available via R3trans when i run stopsap all.
Regards,
Can you run the command under /oracle/client/10x_64 as ora<sid>
ln -s instantclient_10205 instantclient
This would create a soft link from instantclient to instantclient_10205. When you go to instanclient directory you should go to instantclient_10205. The Library is lpointing to /oracle/client/10x_64/instantclient and it should automatically go the /oracle/client/10x_64/instantclient_10205 using the soft link. This is how it works.
Regards
Ratnajit
hi Ratnajit,
Can you run the command under /oracle/client/10x_64 as ora<sid>
ln -s instantclient_10205 instantclient
when I am trying to create link then getting following Permission Denied message.
saplinux:oralnx 9> ls -lrt
total 56
-rwxrwxr-x 1 lnxadm sapsys 33 Mar 27 2006 dbclient.lst
drwxrwxr-x 2 oralnx dba 4096 Mar 15 16:15 instantclient_10205
drwxr-xr-x 2 lnxadm sapsys 4096 Jun 29 12:12 10202
drwxrwxr-x 2 lnxadm sapsys 4096 Jun 29 12:59 instantclient_10202
-rw-r----- 1 lnxadm sapsys 1438 Jul 2 16:26 sqlnet.log
-rw-r--r-- 1 lnxadm sapsys 1402 Jul 3 08:28 dev_sapstart
-rw-r--r-- 1 lnxadm sapsys 29628 Jul 3 14:44 trans.log
saplinux:oralnx 10> ln -s instantclient_10205 instantclient
ln: creating symbolic link `instantclient' to `instantclient_10205': Permission denied
which permission i have to assign to oraSID user.
Regards,
please check persmision:
saplinux:oralnx 11> ll
total 8
drwxrwxr-x 5 lnxadm sapsys 4096 Jul 3 16:18 10x_64
and
saplinux:oralnx 15> ls
10202 dev_sapstart instantclient_10205 trans.log
dbclient.lst instantclient_10202 sqlnet.log
saplinux:oralnx 16> ll
total 56
drwxrwxr-x 2 lnxadm sapsys 4096 Jun 29 12:12 10202
-rwxrwxr-x 1 lnxadm sapsys 33 Mar 27 2006 dbclient.lst
-rwxrwxr-x 1 lnxadm sapsys 1402 Jul 3 08:28 dev_sapstart
drwxrwxr-x 2 lnxadm sapsys 4096 Jun 29 12:59 instantclient_10202
drwxrwxr-x 2 oralnx dba 4096 Jul 3 15:55 instantclient_10205
-rwxrwxr-x 1 lnxadm sapsys 1438 Jul 2 16:26 sqlnet.log
-rwxrwxr-x 1 lnxadm sapsys 29628 Jul 3 14:44 trans.log
saplinux:oralnx 17> ln -s instantclient_10205 instantclient
ln: creating symbolic link `instantclient' to `instantclient_10205': Permission denied
while link is established with the help of root and SIDadm user.
regards
Please do the following under <sid>adm user:
1) check that <sid>adm is owner of /oracle/client/10x_64 and permissions is 775
2) cd /oracle/client/10x_64
3) SAPCAR -xvf <path_to>/SAPCAR -xvf OCL10264.SAR
4) ln -s ln -s instantclient_10205 instantclient
5) run R3trans -x
If result is OK try to start SAP system
Regards
Roman
hi Roman and Ratnajit,
going to summarize:
here if I create link via
ln -s instantclient_10205 instantclient
then I will not get the following error:
/usr/sap/LNX/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed
why I am still getting ABAP Database is not available via R3trans
when I execute stopsap all.
There are .bash_profile & some others files exist in /root and/home/sidadm directories. now where and inwhich file I have to put the variable and which one variables i have to set permanently .
Regards,
why I am still getting ABAP Database is not available via R3trans
when I execute stopsap all.
You instantclient is not correctly installed and you can't connect to oracle instance if that running
There are .bash_profile & some others files exist in /root and/home/sidadm directories. now where and inwhich file I have to put the variable and which variable for permanent setting.
You need to change environment variables related to DB for user <sid>adm under /home/<sid>adm/.dbenv* files (csh and sh)
Regards
Roman
Dear,
please also confirm me about following steps for upgrade oracle client version
1) download and uncar the file
[root@saplinux OCL10205]# ./SAPCAR -xvf OCL10264.SAR
paste the instanctclient_version in 10x_64 folder
2. create a link
[root@saplinux OCL10205]# ln -s instantclient_10205 instantclient
3. For load the lib
saplinux:lnxadm 2> ldd dboraslib.so
4. start the startsap db for check the status of R3trans -x
5.For check the file is loaded successfully or not
saplinux:oralnx 1> ./genezi -v
above steps are ok and if still not then please tell me sequence.
now. i can not extended this thread
Regards,
1) shutdown SAP system
2) download file OCL10264.SAR
3) check owner <sid>adm and permissions 775 of /oracle/client/10x_64 directory.
4) su - <sid>adm
5) cd /oracle/client/10x_64
6) SAPCAR -xvf OCL10264.SAR
7) rm -rf instantclient (if no permissions try this under root user)
😎 ln -s instantclient_10205 instantclient
9) execute ldd dboraslib.so and check that all dependencies are resolved
10) execute ./genezi -v and check you are running in instantclient mode
11) startup SAP system
Regards
Roman
hi Roman,
bundle of thanks for your kind support,
[root@saplinux lnxadm]# echo $SHELL
/bin/bash
here bash shell is running. So, will i use .sh files
[root@saplinux lnxadm]# ls -a .dbenv*
.dbenv.csh .dbenv_saplinux.csh .dbenv_saplinux.sh .dbenv.sh
there are showing .dbevn* files, please tell me that inwhich file I will add DB parameter.
.dbenv_saplinux.sh
SAPDATA_HOME=/oracle/LNX; export SAPDATA_HOME
DIR_LIBRARY=/usr/sap/LNX/SYS/exe/run; export DIR_LIBRARY
LD_LIBRARY_PATH=/usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient; export LD_LIBRARY_PATH
here I did put LD_LIBRARY_PATH in .dbenv_saplinux.sh.
is it OK.
Regards,
hi Ratnajit,
please see the logs
Starting SAP Instance DVEBMGS00
------------------------------
Startup-Log is written to /home/lnxadm/startsap_DVEBMGS00.log
/usr/sap/LNX/SYS/exe/run/startsap: line 1733: cd: /root: Permission denied
Instance Service on host saplinux started
Instance on host saplinux started
saplinux:lnxadm 5> R3trans -x
This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).
unicode enabled version
2EETW152 Cannot open file "trans.log".
: Permission denied
R3trans finished (0012).
saplinux:lnxadm 6> R3trans -d
This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).
unicode enabled version
2EETW152 Cannot open file "trans.log".
: Permission denied
R3trans finished (0012).
trans.log
saplinux:lnxadm 8> cat /home/lnxadm/trans.log
4 ETW000 R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 03.07.2012 - 12:15:45
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Tue Jul 3 12:15:45 2012 110 0.000110
4 ETW000 [dev trc ,00000] db_con_init called 22 0.000132
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 33 0.000165
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/LNX/SYS/exe/run/dboraslib.so' ... 48 0.000213
4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/LNX/SYS/exe/run/dboraslib.so") FAILED
4 ETW000 "libclntsh.so.10.1: cannot open shared object file: No such file or directory"
4 ETW000 360 0.000573
4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/LNX/SYS/exe/run/dboraslib.so'
4 ETW000 86 0.000659
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/LNX/SYS/exe/run') or dbms_type ('ORA')"
today date is 04.07.2012 while above log is showing of 03.07.2012
while the permission on trans.log is
saplinux:lnxadm 7> ls -lrt /home/lnxadm/trans.log
-rwxrwxr-x 1 lnxadm sapsys 1552 Jul 3 12:15 /home/lnxadm/trans.log
Regards,
Please check if the DIR_LIBRARY is set in the environment of user <sid>adm
echo $DIR_LIBRARY
Can you check the permission and owner of lnxadm directory under /home
lnxadm:sapsys should be the owner:group .
Also check the shell of lnxadm (echo $SHELL)
also paste the command env logging in as lnxadm.
Regards
Ratnajit
echo $DIR_LIBRARY
saplinux:lnxadm 9> echo $DIR_LIBRARY
/usr/sap/LNX/SYS/exe/run
Can you check the permission and owner of lnxadm directory under /home
saplinux:lnxadm 11> ls -lrt /home/
total 8
drwx------ 2 lnxadm sapsys 4096 Jul 4 09:43 lnxadm
saplinux:lnxadm 10> ls -lrt /home/lnxadm/*
-rwxrwxr-x 1 lnxadm sapsys 25 May 18 2007 /home/lnxadm/rfcexec.sec
-rwxrwxr-x 1 lnxadm sapsys 1552 Jul 3 12:15 /home/lnxadm/trans.log
-rwxrwxr-x 1 lnxadm sapsys 1428 Jul 3 16:39 /home/lnxadm/dev_sapstart
-rwxrwxr-x 1 lnxadm sapsys 5338 Jul 4 09:40 /home/lnxadm/stopsap_.log
-rwxrwxr-x 1 lnxadm sapsys 1301 Jul 4 09:40 /home/lnxadm/stopdb.log
-rwxrwxr-x 1 lnxadm sapsys 485 Jul 4 09:40 /home/lnxadm/stopsap_DVEBMGS00.log
-rwxrwxr-x 1 lnxadm sapsys 29450 Jul 4 09:43 /home/lnxadm/startsap_.log
-rwxrwxr-x 1 lnxadm sapsys 2860 Jul 4 09:43 /home/lnxadm/startdb.log
-rwxrwxr-x 1 lnxadm sapsys 2874 Jul 4 09:44 /home/lnxadm/startsap_DVEBMGS00.log
lnxadm:sapsys should be the owner:group .
???
Also check the shell of lnxadm (echo $SHELL)
saplinux:lnxadm 13> echo $SHELL
/bin/csh
also paste the command env logging in as lnxadm.
saplinux:lnxadm 14> env
HOSTNAME=saplinux
TERM=xterm
SHELL=/bin/csh
HISTSIZE=1000
SSH_CLIENT=172.20.3.94 50244 22
SSH_TTY=/dev/pts/2
USER=lnxadm
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
SAPINST_JRE_HOME=/usr/java/jdk1.5.0_18
MAIL=/var/spool/mail/lnxadm
PATH=/oracle/LNX/102_64/bin:.:/home/lnxadm:/usr/sap/LNX/SYS/exe/run:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/java/jdk1.5.0_18/bin
INPUTRC=/etc/inputrc
PWD=/root
JAVA_HOME=/usr/java/jdk1.5.0_18
LANG=en_US.UTF-8
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=2
HOME=/home/lnxadm
LOGNAME=lnxadm
CVS_RSH=ssh
SSH_CONNECTION=172.20.3.94 50244 172.20.0.7 22
LESSOPEN=|/usr/bin/lesspipe.sh %s
G_BROKEN_FILENAMES=1
_=/bin/su
HOSTTYPE=x86_64-linux
VENDOR=unknown
OSTYPE=linux
MACHTYPE=x86_64
GROUP=sapsys
HOST=saplinux
REMOTEHOST=172.20.3.94
SAPSYSTEMNAME=LNX
DIR_LIBRARY=/usr/sap/LNX/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=LNX
dbs_ora_schema=SAPSR3
ORACLE_SID=LNX
DB_SID=LNX
ORACLE_BASE=/oracle
TNS_ADMIN=/usr/sap/LNX/SYS/profile/oracle
ORACLE_HOME=/oracle/LNX/102_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/LNX
Regards,
Can you check if the file dboraslib.so exists under /usr/sap/LNX/SYS/exe/run/ (actually under /sapmnt/LNX/exe)
saplinux:lnxadm 20> find / -name dboraslib.so
/sapmnt/LNX/exe/dboraslib.so
/usr/sap/LNX/DVEBMGS00/exe/dboraslib.so
while I checked manually and above file exist in three places
/sapmnt/LNX/exe/dboraslib.so
/usr/sap/LNX/DVEBMGS00/exe/dboraslib.so
/usr/sap/LNX/SYS/exe/run/dboraslib.so
Also check the permission of /usr/sap/LNX and /sapmnt/LNX directories.
[root@saplinux ~]# ls -lrt /usr/sap/LNX/
total 28
drwxrwxr-x 5 oralnx dba 4096 May 21 16:59 SYS
drwxrwxr-x 2 oralnx dba 4096 Jun 4 11:25 put
-rwxrwxr-x 1 oralnx dba 1402 Jun 19 12:23 dev_sapstart
drwxrwxr-x 10 oralnx dba 4096 Jul 2 15:15 DVEBMGS00
drwxrwxr-x 2 oralnx dba 4096 Jul 4 09:39 AUDIT
[root@saplinux ~]# ls -lrt /sapmnt/LNX/
total 20
drwxr-xr-x 5 lnxadm sapsys 4096 Jun 20 15:36 exe_OCU10202
drwxr-xr-x 5 lnxadm sapsys 4096 Jul 2 12:21 exe_254
drwxr-xr-x 3 lnxadm sapsys 4096 Jul 2 16:10 profile
drwxr-xr-x 5 lnxadm sapsys 4096 Jul 3 09:23 exe
drwxr-xr-x 7 lnxadm sapsys 4096 Jul 3 15:01 global
Regards,
hi,
[root@saplinux LNX]# pwd
/usr/sap/LNX
[root@saplinux LNX]# chown -R lnxadm:sapsys *
[root@saplinux LNX]# ll
total 28
drwxrwxr-x 2 lnxadm sapsys 4096 Jul 4 09:39 AUDIT
-rwxrwxr-x 1 lnxadm sapsys 1402 Jun 19 12:23 dev_sapstart
drwxrwxr-x 10 lnxadm sapsys 4096 Jul 2 15:15 DVEBMGS00
drwxrwxr-x 2 lnxadm sapsys 4096 Jun 4 11:25 put
drwxrwxr-x 5 lnxadm sapsys 4096 May 21 16:59 SYS
Regards,
Can you now execute R3trans -x ??
saplinux:lnxadm 2> R3trans -x
This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'LNX'"
R3trans finished (0012).
Also cd /usr/sap/LNX/SYS/exe/run
Then pwd
do you see the output /sapmnt/LNX/exe ?
saplinux:lnxadm 3> cd /usr/sap/LNX/SYS/exe/run
saplinux:lnxadm 4> pwd
/sapmnt/LNX/exe
Regards,
please add my email address nd come online on gtalk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.