Re: Connect to db using Enterprise Manager.

"Kevin S. Smith" <SpamNoMore_at_EriePlating.com> wrote in message news:uearuu6gp4hi72_at_corp.supernews.com...
> I renamed the sqlnet.ora file on the server then resaved the network
> configurations using Net8 Assistant. It created a new file with only the
> following entry
> SQLNET.EXPIRE_TIME = 0
>
> The sqlnet.ora file on the server to be managed looks like this:
> NAMES.DEFAULT_DOMAIN = erie.com
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
>
> The db_domain in the init.ora file = world
> The host name in the servers listener.ora file = pmpp.erie.com
>
>
> <snip>
> > > > ># 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)
> > > >
>
>
>

You should also not use a DNS address on one site and a hardcoded IP address on the other site.
In this particular situation I have strong suspicions (the DNS address is translated on the server) you are getting a different IP back. That can only be investigated by enabling sqlnet tracing in support mode. How to do this is documented in the net8 administrators manual, and I also posted it numerous times in the Usenet groups.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address