Re: Connect to db using Enterprise Manager.

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)

> > >