Unable to connet to ASM instance using spot light
Hi ,
I have 4 node rac database using 10g(10.2.0.3)running on windows 2003 R2 and ASM instance is running from DB HOME.
I am trying to configure Spotlight to connect to ASM instance to monitor disk I/O. Unfortunately getting following error.
ORA-12528: TNS:listener:all all appropriate instances are blocking new connections
here is my LISTENER.ORA and TNSNAMES.ORA
Listener.ora(from instance2)
============================
# listener.ora Network Configuration File: \oracle\product\10.2.0\db_2\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER_SERV-DB02 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = \oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
)
(SID_DESC =
0