Poder
To: Multiple recipients of list ORACLE-L
Sent: Thursday, July 03, 2003 10:49
AM
Subject: Re: service name, sid ..
Hi!
There's actually more:
db_name - identifies database name, has to be the
same what is stated in controlfile (using create database or create
]Sent: Monday, July 07, 2003 3:34
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
service name, sid ..
Tanel,
Thanks for elaborate information , I really liked
it . Still why do u need to provide db name in tnsnames, all one should know is
which instance to connect . Instance know
-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent:
Monday, July 07, 2003 4:00 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: service name, sid .
AK,
You can make it as simple or complicated as you
want. Personally I prefer the KISS principle
The
laughof the day
.
the fecal matter hits the rotary oscillator.
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003 2:00
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
service name, sid ..
AK,
You can make
You're welcome.
You don't have to provide db_name in tnsnames, it's
instance (init.ora) parameter.
Tanel.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 07, 2003 10:34
PM
Subject: Re: service name, sid ..
Tanel
-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent:
Monday, July 07, 2003 4:00 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: service name, sid .
AK,
You can make it as simple or complicated as you
want. Personally I prefer the KISS principle
Hi!
There's actually more:
db_name - identifies database name, has to be the
same what is stated in controlfile (using create database or create
controlfile). You can have several databases with same db_name in one server,
there is no restriction.
SID - When we actually want to open and
AK,
Let me put it this way, from our own
configurations:
Specs.world is an alias(servicename) for
database(instance name/db name) BART3 which resides on host BART in SID
03.
Does that help??
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message-From: AK
Example using Transparent Application Failover (TAF)
If I didn't forget something, here's what it looks like:
XXTP_QUOTE.WORLD =
(DESCRIPTION=
(LOAD_BALANCE=OFF)
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.48)(Port=1527))
I forgot to say: the first listing is the tnsnames.ora on the client(s).
-Original Message-
From: Stephen Lee
Sent: Wednesday, July 02, 2003 3:06 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: service name, sid ..
Example using Transparent Application Failover (TAF
10 matches
Mail list logo