dcsimg
Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted Aug 20, 2002

Listen Software's How To: Using the Net 8 Assistant

By David Nishimoto

Using the Net 8 Assistant

Using the Net 8 Assistant

Communication Files

Client: sqlnet.ora and tnsnames.ora
Server: listener.ora

Tnsnames.ora contains information necessary to communicate with the server.
Tnsnames.ora contains the following information:

Connector Descriptor

	LOGICAL_NAME001 = (DESCRIPTION=
	          (ADDRESS_LIST=
	             (ADDRESS=
	               (PROTOCOL=TCP)
	               (HOST=10.2.2.2)                      
	               (PORT=1521)
	             )
	          )
	          (CONNECT_DATA=
	            (SID=mySID)
	          )                                               
	        )

LOGICAL_NAME001 - Logical name identify a name service.
HOST=10.2.2.2 or HOST=www.mysite.com - IP address of the host machine.
-> If a DNS server exists, the host name will suffice.
PORT=1521 - Default port which the server's listener is listening.
SID=mySID - System Identification (SID) of the database instance.


Creating a Local Name Client Connection

Step 1: From Net 8 Assistant: From methods, under selected items, make sure TNSNAMES AND HOSTNAME are chosen.

Step 2: Select Edit, Create to generate a network service name. The network service name is associated with a connector descriptor. A Logical Name to the Connector Descriptor is created.

Step 3: Select a Network Protocol. Choose (TCP/IP).

Step 4: Enter the Host Name and Port. The Host name may be a machine name or an IP address. The port is usually 1521 by default. However, the port number may be different depending on the machine/type of the server.

Step 5: Enter in the System ID (SID) of the database for the instance you want to connect to.

Step 6: Test the name service.


sqlnet.ora

Default Parameters

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world

Sqlnet.ora eventually serves the purpose of pointing to an Oracle Name Server.


Back to the LSS "How To" Series Main Page




Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM