Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dual server configuration question

Re: dual server configuration question

From: epilip <epilip_at_free.fr>
Date: Thu, 26 Jan 2006 08:00:45 +0100
Message-ID: <43d880b0$0$8989$626a54ce@news.free.fr>


z a écrit :
> Let's say I want to set up two systems, A.D and B.D
> where D is the Internet domain.
>
> Each system supports an Oracle server (9i or possibly
> 10g).
>
> Also, I would like A to be B's oracle client.
>
> Is this possible?

Yes
>
> Let's say A has Oracle SID X and B has Oracle SID Y.
>
> What do the tnsname.ora files look like (roughly)?

Like any tnsnames.ora
on A.D Yalias=(...host=B.D...SID=Y...)
on B.D Xalias=(...host=A.D...SID=X...)

>
> (I'm presuming the connect statement forms
> would be obvious from the answers to the above.)
>
> Lower priority:
>
> Can a 10g client connect to a 9i server (without DB migration)?
Sure
>
> Can a 9i server connect to a 10g client (without DB
> migration)?

Sure
>
> Thanks,
>
> -z
>
>
Received on Thu Jan 26 2006 - 01:00:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US