Database - RAC/Scalability (MOSC)

MOSC Banner

Unable to connet to ASM instance using spot light

edited Nov 13, 2013 7:54AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered
 
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 =

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center