Re: Need two databases same name, same cluster, different versions

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 15 Mar 2016 14:29:29 +0000
Message-ID: <CABe10saOhAmQ7=SDLn2umxVLgQvEozKssdn=1pXv-0s8gZq0cg_at_mail.gmail.com>

Oh that, seen that loads of times :(, also hostname and port. DBNAME I have never seen :).

On Tue, Mar 15, 2016 at 2:00 PM, Norman Dunbar <oracle_at_dunbar-it.co.uk> wrote:

> On 14/03/16 20:44, Niall Litchfield wrote:
>
>> Given that the database name is DEVDB it seems hard to imagine even
>> creatively idiotic developers thinking that that should be hardcoded
>>
>
> how about this for creativity then, the tnsnames alias, username and
> password were all hard coded in one application I used to have to maintain.
> Third party vendor, translated from SQL Server (I think, but don't quote
> me!) to Oracle pretty much verbatim. We eventually got it changed as we had
> a regular password change exercise on all databases for our security
> standards.
>
> Oh, and "you need to grant DBA to the application user account (the hard
> coded one) to make it work". That requirement went away as well!
>
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> 27a Lidget Hill
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7LG
>
> Company Number: 05132767
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 15 2016 - 15:29:29 CET