Re: Connect to db using Enterprise Manager.

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 17 May 2002 18:20:36 GMT
Message-ID: <3CE549EE.CE726108@exesolutions.com>

"Kevin S. Smith" wrote:

> "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.

Try renaming sqlnet.ora to sqlnet.bak

Daniel Morgan Received on Fri May 17 2002 - 13:20:36 CDT