Re: Multiple Homes and CONNECT

Did you check :

1. tnsping two --> is it ok ? if not check tnsnames.ora and listener.ora
2. did you call the oraenv to change the SID ?
3. 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.