[Laskey99] Section 5.8. Sample SQL*Net Files

5.8. Sample SQL*Net Files

The following sections containlistings of sample SQL*Net configuration files. For completeinformation on the contents of these files, please refer to theOracle Network Manager Administrator'sGuide or the Net8 Administrator'sGuide. These files may be obtained from the O'Reilly& Associates web site; see the Preface fordetails.

5.8.1.listener.ora

The following file will configure a listener for a single databaseinstance (ORAC) using the TCP/IP protocol:

SQLNET.AUTHENTICATION_SERVICES = (NONE)
USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
  (ADDRESS_LIST =
          (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= ORAC.world)
         )
          (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= ORAC)
         )
          (ADDRESS =
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = 10.10.1.2)
          (Port = 1526)
         )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORAC.world)
      (SID_NAME = ORAC)
      (ORACLE_HOME = /disk01/oracle/product/7.3.4)
      (PRESPAWN_MAX = 10)
      (PRESPAWN_LIST =
        (PRESPAWN_DESC = (PROTOCOL = TCP) (POOL_SIZE = 10) (TIMEOUT = 0))
      )
    )
  )

  

5.8.2.tnsnames.ora

The following file will allow Oracle client machines to access threedatabases on the network: DB1 is accessed using TCP/IP, DB2 isaccessed using SPX/IPX, and DB3 is accessed using the named pipesprotocol:

DB1.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (HOST = Production1)
          (PORT = 1526)
        )
    )
    (CONNECT_DATA = (SID = DB1)
    )
  )
DB2.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = spx.world)
          (PROTOCOL = SPX)
          (SERVICE = Server_lsnr)
        )
    )
    (CONNECT_DATA = (SID = DB2)
    )
  )
DB3.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = nmp.world)
          (PROTOCOL = NMP)
          (SERVER = FinanceServer1)
          (PIPE = ORAPIPE)
        )
    )
    (CONNECT_DATA = (SID = DB3)
    )
  )

  

5.8.3.sqlnet.ora

The following file will configure a client for no logging of SQL*Netevents, and provide default values for domain and zone:

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world

• 
• Create Bookmark (Key: b)Create Bookmark
• Create Note or Tag (Key: t)Create Note or Tag
• Download (Key: d)Download
• Email This Page (Key: e)Email This Page
• PrintPrint

• Html View (Key: h)Html View
• Zoom Out (Key: -)Zoom Out
• Zoom In (Key: +)Zoom In
• Toggle to Full Screen (Key: f)
• Previous (Key: p)Previous
• Next (Key: n)Next

Related Content

Configuring Oracle Net
From: Oracle Essentials, 4th Edition

Oracle Networking Fundamentals
From: Oracle in a Nutshell

Overview of Oracle Net
From: Oracle Database 11g DBA Handbook: Administer a Scalable, Secure Oracle Enterprise Database

Overview of Oracle Net
From: Oracle Database 10g DBA Handbook

Protocol Overview
From: Oracle Distributed Systems

SNMP Support
From: Oracle Distributed Systems

Defining Net Service Names
From: Oracle Net8 Configuration and Troubleshooting

Using the Oracle Net Manager
From: Oracle Database 11g DBA Handbook: Administer a Scalable, Secure Oracle Enterprise Database

Installing and Configuring SQL*Net
From: Oracle Security

Discovery and Client Configuration
From: Oracle Net8 Configuration and Troubleshooting