Re: Changing SIDs within svrmgrl?

From: David Fitzjarrell <oratune_at_aol.com>
Date: Tue, 23 Jan 2001 20:48:07 GMT
Message-ID: <94kqm2$glk$1@nnrp1.deja.com>

In our last gripping episode staryeti_at_bellsouth.net wrote:
> In article <3a6ccc43$1_at_news.iprimus.com.au>,
> "Howard J. Rogers" <howardjr_at_www.com> wrote:
> >
> > <staryeti_at_bellsouth.net> wrote in message
> > news:94icnv$dsu$1_at_nnrp1.deja.com...
> > > In article <3a6a0827$1_at_news.iprimus.com.au>,
> > > "Howard J. Rogers" <howardjr_at_www.com> wrote:
> > > > True. But if he means "having connected internal to ORCL, can I
 now
 -still
> > > > within Server Manager- connect to BLAH?" then the answer is, of
 course,
> > > > yes -provided tnsnames etc. is working correctly, then
 a 'connect
> > > > internal/password_at_BLAH' should do it, regardless of what his
 ORACLE_SID is
> > > > set to.
> > >
> > > When I try that, I get "TNS: could not resolve service name"
> > >
> >
> > Note the small proviso I made: "provided tnsnames etc. is working
> > correctly". Guess what? Your tnsnames.ora is NOT working
 correctly.
> >
> > Time to create a tnsnames.ora file which correctly identifies the
 alias by
> > which you wish to connect using the "@" technique, the host on which
 the
> > listener for that database is listening, and its port.
> >

>

> Well, I *think* I've got it created correctly. Entry reads:

>

> TEMPOP =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= onestop)(Port= 1523))
> (CONNECT_DATA = (SID = TEMPOP))
> )

>

> Something I'm missing here?

>

> Thanks,
> Harry

>

> Sent via Deja.com
> http://www.deja.com/

>

It would appear that TEMPOP is actually a SERVICE_NAME rather than an SID, and that the instance identified by TEMPOP is an 8i instance. The connect data would be:

 TEMPOP =
   (DESCRIPTION =

     (ADDRESS = (PROTOCOL= TCP)(Host= onestop)(Port= 1523))
     (CONNECT_DATA = (SERVICE_NAME = TEMPOP))
     )

This may solve your problem.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/

Received on Tue Jan 23 2001 - 14:48:07 CST