Home » RDBMS Server » Server Administration » ORA-12505 TNS:Listener does not currently know of SID given in connect descriptor
ORA-12505 TNS:Listener does not currently know of SID given in connect descriptor [message #210991] Sun, 24 December 2006 14:07 Go to next message
Dubbie
Messages: 2
Registered: December 2006
Junior Member
Hello,

I currently have a problem when starting my database. I don't understand why it doesnt work anymore it worked for a whole week at school, but my guess is that I mihgt have closed my laptop unproperly and now it doesn't work.

Here are the files

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=
#BEQUEATH CONFIG
(GLOBAL_DBNAME=hotelsys)
(SID_NAME=sid1)
(ORACLE_HOME=C:\oracle\product\10.2.0\db_1)
#PRESPAWN CONFIG
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=5)(TIMEOUT=1))
)
)
)


DIRECT_HANDOFF_TTC_LISTENER = OFF


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = dd-aud6lnp62lxo)(PORT = 1521))
)
)




tnsnames.ora


# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


#I don't use this one it was a test
HOTELSYS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dd-aud6lnp62lxo)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hotelsys)
)
)

#I use this one, but crashed now
MICROLAB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dd-aud6lnp62lxo)(PORT = 1521))
)
(CONNECT_DATA =
(SID = hotelsys)
(SERVER = DEDICATED)
)
)


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



sqlnet.ora


# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

#AUTOMATIC_IPC = OFF
#TRACE_LEVEL_CLIENT = OFF
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)





Re: ORA-12505 TNS:Listener does not currently know of SID given in connect descriptor [message #210992 is a reply to message #210991] Sun, 24 December 2006 14:43 Go to previous messageGo to next message
Dubbie
Messages: 2
Registered: December 2006
Junior Member
Ok i got it to work again.

What i did is cut and paste to another place(jsut in case it would worsen the problem).

sqlnet0612201AM4342.bak

Which was in the directory:
C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN

Only thing I would ask is what does that file do?
Re: ORA-12505 TNS:Listener does not currently know of SID given in connect descriptor [message #210999 is a reply to message #210992] Sun, 24 December 2006 22:16 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Go through below link
http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm



regards
Taj
Previous Topic: creation of Database
Next Topic: my instance is not starting up...
Goto Forum:
  


Current Time: Thu Dec 08 14:14:18 CST 2016

Total time taken to generate the page: 0.08883 seconds