(wrong string) – is they a way to provide indirection for db name?
From: ddf <oratune_at_msn.com>
Date: Mon, 5 Jan 2009 09:35:48 -0800 (PST)
Message-ID: <25cae9a8-dfab-4748-93c0-bd7a38a20bcb_at_v13g2000vbb.googlegroups.com>
On Jan 5, 11:24 am, 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.
Date: Mon, 5 Jan 2009 09:35:48 -0800 (PST)
Message-ID: <25cae9a8-dfab-4748-93c0-bd7a38a20bcb_at_v13g2000vbb.googlegroups.com>
On Jan 5, 11:24 am, 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.
No, as that is the SID of the instance/database for the connection; it's not a TNS alias.
David Fitzjarrell Received on Mon Jan 05 2009 - 11:35:48 CST