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

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


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 - Logical name identify a name service.
HOST= 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.


Default Parameters

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

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