Very Computer

by **Sende** » Sun, 31 Dec 1899 09:00:00

Our users have to access 2 databases, one for production and another for
testing. Since the database name and client software path have to be
specified in the windows registry, we provide them with two icons and use
batch file to execute regedit to switch between the two environments.
Recently, auditor request us to disable registry editing (we use windows nt
v4.0 workstation). I like to know is the database switching method we use
the right way to do? If not, what method do you use?

by **I hate Spa** » Sun, 31 Dec 1899 09:00:00

>Our users have to access 2 databases, one for production and another for
>testing. Since the database name and client software path have to be
>specified in the windows registry, we provide them with two icons and use
>batch file to execute regedit to switch between the two environments.
>Recently, auditor request us to disable registry editing (we use windows nt
>v4.0 workstation). I like to know is the database switching method we use
>the right way to do? If not, what method do you use?

Either set the correct parameters in the properties/shortcut of the
desktop icon, or change the users environment parameters

Oracle looks after the settings in

current users environment
all users environment
registry

in that order.

I define the parameters in the shortcut definition.

Hans Erik Busk
Yours Hans Erik Busk

by **Brian Peaslan** » Sun, 31 Dec 1899 09:00:00

If they are using two databases, why don't you just set up two different
entries in their TNSNAMES file? That way, they can connect to both
databases without having to switch anything. This should work in most
situations unless I've missed something in your question.

HTH,
Brian

> Our users have to access 2 databases, one for production and another for
> testing. Since the database name and client software path have to be
> specified in the windows registry, we provide them with two icons and use
> batch file to execute regedit to switch between the two environments.
> Recently, auditor request us to disable registry editing (we use windows nt
> v4.0 workstation). I like to know is the database switching method we use
> the right way to do? If not, what method do you use?

--
========================================
Brian Peasland
Raytheons Systems at
USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my
company!
========================================

by **Chi** » Sun, 31 Dec 1899 09:00:00

Indeed. We are using 5 databases with different SID.
At login you just specify the SID you want. It's not
neccesary to change the registery.

If you hardcoded your SID, so you can't specify it at
startup, than you can change tnsnames.ora.

E.g. if you hardcoded ORCL in your code, change
tnsnames.ora. If in tnsnames.ora ORCL point to DB1 and you
want it to point to DB2, create a batchfile to replace them.

> If they are using two databases, why don't you just
> set up two different
> entries in their TNSNAMES file? That way, they can
> connect to both
> databases without having to switch anything. This
> should work in most
> situations unless I've missed something in your
> question.
> HTH,
> Brian

> > Our users have to access 2 databases, one for
> production and another for
> > testing. Since the database name and client software
> path have to be
> > specified in the windows registry, we provide them
> with two icons and use
> > batch file to execute regedit to switch between the
> two environments.
> > Recently, auditor request us to disable registry
> editing (we use windows nt
> > v4.0 workstation). I like to know is the database
> switching method we use
> > the right way to do? If not, what method do you use?
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================

* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

by **Sende** » Sun, 31 Dec 1899 09:00:00

Thanks. But how about the Developer 2K client path? We need to switch
between production executable and testing executable. As an alternative, is
there a way we can concatinate 2 path so that the system search for
executable from one path and, if not found, search another?

> >Our users have to access 2 databases, one for production and another for
> >testing. Since the database name and client software path have to be
> >specified in the windows registry, we provide them with two icons and use
> >batch file to execute regedit to switch between the two environments.
> >Recently, auditor request us to disable registry editing (we use windows
nt
> >v4.0 workstation). I like to know is the database switching method we use
> >the right way to do? If not, what method do you use?

> Either set the correct parameters in the properties/shortcut of the
> desktop icon, or change the users environment parameters

> Oracle looks after the settings in

> current users environment
> all users environment
> registry

> in that order.

> I define the parameters in the shortcut definition.

> Hans Erik Busk
> Yours Hans Erik Busk

by **I hate Spa** » Sun, 31 Dec 1899 09:00:00

>Thanks. But how about the Developer 2K client path? We need to switch
>between production executable and testing executable. As an alternative, is
>there a way we can concatinate 2 path so that the system search for
>executable from one path and, if not found, search another?

Place to shortcut on the desktop, one for production, one for testing
in the shurtcut/proporties/target box you put the strings

Production:

Testing:

then of course you have to define the proper connection to the two
databases in TNSNAMES.ORA

Yours Hans Erik Busk

Very Computer

switching of database

switching of database

switching of database

switching of database

switching of database

switching of database

switching of database