Login problem

Hi

I've starting getting an error on starting up a database instance saying:

Agent connect to Instance. Status: Failed Details ORA-12505: TNSlistener doesn not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)

I've checked the status of the listener using: lsnrctl status test and the database instance doesnt appear, although another instance does. Its only setup on an un-networked laptop so nothing will have changed from yesterday, when it was working fine. Below are my tnsnames.ora and listener.ora

TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)

    )
  )

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

    )
  )

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

    )
  )

'######################

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 = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

'##########################

Im using Oracle 10.2.0 on windowsXP.

Thanks for any help you can provide.
Paul Received on Thu May 11 2006 - 04:55:57 CDT