All,
We recently lost power and a server that shouldn't have been in production anymore is apparently something that needs to be online. I'm not a DBA by any stretch, so this is a bit over my head. It's running oracle 10g services on top of a Windows 2003 standard server. The error I receive, even trying to connect to SQL Plus among other utilities is: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
There's nothing obvious in the event viewer and listener.log has this at the tail end:
Started with pid=2884
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sstudent)(PORT=1550)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
04-NOV-2009 10:04:29 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
04-NOV-2009 10:04:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=starbase)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1449)) * establish * starbase * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
04-NOV-2009 10:04:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=starbase)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1450)) * establish * starbase * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
04-NOV-2009 10:04:59 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=starbase)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1451)) * establish * starbase * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
04-NOV-2009 10:16:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=starbase)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\BIN\sqlplusw.exe)(HOST=SSTUDENT)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.8)(PORT=1457)) * establish * starbase * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
04-NOV-2009 10:25:28 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
lsnrctl status produces the following:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-NOV-2009 10:29
:31
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sstudent)(PORT=1550)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 04-NOV-2009 10:04:28
Uptime 0 days 0 hr. 25 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sstudent)(PORT=1550)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
And here is listener.ora:
C:\oracle\product\102~1.0\db_1\NETWORK\ADMIN>more listener.ora
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network
\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sstudent)(PORT = 1550))
)
)