Re: Enterprise Manager 10g database status unavailable--configuration issue

From: nyphot <jonathan_at_oho.com>
Date: 31 May 2005 07:55:40 -0700
Message-ID: <1117551340.114367.199310@g43g2000cwa.googlegroups.com>

Dave, yes, my listener is running. Valentin, I'm not sure--I don't know what the options for registering with the listener are. My guess is that it's not a dynamic registration though. I put an entry in my listener.ora file and then used lsnrctl start.

Do I need to use a hostname instead of an IP in my listener or something like that? Specify my SID or my db_name? These entries work if I want to connect via SQL*Plus so I thought they were generally okay, but...

Here are my listener.ora and tnsnames.ora files if that helps any:

listener.ora:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = oraclej)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
(GLOBAL_DBNAME = oraclej)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.0.50)(PORT = 1521))
      )

    )
  )

tnsnames.ora:

ORACLEJ =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.0.50)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = oraclej)

    )
  ) Received on Tue May 31 2005 - 09:55:40 CDT