DB Startup Failed, Terminating with Error Code 14



Share this article :
<SID>adm:~> startsap

Checking TR3 Database
------------------------------
 ABAP Database is not available via R3trans

Starting SAP-Collector Daemon
------------------------------
18:52:21 29.03.2011   LOG: Effective User Id is root
******************************************************************************
* This is Saposcol Version COLL 20.95 700 - v2.16, AMD/Intel x86_64 with Linux
* Usage:  saposcol -l: Start OS Collector
*         saposcol -k: Stop  OS Collector
*         saposcol -d: OS Collector Dialog Mode
*         saposcol -s: OS Collector Status
* Starting collector (create new process)
******************************************************************************
 saposcol on host HOSTNAME started
 Running /usr/sap/SID/SYS/exe/run/startdb
Trying to start SID database ...
Log file: /home/SIDadm/startdb.log

No SQL*Net V2 connect to SID available.
Check that the listener is running: "lsnrctl status".
Start the listener as user oraSID: "lsnrctl start".

/usr/sap/SID/SYS/exe/run/startdb: Terminating with error code 14
DB startup failed

Above error is the SAP system failed to startup because the Oracle listener is not started. Listener have to be started, before the Oracle database can be started.

1. Switch user to ORA<SID> and check the oracle listener status, lsnrctl status.

HOSTNAME:oraSID> lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-MAR-2011 19:01:11

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
 TNS-00511: No listener
 Linux Error: 111: Connection refused
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=TR3))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
 TNS-00511: No listener
 Linux Error: 111: Connection refused
Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ABC)(PORT= 123))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
 TNS-00511: No listener
 Linux Error: 111: Connection refused

2. Start the Oracle listener, lsnrctl start.

HOSTNAME:oraSID> lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-MAR-2011 19:01:20

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

Starting /oracle/SID/102_64/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/SID/102_64/network/admin/listener.ora
Log messages written to /oracle/SID/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SID.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SID)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOSTNAME.SID)(PORT=1527 )))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                29-MAR-2011 19:01:23
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/SID/102_64/network/admin/listener.ora
Listener Log File         /oracle/SID/102_64/network/log/listener.log
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SID.WORLD)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SID)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOSTNAME.SID)(PORT=1527)))
Services Summary...
Service "SID" has 1 instance(s).
 Instance "SID", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

3. Now your Oracle listener already started. Now, start your SAP system back!

<SID>adm:~> startsap

Related posts

Configure SAP Help
Steps to Maintain Access Data (Logon Data) for SAP Support
Request/task SIDK12356 already released (not modifiable)
SPAM/SAINT: SAPCAR - Error in loading the cryptographic library (error 56)
© 2018 ITsiti. All Rights Reserved
Powered by KEEM