Why won't Oracle start?
Posted on 2009-05-28
We use Oracle intermittently on a development platform, and today when I went to connect, I saw it wasn't running. I'm far from a expert in managing Oracle, I know just barely enough to get it going, and today the commands I usually use don't work. My notes say to log in as user oracle, then:
The listener seems to start, but the dbstart command fails with a useless error message. Here's what happens:
$ lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 28-MAY-
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /oracle/app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait.
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
System parameter file is /oracle/app/oracle/oracle/product/10.2.0/db_1/network/a
Log messages written to /oracle/app/oracle/oracle/product/10.2.0/db_1/network/lo
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=biggerblue.cansys.mb.ca)
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1
.0 - Production
Start Date 28-MAY-2009 10:22:15
Uptime 0 days 0 hr. 0 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File /oracle/app/oracle/oracle/product/10.2.0/db_1/network/
Listener Log File /oracle/app/oracle/oracle/product/10.2.0/db_1/network/
Listening Endpoints Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
The path name in this error message does not exist on our server, and has never existed on our server.