Re: Connect to db using Enterprise Manager.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:fucaeug83qssk89ka3dieaqcj28vmjr33v_at_4ax.com...
> 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

Thanks for the reply. I changed the CONNECT_DATA from SERVICE_NAME=pmpp to SID = pmpp
but I still got the same error. In the init.ora file the db_domain parameter is world (don't ask me why it is still at default), however, as you can see, in the listener.ora the host is pmpp.erie.com. This confusing me. I don't know what to put in the tnsnames.ora file! It seems that I have tried everything (obviously I have not), Do you have any suggestions? As you can tell, I am not that experienced with this yet. Thanks for your help...and patience. Received on Fri May 17 2002 - 13:16:55 CDT