Search This Blog

Thursday, February 8, 2007

ORA-12514

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor



One reason is default listener registration is DYNAMIC you have to change DYNAMIC to STATIC.
edit your listener.ora file like below

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

C:\>LSNRCTL stop
C:\>REM WAIT FEW SECONDS
C:\>LSNRCTL start


--------------------------------------------------------------------------

1 comment:

Anonymous said...

Hi Taj, I found your workaround through Oracle FAQ forum. It worked for me...thanks for sharing such a wonderful tip