(wrong string) – is they a way to provide indirection for db name?

From: <zigzagdna_at_yahoo.com>
Date: Mon, 5 Jan 2009 15:12:42 -0800 (PST)
Message-ID: <63eaf303-9a27-4a73-bf27-bcc3f571aeb3_at_q37g2000vbn.googlegroups.com>

On Jan 5, 1:48 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On Jan 5, 12:24 pm, zigzag..._at_yahoo.com wrote:
>
> > A third party application is using JDBC URL to connect to Oracle,
>
> > jdbc:oracle:thin:scott/tiger_at_MyOracleHost:1521:MyDB
>
> > For some reason in third party application, same URL has to be used
> > for
> > Dev, QA and Production. I know using /etc/hosts (Or its equivalent in
> > Windows), I can point MyOracleHost to different hosts. But, is there
> > any way to point  MyDB to different database names.
>
> Can you change (for everyone, since they all have to match) the URL to
> jdbc:oracle:thin:scott/tiger_at_MyOracleHost:1521/MyDB?
>
> This would point to a service rather than an instance.
>
> If so, the service that is serviced by the listener on each node could
> point to an instance on that server.
>
> HTH,
>
> Steve

Steve:

Thanks. Somehow, my apllication does not like it.

Prem Received on Mon Jan 05 2009 - 17:12:42 CST