Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: multiple DB's on windoze...

Re: multiple DB's on windoze...

From: Paul Drake <bdbafh_at_gmail.com>
Date: Fri, 8 Oct 2004 12:09:23 -0400
Message-ID: <910046b404100809095ee1bd6f@mail.gmail.com>


Greg,

I prefer to use different local accounts for each database and for the services to support the database instance (and listeners, etc). Each local account has environment variables set for its database. In this manner, each local account has membership in the local group ORA_%ORACLE_SID%_DBA - which means that it cannot connect to other databases using NTS authentication (no password). This protects you (and other DBAs) from going into the wrong database - quite nice when you have test databases cloned from production.

You can use the "runas" command to switch to that user (su).

For a server where you have a dev, test and prod databases ...

local groups:

ORA_OINSTALL
ORA_DBA (hard-coded in how the oracle binary is compiled)
ORA_DEV_DBA
ORA_TEST_DBA
ORA_PROD_DBA

local accounts:

ora-oinstall
ora-dba
ora-dev-dba
ora-test-dba
ora-prod-dba

ora-oinstall owns the software, and has read/write access to the binaries. ora-dba owns all databases, but is not used regularly.

C:\> runas /user:ora-test-dba cmd
password:

and a new cmd prompt will be spawned under that user's credentials and environment variable settings.

Several posters to this list recommend against using easily guessed account names, so modify these for your own use.

Paul

On Fri, 8 Oct 2004 08:49:27 -0400, Loughmiller, Greg <greg.loughmiller_at_cingular.com> wrote:
> Hey guys,
> I'm venturing into the windoze world from Unix... I am setting up a 9i and
> 10g database on this puppy.. And my question is:
>
> 1. How do I handle setting the different environment variables between
> the instances? (i.e. PATH for example)
>
> Any other "gotchas" that present differences/issues in doing this on
> windoze? I have the Unix stuff covered like the dew in Dixie. But I'm
> walking in the windoze cow pasture, the grass is high, and I just can't
> avoid some of the "mess" yet...
>
> Thanks in advance!
>
> Greg Loughmiller
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 08 2004 - 11:04:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US