This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Feb 28, 2013 2:44 PM by 972355 RSS

Oracle  files for n/w configuration. (sqlnet.ora)

972355 Newbie
Currently Being Moderated
Good Morning to all;

I read oracle documents. It is saying

In most basic form , Oracle uses three files for n/w configuration. They are

sqlnet.ora , tnsnames.ora ,listener.ora

When using remote connection we are using listener.ora and tnsnmes.ora file.

Is this only for windows ?

SQLnet.ora : What is the purpos eof sqlnet.ora. in *NIX  flavors ?

Thanks in advance ..
  • 1. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    vlethakula Expert
    Currently Being Moderated
    listener.ora----> on server side, fo rlistener set up
    tnsnames.ora----->On client side, which contains the address to make remote connection(hostname,listener port)
    sqlnet.ora------>The sqlnet.ora is a text file that contains basic configuration details used by SQL*Net.
  • 2. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    Justin Cave Oracle ACE
    Currently Being Moderated
    969352 wrote:
    When using remote connection we are using listener.ora and tnsnmes.ora file.
    First, why do you believe that? In general, the client relies on the sqlnet.ora file and, if you are using local naming, the tnsnames.ora file (it is entirely possible to connect to a remote database without using a tnsnames.ora file). The listener process on the server may use the listener.ora file to define the services that it listens for (it is also possible for the database to register itself with the listener)
    Is this only for windows ?
    Is what only for windows?
    SQLnet.ora : What is the purpos eof sqlnet.ora. in *NIX  flavors ?
    The sqlnet.ora file has the same purpose on Windows and Unix clients. It tells Oracle how to resolve TNS names (i.e. whether you are using local naming and thus a tnsnames.ora file or whether you rely on Oracle Internet Directory or EZConnect or an old Oracle Names server). It potentially tells Oracle what the default domain is which affects how entries in the tnsnames.ora file are resolved.

    Justin
  • 3. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    Good Morning to all;

    I read oracle documents. It is saying

    In most basic form , Oracle uses three files for n/w configuration. They are

    sqlnet.ora , tnsnames.ora ,listener.ora

    When using remote connection we are using listener.ora and tnsnmes.ora file.

    Is this only for windows ?

    SQLnet.ora : What is the purpos eof sqlnet.ora. in *NIX  flavors ?

    Thanks in advance ..
    1) listener.ora file is server side file only & optional for V10+
    2) tnsnames.ora is client side file & optional (not needed with EZCONNECT)
    3) sqlnet.ora is optional & either server or client side.

    when all else fails Read The Fine Manual

    http://docs.oracle.com/cd/E11882_01/network.112/e10836/toc.htm
  • 4. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    TSharma-Oracle Guru
    Currently Being Moderated
    Listener.ora,sqlnet.ora and tnsnames.ora are for all the paltforms NOT just windows..

    The sqlnet.ora file is the profile configuration file. It resides on the client machines and the database server. Profiles are stored and implemented using this file. The database server can be configured with access control parameters in the sqlnet.ora file. These parameters specify whether clients are allowed or denied access based on the protocol.
    By default, the sqlnet.ora file is located in the ORACLE_HOME/network/admin directory. The sqlnet.ora file can also be stored in the directory specified by the TNS_ADMIN environment variable.
    sqlnet.ora Profile Parameters

    For sqlnet.ora Please read:
    http://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm

    For tnsnames.ora , please read
    http://docs.oracle.com/cd/E11882_01/network.112/e10835/tnsnames.htm

    For listener.ora, please read
    http://docs.oracle.com/cd/E11882_01/network.112/e10835/listener.htm
  • 5. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    972355 Newbie
    Currently Being Moderated
    My question was answered.

    Thanks to all I am reading given links. I have little doubts and i will come back .

    Thanks.
  • 6. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    972355 Newbie
    Currently Being Moderated
    Hello to all;

    I read given links specially ('sqlnet.ora'). Thanks for given link.

    It contains 'n' no  of  parameters for   Net8  profile.
    Each parameters are defining different kind of process ( send_buffer , receive buffer , NAMES.DEFAULT_DOMAIN ) etc ..

    when i am connecting remote database , i will issue following command :

    sql> scott/tiger@xxxxxxxxxxx

    i am getting confused with domain_name  vs net service_name from given link.

    http://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#CIHJDJHD













    * Is it (sqlnet.ora) related to Oracle Web logic team ? (or) Development/Production DBA's ? *
  • 7. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    972355 Newbie
    Currently Being Moderated
    My detailed clear question is

    Any big difference between net service_name and domain_name ?

    Thnaks for well support.
  • 8. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    Justin Cave Oracle ACE
    Currently Being Moderated
    969352 wrote:
    i am getting confused with domain_name  vs net service_name from given link.

    http://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#CIHJDJHD
    I don't see any parameters called domain_name or service_name when I search the page on this link. Perhaps you mean the sqlnet.default_domain? And perhaps you're talking about the service name from a TNS alias? If so, given that they are parameters in two completely different files, I'm not sure what the confusion is.
    * Is it (sqlnet.ora) related to Oracle Web logic team ? (or) Development/Production DBA's ? *
    I'm not sure where Weblogic is coming in to the picture. The sqlnet.ora and/or tnsnames.ora files, if they are used, are used by client processes. It is possible that in a three-tier environment Weblogic is the client opening connections. It is possible that the Weblogic would use the native Oracle client but it is much more common for Weblogic (or any JEE application server) to use a thin JDBC driver to connect to the database in which case neither the sqlnet.ora nor the tnsnames.ora file would be used.

    Justin
  • 9. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    972355 Newbie
    Currently Being Moderated
    I don't need  listener so i  am using IPC .
    *REF_LINK : https://forums.oracle.com/forums/message.jspa?messageID=10872826#10872826

    - above link also my own thread for DB LINK.


    mydb
    (DESCRIPTION=
    (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=TPC) ( HOST=myserver) (PORT=1521)
    )
    (CONNECT_DATA =
    (SERVICE_NAME=orgmydb)
    (SERVER_NAME=DEDICATED)
    )
    )


    my  tns alias name is     :  mydb.
    my net service name    :  orgmydb.


    when i am connecting my db , i will issue : SQL> scott/tiger@orgmydb

    i am using net service name only with username/password.
    i will not issue domain name. sqlnet.default_domain.

    when reading this link. i am getting bit confused.

    http://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#CIHJDJHD

    Thanks ..
  • 10. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    Justin Cave Oracle ACE
    Currently Being Moderated
    Sorry, I don't understand what you are asking...

    First, you state that you are using IPC and reference a thread talking about TCP vs. IPC. I don't see how that has anything to do with the discussion we're having here.

    Then you post a TNS alias from a tnsnames.ora file (I assume that your actual entry doesn't have the syntax errors that the one you posted does-- for example, there is no = after mydb). This TNS alias is using TCP, however. So that conflicts with your statement that you're trying to use IPC.

    Then you talk about how you'll connect via SQL*Plus and say that you're confused by the information in the documentation. But you don't tell us what, specifically, you are confused about. I don't see a question here.

    Justin
  • 11. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    972355 Newbie
    Currently Being Moderated
    LISTENER.ORA TNSNAMES.ORA

    I will GOOGLE about service_name/net_service_name/tns_alias_name/domain_name. Then
    i will come tomorrow perfectly . Sorry for confusing yourself and others including myself also.

    Sure i will come back. Thanks ..
  • 12. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    EdStevens Guru
    Currently Being Moderated
    969352 wrote:
    LISTENER.ORA TNSNAMES.ORA

    I will GOOGLE about service_name/net_service_name/tns_alias_name/domain_name. Then
    i will come tomorrow perfectly . Sorry for confusing yourself and others including myself also.

    Sure i will come back. Thanks ..
    At the risk of sounding self-serving, many have found the following to be helpful with the very confusion you seem to be having

    see: [url http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] Help! I can’t connect to my database
    see: [url http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/] Help! I can’t connect to my database (part duex) 
  • 13. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    972355 Newbie
    Currently Being Moderated
    My confusions here only with names and not about the connections

    I referred many oracle documents.

    ORGDB =
    (DESCRIPTION =
    (ADDRESS_LIST=
    (ADDRESS = (PROTOCOL = TCP) (HOST=MYSERVER)
    ( PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER=DEDICATED)
    (SERVICE_NAME =orcl.orgdb.com)
    )
    )

    am i right ?

    TNS alias is ORGDB
    SERVICE_NAME is : orcl.orgdb.com [ should be match with global db_name]
    net_service_name = TNS alias name [ if it is error  , please post right answer]

    Can anyone post clearly ?

    Please Note :  My confusions are net_service_name , service_name , domain_name
    Oracle documents 10g  saying differently , 11g saying differently .. what i know ....... ?
  • 14. Re: Oracle  files for n/w configuration. (sqlnet.ora)
    EdStevens Guru
    Currently Being Moderated
    969352 wrote:
    My confusions here only with names and not about the connections

    I referred many oracle documents.

    ORGDB =
    (DESCRIPTION =
    (ADDRESS_LIST=
    (ADDRESS = (PROTOCOL = TCP) (HOST=MYSERVER)
    ( PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER=DEDICATED)
    (SERVICE_NAME =orcl.orgdb.com)
    )
    )

    am i right ?

    TNS alias is ORGDB
    SERVICE_NAME is : orcl.orgdb.com [ should be match with global db_name]
    net_service_name = TNS alias name [ if it is error  , please post right answer]

    Can anyone post clearly ?

    Please Note :  My confusions are net_service_name , service_name , domain_name
    Oracle documents 10g  saying differently , 11g saying differently .. what i know ....... ?
    You know, putting entire sentences and paragraphs in bold really comes off looking like shouting, much the same as USING ALL CAPS!!! (see what I mean?)

    I'm not sure what your specific references are when you say the documents are 'saying differently', but I think the best description/definition of 'net service name' is found in the glossary of the Installation Guide(s). To quote:
    ======================================================================
    net service name

    A simple name for a service that resolves to a connect descriptor. Users initiate a connect request by passing a user name and password along with a net service name in a connect string for the service to which they want to connect:

    SQL> CONNECT user_name
    Enter password: password
    SQL> @net_service_name

    Depending on your needs, net service names can be stored in a variety of places, including:

    Local configuration file, tnsnames.ora, on each client

    Directory server

    External naming service, such as Network Information Service (NIS) or Cell Directory Service (CDS)
    ======================================================================

    So in your example from your tnsnames.ora, the net service name is 'ORGDB'.
    The service name is obviously "orcl.orgdb.com"
    "Domain Name" is a standard networking term.

    You might get more insight into these specific questions at [url http://edstevensdba.wordpress.com/2011/07/30/exploring-the-local_listener-parameter/] exploring-the-local_listener-parameter 
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points