Re: Database Access Details - How do you manage the information ?

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Sat, 21 May 2011 13:30:39 -0300
Message-ID: <BANLkTimtqz4Nh98W83Csm62g8EjqF-aq4A_at_mail.gmail.com>

Back when I worked in service delivery we had an Apex application developed in house to manage all this (except for personal accounts). Users would log in to each server using a personal account and then use sudo to connect to the oracle software owner. Personally I used to keep a neat password database using keepass (still do). When we implemented GC we also created a gc_admin user and we saved the credentials for everyone using emcli, it was a but of an ugly hack, but it was easy for everyone to just use EM :-P

Cheers.
Alan.-

On Sat, May 21, 2011 at 10:43 AM, Michael Dinh <mdinh_at_xifin.com> wrote:

> What about using just the standard functionality of Grid Control???
>
> system password are the same for all environment and application password
> are in text file on server with enforce permission.
>
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On
> Behalf Of Subodh Deshpande [deshpande.subodh_at_gmail.com]
> Sent: Saturday, May 21, 2011 5:02 AM
> To: sreejithsna_at_gmail.com
> Cc: oracle-l_at_freelists.org
> Subject: Re: Database Access Details - How do you manage the information ?
>
> I think it all depends on customer supplied info sla your team size and
> procedures and practices followed
>
> On 21 May 2011 13:55, "sreejith s" <sreejithsna_at_gmail.com<mailto:
> sreejithsna_at_gmail.com>> wrote:
>
> Hi Friends,
>
> I hope we all are managing small -medium - large number of databases which
> runs in N servers. Say , If I have 40 databases which runs in 40 + servers,
> How do you manage the credentials / environment details. Do you use an excel
> sheet which stores details like client name,hostname,RAC/Single , os user
> name/password , sys password,SYSASM password, application schemas &
> passwords, what purpose it is is used for,Standby is there / not, CDC
> environment,Staging,Testing etc etc. How do you manage these information. Is
> there a standard tool / some repository which can hold all these information
> so that it can be shared to the members of the DBA team ( Any Free tool ? )
>
>
> Just curious to know how all manages the details of their data centre DB
> environments.Appreciate if you can share any template / suggestions from
> your experience
>
> Cheers,
> SSN
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Sat May 21 2011 - 11:30:39 CDT