Re: I can't login to OEM now--"SID given in connect descriptor could not be resolved"

On Sat, 27 Jul 2002 18:59:19 +0800, "fish" <zuohong.f.yu_at_bigfoot.com> wrote:

>Hi Sybrand,
>
>I couldn't find anything wrong in these two files. Please take a look.
>SID=local
>
>----------------------------------------------------------------------------
>-------
># TNSNAMES.ORA Network Configuration File:
>/home/oracle/product/8.1.7/network/admin/tnsnames.ora
># Generated by Oracle configuration tools.
>
>LOCAL.FISH.HOME.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = svr1.fish.home.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = local)
> )
> )
>
>EXTPROC_CONNECTION_DATA.FISH.HOME.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
>INST1_HTTP.FISH.HOME.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = svr1.fish.home.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = local)
> (PRESENTATION = http://admin)
> )
> )
>
>----------------------------------------------------------------------------
>-----------
># LISTENER.ORA Network Configuration File:
>/home/oracle/product/8.1.7/network/admin/listener.ora
># Generated by Oracle configuration tools.
>
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = svr1.fish.home.com)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = svr1.fish.home.com)(PORT = 2481))
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /home/oracle/product/8.1.7)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = local)
> (ORACLE_HOME = /home/oracle/product/8.1.7)
> (SID_NAME = local)
> )
> )
>
>
>

I'm baffled:
there is no 'sid=local' in your tnsnames.ora, there is a *service_name* = local in your tnsnames.ora, and as the database registers service_name parameters (service_name is in init.ora) automatically, there is no service_name = in listener.ora, by design. In short: your tnsnames.ora potentially can work, but as I don't have the service_name parameter in init.ora, I can't say whether there is a match.
As OEM, at least the Intelligent Agent part of it, is still relying on sqlnet's 2 sid = syntax, I would try changing the tnsnames.ora service_name = in sid = and see what happens.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 27 2002 - 14:35:43 CDT