cancel
Showing results for 
Search instead for 
Did you mean: 

<sidadm> doesn't start oracle database after oracle upgrade to 11g

Former Member
0 Kudos
282

Hello gurus,

I upgraded oracle 10.2 to 11.3g on a SAP ECC runing on HP-UX.

After that, the user <sidadm> is not able to start database and sap.

When I do startsap it returns the following message.

/usr/sap/SID/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed.

Can you please help me.


Best regards

Ernesto Mandlate

Accepted Solutions (0)

Answers (2)

Answers (2)

divyanshu_srivastava3
Active Contributor
0 Kudos

Check oracle_home and in listner.ora.

Former Member
0 Kudos

Hello Mr. Divyanshu

I have checked the listener.ora. The oracle_home is there.

....

STARTUP_WAIT_TIME_LISTENER = 0

ADR_BASE_listener.ora=/oracle/SID/saptrace

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = SID)

      (ORACLE_HOME = /oracle/SID/112_64)

....

Best regard

Ernesto Mandlate

divyanshu_srivastava3
Active Contributor
0 Kudos

HI Ernesto,

Two options -

1st goto orasid and start your database -

sqlplus / as sysdba

shutdown immediate

startup

Now goto sidadm and startsap

2nd -

goto orasid and start your database -

sqlplus / as sysdba

shutdown immediate

Now goto sidadm and startsap

In both cases startdb.log is generated, share it with us.

Also your kernel version.

Regards,

Divyanshu

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

What is the output of R3trans -d ?

Have you modified the environment variable of the sidadm and orasid users with the new values ?

Are you using the new version of the Oracle instant client ?

Regards

RB

Former Member
0 Kudos

Hello Reagan,

Please find bellow the trans.log.

I have to check about environment variable of sidadm andb orasid.

Yes, I am using the reccommeded version of Oracle Instant Client according the oracle upgrade guide.

4 ETW000 R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 05.09.2014 - 12:40:51

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]  Fri Sep  5 12:40:51 2014                                                 214  0.000214

4 ETW000  [     dev trc,00000]  db_con_init called                                                        16  0.000230

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        89  0.000319

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

4 ETW000                                                                                                  16  0.000335

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 10  0.000345

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/DSV/SYS/exe/run/dboraslib.so' ...            43  0.000388

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/DSV/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000                                                                                               31940  0.032328

4 ETW000  [     dev trc,00000]  Library '/usr/sap/DSV/SYS/exe/run/dboraslib.so' loaded                    14  0.032342

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  29  0.032371

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/DSV/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.522)

4 ETW000                                                                                                 282  0.032653

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  22  0.032675

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  40  0.032715

4 ETW000  [     dev trc,00000]  function sapic_get_instant_client_version loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  33  0.032748

4 ETW000  [     dev trc,00000]  function sapic_get_instant_client_flavor loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  23  0.032771

4 ETW000  [     dev trc,00000]  function sapic_get_patchset_version loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  23  0.032794

4 ETW000  [     dev trc,00000]  function sapic_get_ls_inventory loaded from library /usr/sap/DSV/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  23  0.032817

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

4 ETW000                                                                                                  33  0.032850

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK)                     12  0.032862

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

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  11  0.032885

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                                                                                                  37  0.032922

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

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

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

4 ETW000                                                                                                  16  0.032961

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                           9  0.032970

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                                                                                                  19  0.032989

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

4 ETW000                                                                                                  57  0.033046

4 ETW000  [     dev trc,00000]  Register application info.                                               278  0.033324

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

4 ETW000                                                                                                  88  0.033412

4 ETW000  [     dev trc,00000]  Installed Oracle client patches:                                          23  0.033435

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

4 ETW000                                                                                                  17  0.033452

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

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

4 ETW000  [     dev trc,00000]    Default connection: tnsname ='DSV'                                      17  0.033500

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

4 ETW000                                                                                                  27  0.033527

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

4 ETW000                                                                                                9090  0.042617

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

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

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

4 ETW000  [     dev trc,00000]                     terr=414D4552494341                                    13  0.042836

4 ETW000  [     dev trc,00000]                     char=574538444543                                      13  0.042849

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

4 ETW000                                                                                                  17  0.042866

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

4 ETW000  [     dev trc,00000]  Logon as OPS$-user to get SAPSR3's password                               26  0.042903

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

4 ETW000                                                                                                  18  0.042921

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

4 ETW000  [     dev trc,00000]  Allocating server context handle                                          22  0.043028

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

4 ETW000                                                                                                  34  0.043062

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

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=01474150)               92  0.124513

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

4 ETW000                                                                                                  20  0.124533

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

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

4 ETW000  [     dev trc,00000]     ORA-01034: ORACLE not available                                        15  0.129232

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)                               25  0.129257

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

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

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

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

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

4 ETW000  [     dev trc,00000]  ORA-01034: ORACLE not availabl                                            11  0.129725

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

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

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

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

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

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

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

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)                        35  0.129943

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

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

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

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

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

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

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

Please supply the environment variables of orasid and sidadm users.

su - orasid

env

su - sidadm

env

Regards

RB