Hi,
I have installed oracle 10g in windows xp home edition. After the intallation, i was able to login the database. Once I restarted the machine, i am getting the following error.
ORA-12514: TNS:listener does not currently know of service requested in connect
Following is my tns entry
TKYTE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TKYTE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Following is my listener entry
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\ora10g)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
Following is the tnsping result
C:\Documents and Settings>tnsping tkyte
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 30-DEC-2
008 08:55:27
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
C:\ora10g\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TKYTE)))
OK (140 msec)
Following is the listener service
C:\Documents and Settings>lsnrctl service
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 30-DEC-2008 08:56
:32
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
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
The command completed successfully
Please anyone help me to sortout the problem.