Home » RDBMS Server » Networking and Gateways » service_name AND net_service_name (10g, sles 9)
service_name AND net_service_name [message #405312] Wed, 27 May 2009 06:11 Go to next message
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 #405314 is a reply to message #405312] Wed, 27 May 2009 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59292
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Net Services Reference

Regards
Michel
Re: service_name AND net_service_name [message #405319 is a reply to message #405312] Wed, 27 May 2009 06:29 Go to previous message
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
Previous Topic: ORA-12519
Next Topic: Urgence,Issue about transparent gateway to MSSQLServer
Goto Forum:
  


Current Time: Thu Oct 02 00:45:24 CDT 2014

Total time taken to generate the page: 0.08564 seconds