on 12-07-2013 3:31 PM
Hello,
OS - Solaris v10 (SPARC)
SAP - ERP 6.0 EHP5
DB - Oracle 11.2 (11.2.0.2)
I performed an update to the Oracle Instant Client from the version 10.2.0.2 to 11.2.0.2.
I followed the instructions in SAP note 819829 (Oracle Instant Client Installation and Configuration on Unix). I also changed the BR*Tools version from release 7.20 to the release 7.20_EXT (but I´m still running the Kernel 7.20 UC (level 401) and DBSL level 327) and I did this because in sap note 819829 is described in "Configuring Oracle Instant Client 11.2 for SAP BR*Tools 7.20" that is necessary to change it to that EXT kernel version because this version is based on 11.2 instant client!
After that I tried to start the SAP system, I started the oracle database (with ora<sid>) and then with <sid>adm I ran the command startsap r3 but unfortunatelly the system doesn´t started!
I believe there is a problema with something related with OCI... Can you help me please to correct this issue!?
I ran the command R3trans -x and it show me the following lines:
...
4 ETW000 [ | dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1 | ||||||
4 ETW000 | 1363 0.021144 | ||||||
4 ETW000 [ | dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) | 48 0.021192 | |||||
4 ETW000 [ | dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) | 44 0.021236 | |||||
4 ETW000 [ | dev trc,00000] New connection 0 created | 39 0.021275 | |||||
4 ETW000 [ | dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = | ||||||
4 ETW000 | 75 0.021350 | ||||||
4 ETW000 [ | dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) | 46 0.021396 | |||||
4 ETW000 [ | dev trc,00000] db_con_connect (con_name=R/3) | 37 0.021433 | |||||
4 ETW000 [ | dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3 | ||||||
4 ETW000 | 59 0.021492 | ||||||
4 ETW000 [ | dev trc,00000] find_con_by_name found the following connection: | 36 0.021528 | |||||
4 ETW000 [ | dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = | ||||||
4 ETW000 | 71 0.021599 | ||||||
4 ETW000 [ | dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720') | ||||||
4 ETW000 | 127 0.021726 | ||||||
4 ETW000 [ | dev trc,00000] Register application info. | 286 0.022012 | |||||
4 ETW000 [ | dev trc,00000] Oracle client version: 10.2.0.2.0, (dbsl 720 291112, UNICODE[2]) | 95 0.022107 | |||||
4 ETW000 [ | dev trc,00000] Detailed Oracle client (patch) info not available. | 43 0.022150 | |||||
4 ETW000 [ | dev trc,00000] Oracle instant client is out-of-date or not delivered by SAP. | 40 0.022190 | |||||
4 ETW000 [ | dev trc,00000] See SAP note 819829 for more info. | 38 0.022228 | |||||
4 ETW000 [ | dev trc,00000] | Default connection: tnsname ='AZQ' | 40 0.022268 | ||||
4 ETW000 [ | dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2 | ||||||
4 ETW000 | 72 0.022340 | ||||||
4 ETW000 [ | dev trc,00000] | OCIEnvCreate(mode=16384=OCI_UTF16) failed with -1=OCI_ERROR | 35420 0.057760 | ||||
4 ETW000 [ | dev trc,00000] OCIErrorGet() failed with rc=-2 | 121 0.057881 | |||||
4 ETW000 [ | dev trc,00000] | -> no further error details available | 46 0.057927 | ||||
4 ETW000 [ | dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned -1 (for default NLS handle) | ||||||
4 ETW000 | 70 0.057997 | ||||||
4 ETW000 [ | dev trc,00000] Nls CharacterSet | NationalCharSet | EnvHp | ErrHp | ErrBt | ||
4 ETW000 | 103 0.058100 | ||||||
4 ETW000 [ | dev trc,00000] | 0 UTF16 | AL16UTF16 | 0000NULL | 0000NULL | 0000NULL | |
4 ETW000 | 99 0.058199 | ||||||
4 ETW000 [ | dev trc,00000] | set_ocica() -> OCI return code -1 | 64 0.058263 | ||||
4 ETW000 [ | dev trc,00000] | DbSlConnect(con=0) -> orc=-1, 99=DBSL_ERR_DB | 51 0.058314 | ||||
4 ETW000 [ | dblink ,00000] ***LOG BY2=>sql error -1 | performing CON | 90 0.058404 | ||||
4 ETW000 [ | dblink ,00000] ***LOG BY0=>OCI returned error code -1. | 49 0.058453 | |||||
4 ETW000 [ | dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) | 52 0.058505 | |||||
4 ETW000 [ | dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) | 45 0.058550 | |||||
4 ETW000 [ | dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) | 44 0.058594 | |||||
4 ETW000 [ | dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) | 142 0.058736 | |||||
4 ETW000 [ | dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) | 46 0.058782 | |||||
4 ETW000 [ | dev trc,00000] | -> 'OCI_102, 10.2.0.2.0' | 45 0.058827 | ||||
2EETW169 no connect possible: "DBMS = ORACLE | --- dbs_ora_tnsname = 'AZQ'" |
Can you help me please?
Thank you,
samid raif
Hello Samid
What is the version of Solaris you have ?
If you have Solaris 11 then you need to use EXT version of the kernel.
1669684 - SAP on Oracle Solaris 11
1643799 - Support for Oracle Solaris 11
The SAP note 819829 says that for Solaris 11, you must use Oracle Instant Client 11.2.0.3 or higher. See SAP note 1642058.
Maybe this is the reason why the kernel is looking for the 10G instant client files.
The last thing I would try is to adapt these files to 11G instant client location
liszgpsap002:oraazq 2% grep client .*
.dbenv.csh: set ADD=/oracle/client/10x_64/instantclient
.dbenv.sh: ADD=/oracle/client/10x_64/instantclient
.dbenv_liszgpsap002.csh: set ADD=/oracle/client/10x_64/instantclient
.dbenv_liszgpsap002.sh: ADD=/oracle/client/10x_64/instantclient
I know it is stupid and not used by the system but worth trying.
Once done log off from the session and then switch to the sidadm user and run R3trans -d and provide the output.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Reagan,
What is the version of Solaris you have ?
It´s a Solaris version 10
liszgpsap002:azqadm 4% uname -a
SunOS liszgpsap002 5.10 Generic_147440-16 sun4v sparc sun4v
The last thing I would try is to adapt these files to 11G instant client location
I did that, but when I tried to start again the SAP with user <sid>adm with startsap r3 once again it show me an error:
liszgpsap002:azqadm 1% startsap r3
Checking AZQ Database
Database is not available via R3trans
-------------------------------------------
Database AZQ must be started first
The oracle database is started!
I ran again the R3trans -d:
4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 07.12.2013 - 19:02:33
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] Sat Dec 7 19:02:33 2013 165 0.000165
4 ETW000 [ dev trc,00000] db_con_init called 41 0.000206
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 55 0.000261
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 64 0.000325
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 38 0.000363
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/AZQ/SYS/exe/run/dboraslib.so' ... 84 0.000447
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/AZQ/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 17309 0.017756
4 ETW000 [ dev trc,00000] Library '/usr/sap/AZQ/SYS/exe/run/dboraslib.so' loaded 62 0.017818
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/AZQ/SYS/exe/run/dboraslib.so
4 ETW000 78 0.017896
4 ETW000 [ dev trc,00000] Version of '/usr/sap/AZQ/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.327)
4 ETW000 637 0.018533
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/AZQ/SYS/exe/run/dboraslib.so
4 ETW000 73 0.018606
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/AZQ/SYS/exe/run/dboraslib.so
4 ETW000 122 0.018728
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 1225 0.019953
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 47 0.020000
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 44 0.020044
4 ETW000 [ dev trc,00000] New connection 0 created 39 0.020083
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 74 0.020157
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 45 0.020202
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 37 0.020239
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 59 0.020298
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 36 0.020334
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 69 0.020403
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720')
4 ETW000 120 0.020523
4 ETW000 [ dev trc,00000] Register application info. 262 0.020785
4 ETW000 [ dev trc,00000] Oracle client version: 10.2.0.2.0, (dbsl 720 291112, UNICODE[2]) 88 0.020873
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available. 43 0.020916
4 ETW000 [ dev trc,00000] Oracle instant client is out-of-date or not delivered by SAP. 39 0.020955
4 ETW000 [ dev trc,00000] See SAP note 819829 for more info. 38 0.020993
4 ETW000 [ dev trc,00000] Default connection: tnsname ='AZQ' 40 0.021033
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 69 0.021102
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) failed with -1=OCI_ERROR 32971 0.054073
4 ETW000 [ dev trc,00000] OCIErrorGet() failed with rc=-2 108 0.054181
4 ETW000 [ dev trc,00000] -> no further error details available 45 0.054226
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned -1 (for default NLS handle)
4 ETW000 67 0.054293
4 ETW000 [ dev trc,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrBt
4 ETW000 100 0.054393
4 ETW000 [ dev trc,00000] 0 UTF16 AL16UTF16 0000NULL 0000NULL 0000NULL
4 ETW000 98 0.054491
4 ETW000 [ dev trc,00000] set_ocica() -> OCI return code -1 60 0.054551
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=-1, 99=DBSL_ERR_DB 50 0.054601
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -1 performing CON 85 0.054686
4 ETW000 [ dblink ,00000] ***LOG BY0=>OCI returned error code -1. 48 0.054734
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 49 0.054783
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 45 0.054828
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 43 0.054871
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 123 0.054994
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 46 0.055040
4 ETW000 [ dev trc,00000] -> 'OCI_102, 10.2.0.2.0' 44 0.055084
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'AZQ'"
Any tips?
Kind regards,
samid raif
I don't know how or why the kernel is still pointing to the 10G client.
As the environment variables are pointing to the 11G location then most probably a new version of kernel could be the solution.
su - azqadm
ldd /usr/sap/AZQ/SYS/exe/run/dboraslib.so
Check which files it is looking for.
Regards
RB
Hi Reagan,
Yes, I have the following files under /oracle/client/10x_64:
liszgpsap002:azqadm 18% cd 10x_64
liszgpsap002:azqadm 19% ls -ltra
total 12
drwxrwxr-x 2 azqadm sapsys 9 Mar 27 2006 instantclient_10202
-rwxrwxr-x 1 azqadm sapsys 100 Mar 27 2006 dbclient.lst
lrwxrwxrwx 1 azqadm sapsys 41 Jun 19 2012 instantclient -> /oracle/client/10x_64/instantclient_10202
drwxrwxr-x 3 azqadm sapsys 5 Jun 19 2012 .
drwxr-xr-x 4 root root 4 Dec 6 18:54 ..
I did what you said, I rename the 10x_64 and I created a symbolic link:
liszgpsap002# mv 10x_64 10x_64_old
liszgpsap002# ls -ltr
total 6
drwxrwxr-x 3 azqadm sapsys 5 Jun 19 2012 10x_64_old
drwxrwxrwx 3 azqadm sapsys 5 Dec 6 19:18 11x_64
liszgpsap002# ln -s /oracle/client/11x_64 /oracle/client/10x_64
liszgpsap002# ls -ltr
total 7
drwxrwxr-x 3 azqadm sapsys 5 Jun 19 2012 10x_64_old
drwxrwxrwx 3 azqadm sapsys 5 Dec 6 19:18 11x_64
lrwxrwxrwx 1 root root 21 Dec 7 20:14 10x_64 -> /oracle/client/11x_64
But the SAP system doesn´t start... now is other error:
liszgpsap002:azqadm 2% R3trans -x
This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/AZQ/SYS/exe/run') or dbms_type ('ORA')"
R3trans finished (0012).
echo $DIR_LIBRARY
/usr/sap/AZQ/SYS/exe/run
The output of R3trans -x command:
4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 07.12.2013 - 20:20:45
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Sat Dec 7 20:20:45 2013 180 0.000180
4 ETW000 [ dev trc,00000] db_con_init called 41 0.000221
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 58 0.000279
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 64 0.000343
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 36 0.000379
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/AZQ/SYS/exe/run/dboraslib.so' ... 84 0.000463
4 ETW000 [ dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/AZQ/SYS/exe/run/dboraslib.so") FAILED
4 ETW000 "ld.so.1: R3trans: fatal: /oracle/client/11x_64/instantclient/libclntsh.so.10.1: unknown file type"
4 ETW000 1108 0.001571
4 ETW000 [ dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/AZQ/SYS/exe/run/dboraslib.so'
4 ETW000 113 0.001684
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/AZQ/SYS/exe/run') or dbms_type ('ORA')"
Any tips?
Kind regards,
samid raif
Hello Samid
Did you use the right Oracle Instant Client for the OS ?
ls -la /oracle/client/11x_64/instantclient_11202
ls -la /oracle/client/11x_64/instantclient/libclntsh.so.10.1
Also provide the output of this command:
su - sidadm
sapcontrol -nr NN -function GetVersionInfo
Replace NN with the right system number.
Regards
RB
Hello Reagan,
The DVD media of Oracle Instant Client that I downloaded was the 51042930 and I´m using the files in .SAR file into the directory OCL_SOLARIS_SPARC:
\51042930\OCL_SOLARIS_SPARC
I believe this is the correct file of Oracle Instant Client 11.2.0.2!
liszgpsap002:azqadm 5% ls -la /oracle/client/11x_64/instantclient_11202
total 294275
drwxrwxrwx 2 azqadm sapsys 16 Dec 6 19:07 .
drwxrwxrwx 3 azqadm sapsys 5 Dec 6 19:18 ..
-rwxrwxrwx 1 azqadm sapsys 3481 Mar 14 2012 SAPIC_README
-rwxrwxrwx 1 azqadm sapsys 23456 Mar 14 2012 adrci
-rwxrwxrwx 1 azqadm sapsys 1629710 Mar 14 2012 classes12.jar
-rwxrwxrwx 1 azqadm sapsys 34656 Mar 14 2012 genezi
-rwxrwxrwx 1 azqadm sapsys 0 Mar 14 2012 libclntsh.so
-rwxrwxrwx 1 azqadm sapsys 0 Mar 14 2012 libclntsh.so.10.1
-rwxrwxrwx 1 azqadm sapsys 48252544 Mar 14 2012 libclntsh.so.11.1
-rwxrwxrwx 1 azqadm sapsys 0 Mar 14 2012 libnnz10.so
-rwxrwxrwx 1 azqadm sapsys 7780640 Mar 14 2012 libnnz11.so
-rwxrwxrwx 1 azqadm sapsys 85980664 Mar 14 2012 libociei.so
-rwxrwxrwx 1 azqadm sapsys 1578277 Mar 14 2012 ojdbc14.jar
-rwxrwxrwx 1 azqadm sapsys 2047217 Mar 14 2012 ojdbc5.jar
-rwxrwxrwx 1 azqadm sapsys 2169317 Mar 14 2012 ojdbc6.jar
-rwxrwxrwx 1 azqadm sapsys 456760 Mar 14 2012 wrc
liszgpsap002:azqadm 6% ls -la /oracle/client/11x_64/instantclient/libclntsh.so.10.1
-rwxrwxrwx 1 azqadm sapsys 0 Mar 14 2012 /oracle/client/11x_64/instantclient/libclntsh.so.10.1
liszgpsap002:azqadm 7% sapcontrol -nr 00 -function GetVersionInfo
08.12.2013 02:35:40
GetVersionInfo
OK
Filename, VersionInfo, Time
/usr/sap/AZQ/DVEBMGS00/exe/sapstartsrv, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 02:54:14
/usr/sap/AZQ/DVEBMGS00/exe/disp+work, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 16 01:28:21
/usr/sap/AZQ/DVEBMGS00/exe/gwrd, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 16 01:33:43
/usr/sap/AZQ/DVEBMGS00/exe/msg_server, 720, patch 414, changelist 1391469, optu (Feb 2 2013, 07:46:34), sun_64, 2013 02 03 19:23:03
/usr/sap/AZQ/DVEBMGS00/exe/dboraslib.so, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 15 15:29:53
/usr/sap/AZQ/DVEBMGS00/exe/dbdb6slib.so, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 15 15:28:14
/usr/sap/AZQ/DVEBMGS00/exe/dbsybslib.so, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 15 18:54:00
/usr/sap/AZQ/DVEBMGS00/exe/enserver, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 02:43:48
/usr/sap/AZQ/DVEBMGS00/exe/icman, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 02:35:36
/usr/sap/AZQ/DVEBMGS00/exe/sapwebdisp, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 02:36:26
/usr/sap/AZQ/DVEBMGS00/exe/jcontrol, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 03:40:35
/usr/sap/AZQ/DVEBMGS00/exe/jlaunch, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 03:40:44
/usr/sap/AZQ/DVEBMGS00/exe/jstart, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 03:36:41
regards,
samid raif
Hi Reagan,
Yes... it´s weird!
As I said in my first message, besides the Oracle Instant Client update from 10.2.0.2 to 11.2.0.2 I also changed the BR*Tools version from release 7.20 to the release 7.20_EXT (but I´m still running the Kernel 7.20 UC (level 401) and DBSL level 327) and I did this because in sap note 819829 is described in "Configuring Oracle Instant Client 11.2 for SAP BR*Tools 7.20" that is necessary to change it to that EXT kernel version because this version is based on 11.2 instant client!
The path where I replace the new BR*Tools files release 7.20_EXT (DBATL720O10_35-20006731.SAR) was the /sapmnt/AZQ/exe, I believe this is the right path of Kernel directory!
Tell me one thing, it´s not supposed that the /sapmnt/AZQ/exe it is the same directory of /usr/sap/AZQ/DVEBMGS00/exe ?
Because I believe that /usr/sap/AZQ/DVEBMGS00/exe has differents files than into /sapmnt/AZQ/exe!!
ldd /usr/sap/AZQ/SYS/exe/run/dboraslib.so
Check which files it is looking for.
liszgpsap002:azqadm 10% ldd /usr/sap/AZQ/SYS/exe/run/dboraslib.so
libdl.so.1 => /lib/64/libdl.so.1
libnsl.so.1 => /lib/64/libnsl.so.1
libsocket.so.1 => /lib/64/libsocket.so.1
libCstd.so.1 => /usr/lib/64/libCstd.so.1
libCrun.so.1 => /usr/lib/64/libCrun.so.1
libm.so.1 => /lib/64/libm.so.1
libclntsh.so.10.1 => /oracle/client/11x_64/instantclient/libclntsh.so.10.1 - unknown file type
libnnz10.so => /oracle/client/11x_64/instantclient/libnnz10.so - unknown file type
libc.so.1 => /lib/64/libc.so.1
libmp.so.2 => /lib/64/libmp.so.2
libmd.so.1 => /lib/64/libmd.so.1
libscf.so.1 => /lib/64/libscf.so.1
libdoor.so.1 => /lib/64/libdoor.so.1
libuutil.so.1 => /lib/64/libuutil.so.1
libgen.so.1 => /lib/64/libgen.so.1
libm.so.2 => /lib/64/libm.so.2
/lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2
/platform/sun4v/lib/sparcv9/libc_psr.so.1
/platform/sun4v/lib/sparcv9/libmd_psr.so.1
Kind regards,
samid raif
Yo have errors in Oracle client installation. You can correct them manually. But the simpler solution is:
1) remove content of /oracle/client/11x_64/instantclient_11202 directory
2) reinstall oracle instant client 11
3) rename /oracle/client/10x_64 directory to any you want (save it for some time)
4) create symbolic link 10x_64 -> 11x_64
Check the connection with R3trans -d.
Hello Samid
I think I know where the problem is.
liszgpsap002:azqadm 5% ls -la /oracle/client/11x_64/instantclient_11202
total 294275
drwxrwxrwx 2 azqadm sapsys 16 Dec 6 19:07 .
drwxrwxrwx 3 azqadm sapsys 5 Dec 6 19:18 ..
-rwxrwxrwx 1 azqadm sapsys 3481 Mar 14 2012 SAPIC_README
-rwxrwxrwx 1 azqadm sapsys 23456 Mar 14 2012 adrci
-rwxrwxrwx 1 azqadm sapsys 1629710 Mar 14 2012 classes12.jar
-rwxrwxrwx 1 azqadm sapsys 34656 Mar 14 2012 genezi
-rwxrwxrwx 1 azqadm sapsys 0 Mar 14 2012 libclntsh.so
-rwxrwxrwx 1 azqadm sapsys 0 Mar 14 2012 libclntsh.so.10.1
-rwxrwxrwx 1 azqadm sapsys 48252544 Mar 14 2012 libclntsh.so.11.1
-rwxrwxrwx 1 azqadm sapsys 0 Mar 14 2012 libnnz10.so
-rwxrwxrwx 1 azqadm sapsys 7780640 Mar 14 2012 libnnz11.so
-rwxrwxrwx 1 azqadm sapsys 85980664 Mar 14 2012 libociei.so
-rwxrwxrwx 1 azqadm sapsys 1578277 Mar 14 2012 ojdbc14.jar
-rwxrwxrwx 1 azqadm sapsys 2047217 Mar 14 2012 ojdbc5.jar
-rwxrwxrwx 1 azqadm sapsys 2169317 Mar 14 2012 ojdbc6.jar
-rwxrwxrwx 1 azqadm sapsys 456760 Mar 14 2012 wrc
The files libclntsh.so libclntsh.so.10.1 and libnnz10.so are not good.
If you see the file sizes they are just 0 bytes.
It looks like the file OCL11264.SAR was not extracted properly.
Did you extract these on Solaris or on Windows and then uploaded them to the server ?
Try creating these symbolic links and see whether it helps.
cd /oracle/client/11x_64/instantclient_11202
rm libclntsh.so.10.1 libnnz10.so
ln -s libclntsh.so.11.1 libclntsh.so.10.1
ln -s libnnz11.so libnnz10.so
Regards
RB
The path where I replace the new BR*Tools files release 7.20_EXT (DBATL720O10_35-20006731.SAR) was the /sapmnt/AZQ/exe, I believe this is the right path of Kernel directory!
Correct.
Tell me one thing, it´s not supposed that the /sapmnt/AZQ/exe it is the same directory of /usr/sap/AZQ/DVEBMGS00/exe ?
When you do a kernel update you need to put the all the kernel files under /sapmnt/AZQ/exe which is the DIR_CT_RUN location. In short it is the central location for the kernel files.
When you start the SAP system the sapcpe program will be called by the script to copy the files files from the DIR_CT_RUN ( /sapmnt/AZQ/exe) location to DIR_EXECUTABLE (/usr/sap/AZQ/DVEBMGS00/exe) location.
Because I believe that /usr/sap/AZQ/DVEBMGS00/exe has differents files than into /sapmnt/AZQ/exe!!
The files under /sapmnt/AZQ/exe and /usr/sap/AZQ/DVEBMGS00/exe should always be same.
You can manually copy the files from /sapmnt/AZQ/exe and /usr/sap/AZQ/DVEBMGS00/exe or call the sapcpe program manually.
Regards
RB
Hello Reagan,
The files under /sapmnt/AZQ/exe and /usr/sap/AZQ/DVEBMGS00/exe should always be same.
I believe that /usr/sap/AZQ/DVEBMGS00/exe has differents files than into /sapmnt/AZQ/exe
Look at the following two pictures, the first from /usr/sap/AZQ/DVEBMGS00/exe and the second one from /sapmnt/AZQ/exe
regards,
samid raif
Hello Samid
That is not a problem. The sapcpe program files from the /sapmnt/AZQ/exe location to the /usr/sap/AZQ/DVEBMGS00/exe location based on certain .lst files.
Now back to the Oracle client issue. I believe you used some FTP tool like Winscp to transfer the extracted files to the server.
That could be the reason why the files are corrupted or invalid.
I suggest you to upload the .SAR file and extract the file on the server and copy them using the command line.
Try this and let me know.
cd /oracle/client/11x_64
cp /sapmnt/AZQ/exe/SAPCAR .
./SAPCAR -xvf OCL11264.SAR
ln -s instantclient_11202 instantclient
chown -R azqadm:sapsys /oracle/client/11x_64
chmod -R a+rwx /oracle/client/11x_64
ls -la /oracle/client/11x_64/instantclient_11202
Regards
RB
Hello Reagan,
Now everything is Ok
I believe, that was in fact the main problem here! I uploaded the .SAR file and I extracted the file on the server and I did all the procedure in sap note 819829 again!
Now the system is running without problems!
Many many thanks Reagan you helped me a lot!!
Thank you
samid raif
Hello Samid,
The Oracle client version still shows as old one (10.2.0.2.0 ). Have you replaced the old oracle client as expected or just upgraded it?
Have you checked the Oracle client version after upgrade with command 'genezi -v ' ?
Refer to the link and verify the steps you have followed
Link : http://scn.sap.com/docs/DOC-49953
Your error log :
4 ETW000 [ dev trc,00000] Oracle client version: 10.2.0.2.0, (dbsl 720 291112, UNICODE[2]) | 95 0.022107 | |
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available. |
Mudasir.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Mudasir,
Yes... I don´t know why it still shows as old one (10.2.0.2)!!!
When I ran the command genezi -v it show me the following output:
liszgpsap002:azqadm 4% genezi -v
Client Shared Library 64-bit - 11.2.0.2.0
System name: SunOS
Release: 5.10
Version: Generic_147440-16
Machine: sun4v
Operating in Instant Client mode.
Small timezone file = timezone_14.dat
Large timezone file = timezlrg_14.dat
I also checked the environment variables:
USER=azqadm
LOGNAME=azqadm
HOME=/export/home/azqadm
PATH=/oracle/AZQ/112_64/bin:/usr/j2se/bin:/usr/bin:/bin:/usr/sap/AZQ/SYS/exe/uc/sun_64:/usr/sap/AZQ/SYS/exe/run:/export/home/azqadm:.:/usr/ccs/bin:/usr/ucb
MAIL=/var/mail//azqadm
SHELL=/bin/csh
TZ=Europe/Lisbon
SSH_CLIENT=10.8.0.30 54197 22
SSH_CONNECTION=10.8.0.30 54197 10.8.0.13 22
SSH_TTY=/dev/pts/1
TERM=xterm
DISPLAY=localhost:10.0
PWD=/export/home/azqadm
SAPSYSTEMNAME=AZQ
DIR_LIBRARY=/usr/sap/AZQ/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/AZQ/SYS/exe/run:/usr/sap/AZQ/SYS/exe/uc/sun_64:/oracle/client/11x_64/instantclient
JAVA_HOME=/usr/j2se
SAPEXE=/usr/sap/AZQ/SYS/exe/run
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=AZQ
dbs_ora_schema=SAPSR3
ORACLE_SID=AZQ
DB_SID=AZQ
ORACLE_BASE=/oracle
TNS_ADMIN=/usr/sap/AZQ/SYS/profile/oracle
ORACLE_HOME=/oracle/AZQ/112_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/AZQ
The env LD_LIBRARY_PATH show me the correct path of 11x_64:
liszgpsap002:azqadm 6% echo $LD_LIBRARY_PATH
/usr/sap/AZQ/SYS/exe/run:/usr/sap/AZQ/SYS/exe/uc/sun_64:/oracle/client/11x_64/instantclient
During the activity of oracle client instant update, I changed the following user files (<sid>adm) to replace the oracle client path from 10x to 11x:
.dbenv.csh
.dbenv.sh
.dbenv_liszgpsap002.csh
.dbenv_liszgpsap002.sh
Any tips?
Please help me!!
Kind regards,
samid raif
Hello Reagan,
The outputs:
liszgpsap002:azqadm 5% ls -la /oracle/client
total 12
drwxr-xr-x 4 root root 4 Dec 6 18:54 .
drwxr-xr-x 8 oraazq dba 11 Nov 14 10:54 ..
drwxrwxr-x 3 azqadm sapsys 5 Jun 19 2012 10x_64
drwxrwxrwx 3 azqadm sapsys 5 Dec 6 19:18 11x_64
liszgpsap002:azqadm 6% ls -la /oracle/client/11x_64
total 12
drwxrwxrwx 3 azqadm sapsys 5 Dec 6 19:18 .
drwxr-xr-x 4 root root 4 Dec 6 18:54 ..
-rwxrwxrwx 1 azqadm sapsys 163 Mar 14 2012 dbclient.lst
lrwxrwxrwx 1 azqadm sapsys 19 Dec 6 19:18 instantclient -> instantclient_11202
drwxrwxrwx 2 azqadm sapsys 16 Dec 6 19:07 instantclient_11202
liszgpsap002:azqadm 10% ./genezi -v
Client Shared Library 64-bit - 11.2.0.2.0
System name: SunOS
Release: 5.10
Version: Generic_147440-16
Machine: sun4v
Operating in Instant Client mode.
Small timezone file = timezone_14.dat
Large timezone file = timezlrg_14.dat
Any tips?
Regards,
samid raif
Hi Reagan,
Yes, they both running on the same server (SAP + Oracle)!
- Env of azqadm:
liszgpsap002:azqadm 11% env
USER=azqadm
LOGNAME=azqadm
HOME=/export/home/azqadm
PATH=/oracle/AZQ/112_64/bin:/usr/j2se/bin:/usr/bin:/bin:/usr/sap/AZQ/SYS/exe/uc/sun_64:/usr/sap/AZQ/SYS/exe/run:/export/home/azqadm:.:/usr/ccs/bin:/usr/ucb
MAIL=/var/mail//azqadm
SHELL=/bin/csh
TZ=Europe/Lisbon
SSH_CLIENT=10.8.0.30 57254 22
SSH_CONNECTION=10.8.0.30 57254 10.8.0.13 22
SSH_TTY=/dev/pts/1
TERM=xterm
DISPLAY=localhost:10.0
PWD=/oracle/client/11x_64/instantclient
SAPSYSTEMNAME=AZQ
DIR_LIBRARY=/usr/sap/AZQ/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/AZQ/SYS/exe/run:/usr/sap/AZQ/SYS/exe/uc/sun_64:/oracle/client/11x_64/instantclient
JAVA_HOME=/usr/j2se
SAPEXE=/usr/sap/AZQ/SYS/exe/run
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=AZQ
dbs_ora_schema=SAPSR3
ORACLE_SID=AZQ
DB_SID=AZQ
ORACLE_BASE=/oracle
TNS_ADMIN=/usr/sap/AZQ/SYS/profile/oracle
ORACLE_HOME=/oracle/AZQ/112_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/AZQ
liszgpsap002:azqadm 1% grep client .*
.dbenv.csh: set ADD=/oracle/client/11x_64/instantclient
.dbenv.sh: ADD=/oracle/client/11x_64/instantclient
.dbenv_liszgpsap002.csh: set ADD=/oracle/client/11x_64/instantclient
.dbenv_liszgpsap002.sh: ADD=/oracle/client/11x_64/instantclient
- Env of oraazq:
liszgpsap002:oraazq 1% env
HOME=/oracle/AZQ
PATH=/oracle/AZQ/112_64/bin:/usr/bin:.:/usr/sap/AZQ/SYS/exe/uc/sun_64:/usr/sap/AZQ/SYS/exe/run:/oracle/AZQ:/usr/ccs/bin:/usr/ucb
LOGNAME=oraazq
HZ=
TERM=xterm
SHELL=/bin/csh
MAIL=/var/mail/oraazq
TZ=Europe/Lisbon
PWD=/oracle/AZQ
USER=oraazq
SAPSYSTEMNAME=AZQ
DIR_LIBRARY=/usr/sap/AZQ/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/AZQ/SYS/exe/run:/usr/sap/AZQ/SYS/exe/uc/sun_64:/oracle/AZQ/112_64/lib
SAPEXE=/usr/sap/AZQ/SYS/exe/run
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=AZQ
dbs_ora_schema=SAPSR3
ORACLE_SID=AZQ
DB_SID=AZQ
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/AZQ/112_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/AZQ
liszgpsap002:oraazq 2% grep client .*
.dbenv.csh: set ADD=/oracle/client/10x_64/instantclient
.dbenv.sh: ADD=/oracle/client/10x_64/instantclient
.dbenv_liszgpsap002.csh: set ADD=/oracle/client/10x_64/instantclient
.dbenv_liszgpsap002.sh: ADD=/oracle/client/10x_64/instantclient
Kind regards,
samid raif
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.