Connect to db using Enterprise Manager.

From: Kevin S. Smith <SpamNoMore_at_EriePlating.com>
Date: Fri, 17 May 2002 10:42:26 -0400
Message-ID: <uea5lu550267e5@corp.supernews.com>

When I am in Oracle Enterprise Manager, I can discover the node 192.168.xxx.xxx. However when I try to connect to the database, I get the following error: Connection failed because target host or object does not exist. Both the listener and the snmp subagent are started and running. I can also connect using sqlplus from the client without any problem. I have posted my listener.ora file (from the managed node) and the tnsnames file from the client. (I have only mispelled the host for security reasons) Can somebody tell me where I am going wrong. I have been trying to figure this out for a while now, and would appreciate help.

# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = pmpp.erie.com)(PORT = 1521))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = pmpp.erie.com)(PORT = 2481))

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.6.1)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = pmpp)
(ORACLE_HOME = /u01/app/oracle/product/8.1.6.1)
(SID_NAME = pmpp)

    )

---

Client tnsnames.ora (below)

---

# D:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle Net8 Assistant

PMPP =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.xxx.xxx)(PORT =
1521))<----the ip address of the managed node****

    )
    (CONNECT_DATA =
(SERVICE_NAME = pmpp)

    )
  ) Received on Fri May 17 2002 - 09:42:26 CDT