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:
Hi Taj, I found your workaround through Oracle FAQ forum. It worked for me...thanks for sharing such a wonderful tip
Post a Comment