| ORA-12505 TNS:Listener does not currently know of SID given in connect descriptor [message #210991] |
Sun, 24 December 2006 14:07  |
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)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
