Re: Configuring a new database on netware

From: Walter Dorninger <walter.dorninger_at_aon.at>
Date: 2000/04/26
Message-ID: <39074e8d$0$81422@SSP1NO17.highway.telekom.at>#1/1

Take a look at "tnsnames.ora". It is located in ".../network/admin" or ".../net80/admin". Watch out - there can be more than one tnsadmin.ora on your system. You can specify the env. variable TNS_ADMIN to override the default location.
In a TNSNAMES.ORA File you can specify the "logical" name to use for a bunch of settings how to connect to a Oracle database (Network, Protocol etc. etc.).

Walter

"Matt Ward" <mward_at_lchb.com> wrote in message news:3904C86A.A8523BAC_at_lchb.com...
> I am having problems being able to connect to two different oracle
> databases. My problem is as follows. I have two working complete
> databases, after configuring net8 I am able to connect internally to one
> of them fine, the alias name is 'oranw80' with an sid of 'ORCL'. The
> other database I have given the alias name of 'prod_db' in net8 but I
> cannot figure out how to define its SID, (System Identifier) I am sure
> there must be some configuration file where this is defined but I simply
> can't find any docs on where it is. Help!
>
Received on Wed Apr 26 2000 - 00:00:00 CDT