Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: I can't login to OEM now--"SID given in connect descriptor could not be resolved"
Do you connect directly to database using OEM or you connect to management
server?
If you are using management server, then you should check whether you
modified something in OEM's repository ...
-- Cheers, Valentin [to reply remove "~3114" from the email address] "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:69t5kuclgrdpvvop13a8delqtajvcn170l_at_4ax.com...Received on Sun Jul 28 2002 - 11:12:00 CDT
> 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