Re: Changing SIDs within svrmgrl?

<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.

HJR
>
> Harry
>
>
> > <rereidy_at_my-deja.com> wrote in message
 news:94cqor$119$1_at_nnrp1.deja.com...
> > > No,
> > >
> > > The SID is an environment variable. You will need to exit svrmgrl,
 set
> > > to the desired value, and restart svrmgrl.
> > >
> > > Ron Reidy
> > > Oracle DBA
> > >
> > > In article <949vaq$pse$1_at_nnrp1.deja.com>,
> > > staryeti_at_bellsouth.net wrote:
> > > > Is it possible to do this when in as "connect internal"?
> > > >
> > > > Thanks,
> > > > Harry
> > > >
> > > > Sent via Deja.com
> > > > http://www.deja.com/
> > > >
> > >
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 22 2001 - 18:12:25 CST