Re: Updating host/database list in dba-studio for multiple workstations

Chris,

There is a file in %ORACLE_HOME%\sysman\dbastudio\admin\ with a *.crd extension. This is the credentials file. It lists all databases to be managed by DBA Studio. The format of the file is:

TNS_ALIAS=CONNECT_ID/ENCRYPTED_PASSWORD/CONNECT_TYPE where CONNECT_TYPE is in NORMAL, SYSOPER, SYSDBA

Note that the TNS_ALIAS would need to resolve (tnsnames.ora, Oracle Names, OID, whatever). Also note that the encrypted password is NOT the same value as the encrypted password in DBA_USERS for that userid.

If you don't mind entering a userid and password, these values can be left as null in the credentials file.

Here is a sample of what you might have in your credentials file:

DATABASE_1=//NORMAL
DATABASE_2=SYSTEM//NORMAL
DATABASE_3=SYS/d80b6a605beaf20ce04d1dc4149c1eaa/SYSDBA

With DATABASE_1, you would be prompted for a userid and password. With DATABASE_2, the userid would be filled in but you would still be prompted for a password.
With DATABASE_3, you would be logged in without prompt. With DATABASE_1 and DATABASE_2, you would not be able to stop and start instances because you would be connected as NORMAL. DATABASE_3 would be connected as SYSDBA, therefore you would have full authority.

Good Luck,
Mike

"chris" <deja_at_sbs-ffm.de> wrote in message news:45a0ec13.0203080248.45fd9ed4_at_posting.google.com...
> I am looking for a way to update the view/list of managed databases
> inside dba-studio w/o adding new db's each time manually on each
> Workstation.
> The idea behind this wish is to edit the list in one central place and
> then deploy it over the network by copying the data to the
> workstations with installed dba-studio with no more actions needed to
> have the actual db's listed.
Received on Fri Mar 08 2002 - 19:25:54 CET