Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 07, 2013 at 06:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Reagan Benjamin

      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

  • avatar image
    Former Member
    Dec 07, 2013 at 04:57 PM

    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.0221074 ETW000  [     dev trc,00000]  Detailed Oracle client (patch) info not available.      

    Mudasir.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Reagan Benjamin

      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