cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Terminating with error code 12 DB startup failed

Go to solution
Former Member

on ‎01-13-2014 5:40 PM

0 Kudos

Dear Masta,

I finish install EHP4 and now after rebooting OS, Im starting sap error.

this error :

SANDBOX:sbxadm 2> startsap

Checking SBX Database

------------------------------

Database is not available via R3trans

Running /usr/sap/SBX/SYS/exe/run/startdb

Trying to start SBX database ...

Log file: /home/sbxadm/startdb.log

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

DB startup failed

SANDBOX:sbxadm 1> R3trans -d

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

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

R3trans finished (0012).

and this log from trans.log

4 ETW000 R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 13.01.2014 - 23:29:39

4 ETW000 control file: trans.log

4 ETW000 R3trans was called as follows: R3trans -d trans.log

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [dev trc     ,00000]  Mon Jan 13 23:29:39 2014                             143  0.000143

4 ETW000  [dev trc     ,00000]  db_con_init called                                    25  0.000168

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

4 ETW000  [dev trc     ,00000]  Loading DB library '/usr/sap/SBX/SYS/exe/run/dboraslib.o' ...

4 ETW000                                                                              71  0.000292

4 ETW000  [dev trc     ,00000]  load shared library (/usr/sap/SBX/SYS/exe/run/dboraslib.o), hdl 0

4 ETW000                                                                            4233  0.004525

4 ETW000  [dev trc     ,00000]  Library '/usr/sap/SBX/SYS/exe/run/dboraslib.o' loaded

4 ETW000                                                                              38  0.004563

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

4 ETW000                                                                              41  0.004604

4 ETW000  [dev trc     ,00000]  Version of '/usr/sap/SBX/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.25)

4 ETW000                                                                             247  0.004851

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

4 ETW000                                                                              39  0.004890

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

4 ETW000                                                                              73  0.004963

4 ETW000  [dev trc     ,00000]  New connection 0 created                              55  0.005018

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              49  0.005067

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

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:

4 ETW000                                                                              38  0.005176

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              45  0.005221

4 ETW000  [dev trc     ,00000]  Got LIBPATH=/usr/lib:/lib:/usr/sap/SBX/SYS/exe/run:/oracle/client/10x_64/instantclient from environment

4 ETW000                                                                             558  0.005779

4 ETW000  [dev trc     ,00000]  Oracle Client Version: '10.2.0.2.0'                  168  0.005947

4 ETW000  [dev trc     ,00000]  -->oci_initialize (con_hdl=0)                         37  0.005984

4 ETW000  [dev trc     ,00000]  Client character set UTF16 -> UTF8                  3106  0.009090

4 ETW000  [dev trc     ,00000]  Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'

4 ETW000                                                                              42  0.009132

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

4 ETW000  [dev trc     ,00000]  Connecting as /@SBX on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

4 ETW000                                                                              41  0.009209

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

4 ETW000                                                                              59  0.009268

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      0 0x110ff9200 0x111011678 0x111010f28

4 ETW000                                                                              45  0.009313

4 ETW000  [dev trc     ,00000]  Allocating service context handle for con_hdl=0       40  0.009353

4 ETW000  [dev trc     ,00000]  Allocating server context handle                      34  0.009387

4 ETW000  [dev trc     ,00000]  Attaching to DB Server SBX (con_hdl=0,svchp=0x111014818,srvhp=0x111015b38)

4 ETW000                                                                              90  0.009477

4 ETW000  [dev trc     ,00000]  Assigning server context 0x111015b38 to service context 0x111014818

4 ETW000                                                                           52327  0.061804

4 ETW000  [dev trc     ,00000]  Allocating user session handle                        50  0.061854

4 ETW000  [dev trc     ,00000]  Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x111014818, srvhp=0x111015b38, usrhp=0x111000fe0)

4 ETW000                                                                              53  0.061907

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033

4 ETW000                                                                            8447  0.070354

4 ETW000  [dev trc     ,00000]  server_detach(con_hdl=0,stale=1,svrhp=0x111015b38)

4 ETW000                                                                              40  0.070394

4 ETW000  [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=0x111014818,srvhp=0x111015b38)

4 ETW000                                                                              42  0.070436

4 ETW000  [dev trc     ,00000]  Deallocating server context handle 0x111015b38       169  0.070605

4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '1033'

4 ETW000                                                                              47  0.070652

4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code 1033         25  0.070677

4 ETW000  [dev trc     ,00000]  Try to connect with default password                  68  0.070745

4 ETW000  [dev trc     ,00000]  Connecting as SAPSR3/<pwd>@SBX on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

4 ETW000                                                                              42  0.070787

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

4 ETW000                                                                              44  0.070831

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      0 0x110ff9200 0x111011678 0x111010f28

4 ETW000                                                                              43  0.070874

4 ETW000  [dev trc     ,00000]  Allocating server context handle                      25  0.070899

4 ETW000  [dev trc     ,00000]  Attaching to DB Server SBX (con_hdl=0,svchp=0x111014818,srvhp=0x111015b38)

4 ETW000                                                                              46  0.070945

4 ETW000  [dev trc     ,00000]  Assigning server context 0x111015b38 to service context 0x111014818

4 ETW000                                                                           48431  0.119376

4 ETW000  [dev trc     ,00000]  Assigning username to user session: con_hdl=0, usrhp=0x111000fe0

4 ETW000                                                                              48  0.119424

4 ETW000  [dev trc     ,00000]  Assigning password to user session: con_hdl=0, usrhp=0x111000fe0

4 ETW000                                                                              44  0.119468

4 ETW000  [dev trc     ,00000]  Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0x111014818, srvhp=0x111015b38, usrhp=0x111000fe0)

4 ETW000                                                                              65  0.119533

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033

4 ETW000                                                                            5904  0.125437

4 ETW000  [dev trc     ,00000]  server_detach(con_hdl=0,stale=1,svrhp=0x111015b38)

4 ETW000                                                                              38  0.125475

4 ETW000  [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=0x111014818,srvhp=0x111015b38)

4 ETW000                                                                              40  0.125515

4 ETW000  [dev trc     ,00000]  Deallocating server context handle 0x111015b38       160  0.125675

4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '1033'

4 ETW000                                                                              44  0.125719

4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code 1033         24  0.125743

4 ETW000  [dblink      ,00431]  ***LOG BY2=>sql error 1033   performing CON [dblink#3 @ 431]

4 ETW000                                                                             145  0.125888

4 ETW000  [dblink      ,00431]  ***LOG BY0=>ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431]

4 ETW000                                                                              40  0.125928

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

I hope resolve this issue.

regards,

RhA.

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎01-13-2014 5:57 PM
0 Kudos

>> ***LOG BY0=>ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431]


Looks like you have not stopped the database manually before rebooting the system.


logon as orasbx and try to stop and again start the database again.

Show replies
Show replies
Former Member
‎01-15-2014 2:31 AM
0 Kudos

Dear Sunil.

Im trying shutdown database,

and have a problem. how to resolve it..



SQL> shutdown immediate


ORA-01109: database not open










Database dismounted.


ORACLE instance shut down.


SQL> startup


ORACLE instance started.






Total System Global Area 1.8170E+10 bytes


Fixed Size                  2116104 bytes


Variable Size            9110029816 bytes


Database Buffers         9042919424 bytes


Redo Buffers               14659584 bytes


Database mounted.


ORA-16038: log 2 sequence# 1350 cannot be archived


ORA-19502: write error on file "", blockno  (blocksize=)


ORA-00312: online log 2 thread 1: '/oracle/SBX/origlogB/log_g12m1.dbf'


ORA-00312: online log 2 thread 1: '/oracle/SBX/mirrlogB/log_g12m2.dbf'

regards,

RhA

Former Member
‎01-15-2014 8:44 AM
0 Kudos

Check available space in /oracle/SBX/oraarch filesystem.

Former Member
‎01-15-2014 10:27 AM
0 Kudos

Ok good, then try below

logon as <SID>adm execute R3trans -d command. If the result is 000 then start SAP.

if not then attach the trans.log.

Answers (3)

Answers (3)

Former Member
‎01-17-2014 3:45 AM
0 Kudos

Dear Roman N,

Your right, the problem is oraarch is full.

than you roman N.

regards,

RhA

Show replies
Show replies
Former Member
‎01-14-2014 8:18 AM
0 Kudos

Hi,

others told you what to do, but your DBMS release is completely outdated, if you wish to use 10g at least update it to 10.2.0.4 inculding the Oracle client which is 10.2.0.2 based on the log.

Regards

Tamás

Show replies
Show replies
Former Member
‎01-15-2014 2:29 AM
0 Kudos

Dear Tamas.

your have solution?

Former Member
‎01-15-2014 7:31 AM
0 Kudos

Hi,

please check the /oracle and /oracle/SBX authorizations/ownerships as well.

Regards

Tamás

Former Member
‎01-15-2014 7:32 AM
0 Kudos

Andof course the origlog/mirrlogs too!

nirmal_konchada
Active Contributor
‎01-13-2014 5:56 PM
0 Kudos

Hi,

Please check if your listener is up and also check the below note

655240 - Composite SAP note: ORA-01033

Regards,

Nirmal.

Show replies
Show replies
Ask a Question