terminating with error code 12 database startup failed

[Former Member]

hi friends,

i have stuggled in this place,

i doing solution manager upgradation 3.1 to 7.0.

we using oracle 10.2.0.2, os redhat linux.

after upgradation of oracle, i cant able to start the SAP instance.

its shows the error .....

-

---

smradm> startsap

Checking SMR Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

02:00:38 06.11.2009 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.95 711 - v2.16, Intel x86 with Linux, 2008/08 /21

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 2911) is already running .....

************************************************************************

saposcol already running

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

Trying to start SMR database ...

Log file: /home/smradm/startdb.log

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

DB startup failed

-

---

friends help me ...

regards,

selva...

[former_member227283 · Accepted solution]

Hi,

Check you oracle listner is up or not

Pls run the following command to start oracle listner

login on Os with ORASID user

lsnrctl start

Thanks

Anil

[former_member227283]

Hi,

As mention by one of my friend , pls paste the startdb.log

Thanks,

Anil

[Former Member]

i started sql server also its started, details below

-

---

orasmr> sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Nov 9 11:13:06 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1002438656 bytes

Fixed Size 1264532 bytes

Variable Size 562037868 bytes

Database Buffers 436207616 bytes

Redo Buffers 2928640 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning and Data Mining options

orasmr> exit

-

---

and i check listner also, details below..............

orasmr> lsnrctl start

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 09-NOV-2009 11:11:46

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /oracle/SMR/102_32/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.2.0 - Production

System parameter file is /oracle/SMR/102_32/network/admin/listener.ora

Log messages written to /oracle/SMR/102_32/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SMR.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SMR)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=smrtest.myenteg.com)(PORT=1527)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SMR.WORLD))

STATUS of the LISTENER

-

---

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.2.0 - Production

Start Date 09-NOV-2009 11:11:50

Uptime 0 days 0 hr. 0 min. 1 sec

Trace Level off

Security ON: Local OS Authentication

SNMP ON

Listener Parameter File /oracle/SMR/102_32/network/admin/listener.ora

Listener Log File /oracle/SMR/102_32/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SMR.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SMR)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=smrtest.myenteg.com)(PORT=1527)))

Services Summary...

Service "SMR" has 1 instance(s).

Instance "SMR", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

-

---

but even i cont able to start sap user .

[Former Member]

Hi Selvakumar,

can you manually start the Database from SQLplus?

can you cut/paste here the content of the file "/home/smradm/startdb.log"?

Regards,

Federico Biavati

[Former Member]

smradm> cat /home/smradm/startdb.log

-

---

Mon Nov 9 12:44:48 IST 2009

LOGFILE FOR STARTING ORACLE

Trying to start SMR database ...

-

---

Mon Nov 9 12:44:48 IST 2009

checking required environment variables

ORACLE_HOME is >/oracle/SMR/102_32<

ORACLE_SID is >SMR<

-

---

Mon Nov 9 12:44:48 IST 2009

check initora

-

---

Mon Nov 9 12:44:48 IST 2009

check initora

-

---

Mon Nov 9 12:44:48 IST 2009

checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 09-NOV-2009 12:44:48

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/oracle/SMR/102_32/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = smrtest) (PORT = 1527))) (CONNECT_DATA = (SID = SMR) (GLOBAL_NAME = SMR.WORLD)))

OK (10 msec)

tnsping: V2 connect to SMR

-

---

Mon Nov 9 12:44:48 IST 2009

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Mon Nov 9 12:44:49 IST 2009

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Mon Nov 9 12:45:02 IST 2009

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Nov 9 12:45:02 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1002438656 bytes

Fixed Size 1264532 bytes

Variable Size 562037868 bytes

Database Buffers 436207616 bytes

Redo Buffers 2928640 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning and Data Mining options

-

---

Mon Nov 9 12:45:16 IST 2009

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

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

[hannes_kuehnemund]

Ok,

R3trans finishes with Return Code 12 (this is not good). Please provide trans.log from the directory where you were in when starting the DB. If you have been in ~, then provide ~/trans.log

Hannes

[Former Member]

>

> Ok,
> 
> R3trans finishes with Return Code 12 (this is not good). Please provide trans.log from the directory where you were in when starting the DB. If you have been in ~, then provide ~/trans.log
> 
> Hannes

smradm> cat trans.log

4 ETW000 R3trans version 6.13 (release 640 - 21.10.08 - 10:02:00).

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

4 ETW000

4 ETW000 date&time : 09.11.2009 - 14:58:07

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [dev trc ,00000] Mon Nov 9 14:58:07 2009 664 0.000664

4 ETW000 [dev trc ,00000] db_con_init called 112 0.000776

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

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

4 ETW000 148 0.001253

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

4 ETW000 35005 0.036258

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

4 ETW000 77 0.036335

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

4 ETW000 74 0.036409

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

4 ETW000 426 0.036835

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

4 ETW000 65 0.036900

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

4 ETW000 155 0.037055

4 ETW000 [dev trc ,00000] New connection 0 created 122 0.037177

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 220 0.037397

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

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

4 ETW000 61 0.037504

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 66 0.037570

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/SMR/102_32 from environment

4 ETW000 1390 0.038960

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

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 127 0.039305

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 8844 0.048149

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSMR's password 127 0.048276

4 ETW000 [dev trc ,00000] Connecting as /@SMR on connection 0 (nls_hdl 0) ... (dbsl 640 180309)

4 ETW000 137 0.048413

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

4 ETW000 68 0.048481

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 0x8f80ed8 0x8f85fb0 0x8f85a50

4 ETW000 141 0.048622

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

4 ETW000 [dev trc ,00000] Allocating server context handle 72 0.048820

4 ETW000 [dev trc ,00000] Attaching to DB Server SMR (con_hdl=0,svchp=0x8f859dc,srvhp=0x8f86c74)

4 ETW000 280 0.049100

4 ETW000 [dev trc ,00000] Assigning server context 0x8f86c74 to service context 0x8f859dc

4 ETW000 145429 0.194529

4 ETW000 [dev trc ,00000] Allocating user session handle 139 0.194668

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x8f859dc,srvhp=0x8f86c74,usrhp=0x8f9010c)

4 ETW000 109 0.194777

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

4 ETW000 7975 0.202752

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

4 ETW000 102 0.202854

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

4 ETW000 69 0.202923

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x8f86c74 521 0.203444

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

4 ETW000 176 0.203620

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 154 0.203774

4 ETW000 [dev trc ,00000] Try to connect with default password 52 0.203826

4 ETW000 [dev trc ,00000] Connecting as SAPSMR/<pwd>@SMR on connection 0 (nls_hdl 0) ... (dbsl 640 180309)

4 ETW000 104 0.203930

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

4 ETW000 68 0.203998

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 0x8f80ed8 0x8f85fb0 0x8f85a50

4 ETW000 66 0.204064

4 ETW000 [dev trc ,00000] Allocating server context handle 44 0.204108

4 ETW000 [dev trc ,00000] Attaching to DB Server SMR (con_hdl=0,svchp=0x8f859dc,srvhp=0x8f86c74)

4 ETW000 110 0.204218

4 ETW000 [dev trc ,00000] Assigning server context 0x8f86c74 to service context 0x8f859dc

4 ETW000 152111 0.356329

4 ETW000 [dev trc ,00000] Assigning username to user session 0x8f9010c 64 0.356393

4 ETW000 [dev trc ,00000] Assigning password to user session 0x8f9010c 83 0.356476

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x8f859dc,srvhp=0x8f86c74,usrhp=0x8f9010c)

4 ETW000 68 0.356544

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

4 ETW000 19584 0.376128

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

4 ETW000 83 0.376211

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

4 ETW000 146 0.376357

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x8f86c74 310 0.376667

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

4 ETW000 118 0.376785

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 43 0.376828

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 12705 performing CON [dblink#5 @ 428]

4 ETW000 382 0.377210

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-12705: Cannot access NLS data files or invalid environment specified [dblink#5 @ 428]

4 ETW000 67 0.377277

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

[markus_doehr2]

> 4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 12705 performing CON [dblink#5 @ 428]

> 4 ETW000 382 0.377210

> 4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-12705: Cannot access NLS data files or invalid environment specified [dblink#5 @ 428]

Did you change/install the Oracle instantclient?

Markus

[Former Member]

Check the Enivronment variables for ORA_NLS.