Re: multiple DB's on windoze...
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: greg.loughmiller@xxxxxxxxxxxx
- Date: Fri, 8 Oct 2004 12:09:23 -0400
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@xxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
