SAP is not getting started after oracle patching

[Former Member]

Dear All,

I have successfully upgraded oracle from 11.2.0.2.to 11.2.0.3. Database is up & running fine. But while I am trying to start SAP, it is saying DB is not available. I am pasting trans.log entries below: Please guide me to get an idea to resolve the issue.

4 ETW000                                                                                                 788  0.078447

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                       32  0.078479

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             18  0.078497

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  25  0.078522

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          16  0.078538

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                                                                                                  29  0.078567

4 ETW000  [     dev trc,00000]  -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720')

4 ETW000                                                                                                 146  0.078713

4 ETW000  [     dev trc,00000]  Register application info.                                              6050  0.084763

4 ETW000  [     dev trc,00000]  Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 720 030114, non-unicode)

4 ETW000                                                                                               48186  0.132949

4 ETW000  [     dev trc,00000]  Installed Oracle client patches:                                          56  0.133005

4 ETW000  [     dev trc,00000]  # Patch  13508485     : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT

4 ETW000                                                                                                  26  0.133031

4 ETW000  [     dev trc,00000]  # Patch Description: Created on  2 Jan 2012, 04:56:08 hrs PST8PDT         22  0.133053

4 ETW000  [     dev trc,00000]  # Patch  11742262     : Created on  7 Mar 2012, 12:22:41 hrs CET          23  0.133076

4 ETW000  [     dev trc,00000]    Default connection: tnsname ='RP2'                                      32  0.133108

4 ETW000  [     dev trc,00000]  -->oci_initialize(con=0, char='WE8DEC', nchar='AL16UTF16', nls=-1),uc_ln=1

4 ETW000                                                                                                 780  0.133888

4 ETW000  [     dev trc,00000]  Sun Aug 24 03:41:27 2014                                             3149043  3.282931

4 ETW000  [     dev trc,00000]  OCIEnvCreate(mode=0=OCI_DEFAULT) returned 0 (for default NLS handle)

4 ETW000                                                                                                  54  3.282985

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=013e3e48)              39874  3.322859

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=013e4ee8)                 43  3.322902

4 ETW000  [     dev trc,00000]  NLS env. settings: lang=414D45524943414E                               60150  3.383052

4 ETW000  [     dev trc,00000]                     terr=414D4552494341                                    29  3.383081

4 ETW000  [     dev trc,00000]                     char=574538444543                                      20  3.383101

4 ETW000  [     dev trc,00000]  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.WE8DEC'

4 ETW000                                                                                                  26  3.383127

4 ETW000  [     dev trc,00000]  charset='WE8DEC', ncharset='AL16UTF16', UNI_ASC=FALSE                     18  3.383145

4 ETW000  [     dev trc,00000]  Logon as OPS$-user to get SAPRP2's password                             1217  3.384362

4 ETW000  [     dev trc,00000]  Connecting as /@RP2 on connection 0 (nls 0) ... (dbsl 720 030114, non-unicode)

4 ETW000                                                                                                  61  3.384423

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=013e4e08)              1238  3.385661

4 ETW000  [     dev trc,00000]  Allocating server context handle                                         756  3.386417

4 ETW000  [     dev trc,00000]  Attaching to database server RP2 (con=0, svchp=013e4e08, srvhp=013e5dd0)

4 ETW000                                                                                                 102  3.386519

4 ETW000  [     dev trc,00000]  Sun Aug 24 03:41:29 2014                                             1835468  5.221987

4 ETW000  [     dev trc,00000]  Assigning server context 013e5dd0 to service context 013e4e08             52  5.222039

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=014d2170)            49916  5.271955

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='/', svc=013e4e08, srv=013e5dd0, usr=014d2170)

4 ETW000                                                                                                  41  5.271996

4 ETW000  [     dev trc,00000]  Sun Aug 24 03:41:30 2014                                              597654  5.869650

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR                  46  5.869696

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:            14508  5.884204

4 ETW000  [     dev trc,00000]     ORA-01034: ORACLE not available                                        28  5.884232

4 ETW000                        ORA-27101: shared memory realm does not exist

4 ETW000                        HPUX-ia64 Error: 2: No such file or directory

4 ETW000  [     dev trc,00000]  server_detach(con=0,stale=1,srvhp=013e5dd0)                               51  5.884283

4 ETW000  [     dev trc,00000]  Server handle (con=0,svchp=013e4e08,srvhp=013e5dd0) detached           45769  5.930052

4 ETW000  [     dev trc,00000]  Free server handle srvhp=013e5dd0 of con=0                                32  5.930084

4 ETW000  [dbsloci.c   ,00000]  *** ERROR => CONNECT failed with SQL error '1034'                       9866  5.939950

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=1034)                                        31  5.939981

4 ETW000  [     dev trc,00000]     OCIErrorGet() -> SQL error code: 1034                                  25  5.940006

4 ETW000  [     dev trc,00000]  ORA-01034: ORACLE not availabl                                            18  5.940024

4 ETW000  [     dev trc,00000]  ORA-27101: shared memory realm does not exist                             19  5.940043

4 ETW000                        HPUX-ia64 Error: 2: No such file or directory

4 ETW000  [     dev trc,00000]  ocica() -> SQL error code 1034,1034                                       27  5.940070

4 ETW000  [     dev trc,00000]  SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=1034.               1043  5.941113

4 ETW000  [     dev trc,00000]     DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB                            23  5.941136

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 1034   performing CON                             7070  5.948206

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>ORA-01034: ORACLE not available                               49  5.948255

4 ETW000                        ORA-27101: shared memory realm does not exist

4 ETW000                        HPUX-ia64 Error: 2: No such file or directory

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                       839  5.949094

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                        31  5.949125

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)                    769  5.949894

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)                   103  5.949997

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)                  47  5.950044

4 ETW000  [     dev trc,00000]                 -> 'OCI_102, 11.2.0.3.0, V1, default build'                20  5.950064

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'RP2'"

Thanks

Sudipta Basak

[Former Member]

Dear All,

Issue got resolved by changing environment variable SHLIB_PATH in Database host. Previously it contain instantclient in it. Late we change the same to /usr/sap/<SID>/exe/run:/oracle/<SID>/11203/lib and the issue got resolved.

[Reagan]

Provide the environment variables of the orasid and sidadm users.

[divyanshu_srivastava3]

Hi Sudipta,

I hope you have checked the logs generated by the patch update for any possible issues.

Make sure oracle_home is same for sidadm orasid and listener.ora

Give a full restart of you server and start oracle with orasid. Now give R3trans -d.

Check alert logs

Also, have a look at 491174 - Composite SAP note for ORA-01034

If this is not working then we can move further.

Regards

[Former Member]

Dear

you have to increase you shared memory and you need to check ORACLE_SID and ORACLE_HOME entry should properly match with /etc/oratab or /var/opt/oracle/oratab .

ORA-01034: ORACLE not available tips

this may solve your problem

Regards

[Former Member]

Hi Mate, Did you restarted your listener and it seems more of environment variables issue. Check your environment variables,TNS values also the softlinks to home directories.

[Former Member]

Hi Tatha,

I have restarted listener couple of time. Which particular env variable should I checked TNS_ADMIN, & other and did not find anything wrong. Can you please tell me which Env variables should I cross check.

Thanks

Sudipta Basak 

[Former Member]

Hi Sudipta..Can you plz check the ORACLE_SID, ORACLE_HOME, TNSPING for the SIDADM? Also the file level permissions for SIDadm/ORAsid(unlikely as the DB is running)

Check the tnsnames.ora for RP2 if everything is correct there. Again check the running listener - goto status and check if it matches correct RP2 values/references?

Check here if this helps..

http://scn.sap.com/thread/2088745

http://h30499.www3.hp.com/t5/Databases/HPUX-ia64-Error-2-No-such-file-or-directory/td-p/4622977#.U_k...

-As of now by going through the log it seems that the R3trans is able to fetch the basic info of the oracle(upgraded version-patches) which is similar to getting into sqlplus without any logon..but when R3trans is trying to logon it's not able to determine the instance so above mentioned one/some is surely to be blamed for.

[Sriram2009]

Hi Sudipta

Could you refer the SAP KBA 1860519 - SAP fails to connect to the database

BR

SS