Re: Connect to db using Enterprise Manager.

On Fri, 17 May 2002 10:42:26 -0400, "Kevin S. Smith" <SpamNoMore_at_EriePlating.com> wrote:

>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)
> )
> )
>
>

Please compare

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

and
> (CONNECT_DATA =
> (SERVICE_NAME = pmpp)

They don't match.
The service_name is an init.ora parameter which normally is db_name||'.'||db_domain or db_name when db_domain = NULL AFAIK you also need to use the SID syntax for OEM

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 17 2002 - 11:47:56 CDT