<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
