Quote Originally Posted by pranavgovind
Dear Dbasan,

You said, the problem is with protocol. But how do i correct? What should i do now?. Please let me know.
Code:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = VALUED-CB7D4C82)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
)
When you are editing these file be carefull take acopy before doing. Address parameter is not set right. Also it is better to use IP address in host instead of name. Good luck.