|
|
|
|
Re: SERVICE NAME vs NET SERVICE NAME [message #569410 is a reply to message #569400] |
Thu, 25 October 2012 13:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/8680f113ef843bf061ec37f0e4231112?s=64&d=mm&r=g) |
thiyagusham
Messages: 112 Registered: April 2012 Location: Chennai
|
Senior Member |
|
|
@ John;
Really i can't understand that answer.
drprod =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbtest3.)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = drprod1)
)
)
drstaby =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbtest3.)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = drstby1)
)
)
** this is my tns file entries **
IN PRIMARY INIT.ORA
FAL_CLIENT='whichone' (drprod , drprod1)
FAL_Server ='whichone' (drstby , drstby1)
Hope this helps to understand my question.
[Updated on: Thu, 25 October 2012 13:09] Report message to a moderator
|
|
|
Re: SERVICE NAME vs NET SERVICE NAME [message #569411 is a reply to message #569410] |
Thu, 25 October 2012 13:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Your tnsnames.ora file configures two tns aliases, they are drprod and drstaby. If the instance reads either the fal_client or fal_server parameter, it needs to find a name that it can resolve with the tnsnames.ora file. So that answers your question.
However, if you insist on using terms that so many people (including you) find confusing, here is their explanation:
The NET SERVICE NAMES are drpord and drstaby. The SERVICE NAMES are drprod1 and drstby1. So a net service name points to a service name. They are certainly not the same thing.
--
Edit: typo
[Updated on: Thu, 25 October 2012 13:23] Report message to a moderator
|
|
|
|
Re: SERVICE NAME vs NET SERVICE NAME [message #569415 is a reply to message #569413] |
Thu, 25 October 2012 14:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/8680f113ef843bf061ec37f0e4231112?s=64&d=mm&r=g) |
thiyagusham
Messages: 112 Registered: April 2012 Location: Chennai
|
Senior Member |
|
|
My primary init.ora
>> As per your explanation I understood as this >>
In primary init.ora'
fal_client=drprod
fal_server=drstby
In stand by init.ora
fal_client=drstaby
fal_server=drprod
>> MAY i know what's the logic behind to enter TNS names alias to FAL_SERVER >>
little confusion abt
>> fal_server is a comma separated list of the TNS aliases for all other database in the configuration. >>
Thanks and Regards
Thiyagusham.G
[Updated on: Thu, 25 October 2012 14:04] Report message to a moderator
|
|
|
|