Re: Multiple Homes and CONNECT
From: Bernard Polarski <bpolarsk_at_yahoo.com>
Date: 2000/06/27
Message-ID: <8j9lds$q2k$1_at_nnrp1.deja.com>#1/1
Date: 2000/06/27
Message-ID: <8j9lds$q2k$1_at_nnrp1.deja.com>#1/1
Did you check :
-
[Quoted]
- tnsping two --> is it ok ? if not check tnsnames.ora and listener.ora
- did you call the oraenv to change the SID ?
- Do not forget to declare the entry of two in the oratab
> > I have two (Oracle 8.1) Oracle Homes on my system, and I'm having
trouble
> > connecting to the second one in Server Manager. I haven't yet
disabled any
> > of the default user IDs. For the first Oracle Home, I can connect
with
> >
> > connect interal/oracle_at_oracle
> >
> > For the second Oracle Home, I have an instance with an SID of Two,
so I
> > tried
> >
> > connect interna/oracle_at_two
> >
> > But this didn't work. Is there some special syntax trick for making
this
> > connection?
> >
> > Thanks in advance for any suggestions.
> >
> > Joseph Morales
>
> Have you tried creating a database link from one SID to the other?
>
> -Matt
>
>
-- B.Polarski http://www.geocities.com/bpolarsk Email : bpolarsk_at_yahoo.com Sent via Deja.com http://www.deja.com/ Before you buy.Received on Tue Jun 27 2000 - 00:00:00 CEST