cancel
Showing results for 
Search instead for 
Did you mean: 

upgrade Version of OC

former_member182034
Active Contributor
0 Kudos

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,



Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

former_member182034
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

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

Former Member
0 Kudos

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>

former_member182034
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

Dear Jamil,

Yes , the environment variables can be listed in the .bash_profile as you have mentioned in the reply using the export command.

Regards,

Faiz

former_member182034
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

Run R3trans -x and put trans.log file.

Show also output from ldd dboraslib.so for <sid>adm user

Regards

Roman

former_member182034
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

What operating system you are using?

Please show you LD_LIBRARY_PATH for <sid>adm user

Regards

Roman

former_member182034
Active Contributor
0 Kudos

hi,

saplinux:lnxadm 1>  echo $LD_LIBRARY_PATH

/usr/sap/LNX/SYS/exe/run:/oracle/client/10x_64/instantclient

here, the instantclient_10205 is exist in 10x_64 folder while instantclient is empty folder.

Red Hat Enterprise Linux Server release 5.1 (Tikanga)

Linux 2.6.18-53.el5xen x86_64

Regards,

Former Member
0 Kudos

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

former_member189725
Active Contributor
0 Kudos

Go the directory /oracle/client/10x_64/

Run the following command

ln -s instantclient_10205 instantclient

The LD_LIBRARY_PATH is fine.

Then check if R3trans -x works.

Regards

Ratnajit

Former Member
0 Kudos

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.

former_member182034
Active Contributor
0 Kudos

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,

former_member189725
Active Contributor
0 Kudos

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

former_member182034
Active Contributor
0 Kudos

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,

former_member189725
Active Contributor
0 Kudos

change the permission to 775 for the 10x_64 directory.

Then try to execute the command.

Regards

Ratnajit

former_member182034
Active Contributor
0 Kudos

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

former_member189725
Active Contributor
0 Kudos

You can also create the link with <sid>adm as the oracle client library is loaded by the SAP DBSL . Should not be an issue.

Regards

Ratnajit

Former Member
0 Kudos

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


former_member182034
Active Contributor
0 Kudos

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,


former_member189725
Active Contributor
0 Kudos

Can you please paste trans.log

Regards

Ratnajit

Former Member
0 Kudos

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

former_member182034
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

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

former_member182034
Active Contributor
0 Kudos

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.s.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,

former_member189725
Active Contributor
0 Kudos

The users <sid>adm and ora<sid> should have C shell as the default. The root user with bash shell is not the issue.

Once you login as <sid>adm , run the command env and paste the output .

also please paste the trans.log .

Regards

Ratnajit

former_member182034
Active Contributor
0 Kudos

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,


former_member189725
Active Contributor
0 Kudos

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

former_member182034
Active Contributor
0 Kudos

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,

former_member189725
Active Contributor
0 Kudos

Can you check if the file dboraslib.so exists under /usr/sap/LNX/SYS/exe/run/ (actually under /sapmnt/LNX/exe)

Also check the permission of /usr/sap/LNX and /sapmnt/LNX directories.

Regards

Ratnajit

former_member182034
Active Contributor
0 Kudos

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,

former_member189725
Active Contributor
0 Kudos

Please change the owner under /usr/sap/LNX

cd /usr/sap/LNX

chown -R lnxadm:sapsys *

Regards

Ratnajit

former_member182034
Active Contributor
0 Kudos

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,

former_member189725
Active Contributor
0 Kudos

Can you now execute R3trans -x ??

Also cd /usr/sap/LNX/SYS/exe/run

Then pwd

do you see the output /sapmnt/LNX/exe ?

Regards

Ratnajit

former_member182034
Active Contributor
0 Kudos

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

majamil1@gmail.com

Former Member
0 Kudos

Please paste trans.log file again

Regards

Roman

former_member182034
Active Contributor
0 Kudos

Dear Ratnajit and Roman,

I m going to open a new thread regarding R3trans.

because i m really exhausted frm this thread..

FYI....

now oracle client version is updated and showing 10.2.0.5 in SM51 and under System --> Status..

Regards,

Answers (0)