Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error when start SAP system after a Oracle Instant Client update

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

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question