Re: Changing SIDs within svrmgrl?

From: <staryeti_at_bellsouth.net>
Date: Tue, 23 Jan 2001 19:40:20 GMT
Message-ID: <94kmn2$cri$1@nnrp1.deja.com>

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/ Received on Tue Jan 23 2001 - 13:40:20 CST