| service_name AND net_service_name [message #405312] |
Wed, 27 May 2009 06:11  |
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
|
Member |
|
|
I am trying to understand the difference between the net_service_name and the service_name. I know this can all be setup with the netca (gui), but I like to understand how this works in the background, and how to do this manually.
In the example there is 1 net_service_name with 2 service_names:
net_service_name=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=...)
(CONNECT_DATA=(SERVICE_NAME=sales.example.com)))
(DESCRIPTION=
(ADDRESS=...)
(CONNECT_DATA=(SERVICE_NAME=sales2.us.example.com))))
Is this just a way of using multipathing for the same connection ?
I have read lots of documentation but the basic oracle terminology still confuses me. I am still trying to create a listener.ora and a tnsnames.ora manually, and understand the individual components of it.
If I can give an example of one of my servers:
listener.ora:
-------------
listener.ora
# listener.ora Network Configuration File: /opt/oracle/database/10gR2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LOCAL_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mxgendb.caretech.co.za)(PORT = 1521))
)
)
tnsnames.ora:
-------------
LOCAL_LISTENER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mxgendb)(PORT = 1521))
)
)
ORATEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mxgendb)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oratest.mxgroup.co.za)
)
)
Questions:
----------
Why is LOCAL_LISTENER repeated in the tnsnames.ora ?
Why use SERVICE_NAME in the tnsnames.ora, and not SID ?
Is a net_service_name the same as a connect descriptor ?
|
|
|
|
|
|
| Re: service_name AND net_service_name [message #405319 is a reply to message #405312] |
Wed, 27 May 2009 06:29  |
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
|
Member |
|
|
Thanks. Yes, I have this guide. I will just have to study it in detail and make my own notes to understand every part of it.
I can't be sent on any training and is basically self taught in Oracle. The terminology sometimes confuses me. I'll just have to take my time and study this until I understand every part (word).
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
