Oracle Database Discussions

Hello,

I am running and accessing an Oracle10g instance locally on a Windows XP dev.
machine. Today I suddenly started getting

ORA-12514, TNS:listener does not currently know of service requested in connect
descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)
(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

when trying to start the web-based em console. My tnsnames.ora is

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

and my listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle10g)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

I can't find any init.ora file. If I ask for the list of services using lsnrctl at the
command line, it says:

LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
Service "Oracle10g" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:9 refused:0
LOCAL SERVER
(ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ENVS='ORACLE_HOME=C:\oracle\pro
duct\10.1.0\Db_1,ORACLE_SID=orcl')(ARGV0=oracleorcl)(ARGS='(LOCAL=NO)'))
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
(ADDRESS=(PROTOCOL=beq)(PROGRAM=extproc)(ENVS='ORACLE_HOME=C:\oracle\pr
oduct\10.1.0\Db_1,ORACLE_SID=PLSExtProc')(ARGV0=extprocPLSExtProc)(ARGS='(LOCAL=
NO)'))
The command completed successfully

I am no dba and am baffled by this situation. In the net manager there
is indeed a listener called "LISTENER" and it is running as a service.

I read somewhere else on this forum in a similar thread that I should rename
the listener from LISTENER to ORCL but I'm not crazy about manually hacking
my config files and I'd like someone confirm that I should do that after looking at
the information above.

Thanks a lot if you can advise!