
Configuration
Before proceeding with Oracle Network Products configuration, ensure the necessary products have been installed on the server and each of the clients.
To verify proper installation:
- Start the Oracle Installer:
The Software Asset Manager dialog box appears with the currently installed products listed in the right-hand list box:
- Verify the following products are in the Products installed on ORACLE_HOME list box:
- Choose the Exit button to exit the Oracle Installer.
A dialog box appears, asking you if you want exit the Oracle Installer.
- Choose Yes.
The Oracle Installer exits.
- Continue to the next section, "Ways to Configure a Network."
Ways to Configure a Network
Configuring your network can be viewed in two ways:
See section, "Choosing a Configuration Tool," below for further information on which configuration tool works best with your chosen configuration method.
Choosing a configuration tool depends upon whether or not your network uses Oracle Names.
SQL*Net Easy Configuration makes configuration quick and simple by automatically creating configuration files needed by the networking products. Use SQL*Net Easy Configuration if:
Oracle Network Manager
Oracle Network Manager includes a graphical user interface that enables you to view the network in a:
Oracle Network Manager enables you to configure more complex features, such as ANO.
SQL*Net Easy Configuration is ideal for smaller networks, while Oracle Network Manager is suitable for larger, more complex networks. Consider your network layout when selecting a configuration tool. This decision is important because once you select a tool and configure with it, you cannot use the other tool.
Review the guidelines below before choosing either SQL*Net Easy Configuration or Oracle Network Manager:
Additionally, note which Oracle Protocol Adapters can be configured with SQL*Net Easy Configuration or Oracle Network Manager:
Oracle Network Products use the following configuration files:
Below is a description of the configuration files:
For samples and detailed descriptions of these files, see "Configuration Files."
A description of how the files are created is described below:
After you have installed the necessary Oracle network products, use SQL*Net Easy Configuration or Oracle Network Manager to create the TNSNAMES.ORA and regenerate SQLNET.ORA configuration files.
This section describes how to use both these products.
SQL*Net Easy Configuration must be used on the server and each of the clients to create the SQLNET.ORA and TNSNAMES.ORA configuration files.
To create the configuration files:
- From the server or client machine, start the SQL*Net Easy Configuration application:
The SQL*Net Easy Configuration dialog box appears:
- Select Add Database Alias and choose OK.
The Choose Database Alias dialog box appears:

- Enter a database alias name to identify the database to access and choose OK. The alias can be any name you choose.
The Choose Protocol dialog box appears if more than one Oracle Protocol Adapter resides in your ORACLE_HOME directory.
.
Continue to Step 4.
If you installed only one protocol adapter, the dialog box appropriate for your protocol adapter appears, as shown in Step 4. Skip to Step 5.
- Select the protocol to use for your database alias name and choose OK.
The dialog box appropriate for your protocol adapter appears; the example here TCP/IP is assumed:

- Enter the appropriate information for your chosen protocol adapter in the first field and enter the name for the System ID (SID) of the database to which you want to connect in the Database Instance field. The database instance is typically ORCL.
- Choose OK.
The Confirm Adding Database Alias dialog box appears:

- Choose Yes to confirm.
The SQL*Net Easy Configuration dialog box re-appears.
The configuration files are created in the ORACLE_HOME\NETWORK\ADMIN directory.
The table below describes the results of installing SQL*Net Server and Client and adding a database alias with SQL*Net Easy Configuration:
- Select Exit SQL*Net Easy Configuration and choose OK.
- Continue to "Testing the Configuration on the Server" in this chapter.
Using Other SQL*Net Easy Configuration Features
This section describes SQL*Net Easy Configuration's other features that allow you to:
Modifying a Database Alias
- From the server or client machine, start the SQL*Net Easy Configuration application:
The SQL*Net Easy Configuration dialog box appears
- Select Modify Database Alias and choose OK.
The Modify Database Alias dialog box appears with the list of database aliases (if any).
- Select the database alias to modify and choose OK.
The Choose Protocol dialog box appears if you installed more than one Oracle protocol adapter. If not, the Enter Modification Information dialog box appears and you must go to Step 5.
- Select the protocol to use for your database alias name and choose OK.
The Enter Modification Information dialog box appears.
- Accept the database alias or enter the appropriate database alias in the Database Alias field that corresponds to one of the following:
- Accept the database instance name or enter the SID of the database in the Database Instance field and choose OK.
The Confirm Modifying Database Alias dialog box appears.
- Choose Yes to modify the Database Alias.
The configuration files for your machine are modified with your edits.
The SQL*Net Easy Configuration dialog box re-appears.
- Select Exit SQL*Net Easy Configuration and choose OK to exit from SQL*Net Easy Configuration.
Deleting a Database Alias
- From the server or client machine, start the SQL*Net Easy Configuration application:
- Select Delete Database Alias from the SQL*Net Easy Configuration dialog box and choose OK.
The Delete Database Alias dialog box appears with the list of database aliases.
- Select the Database Alias to delete and choose OK.
The Confirm Deleting Database Alias dialog box appears with the configuration information for that Database Alias.
- Select Yes to delete that Database Alias.
The database alias is deleted from the configuration files for the machine you are on.
The SQL*Net Easy Configuration dialog box re-appears.
- Select Exit SQL*Net Easy Configuration and choose OK to exit from SQL*Net Easy Configuration.
Viewing Configuration Information
- From the server or client machine, start the SQL*Net Easy Configuration application:
- Select View Configuration Information from the SQL*Net Easy Configuration dialog box and choose OK.
- The Choose Database Alias dialog appears with a list of databases.
- Select the database alias to view and choose OK.
The Configuration Information dialog box appears with the configuration data for that database alias.
- View the information and choose OK.
The SQL*Net Easy Configuration dialog box re-appears.
- Select Exit SQL*Net Easy Configuration and choose OK to exit from SQL*Net Easy Configuration.
Using Oracle Network Manager
This section describes how to use Oracle Network Manager to create the network configuration files.
When using Oracle Network Manager, you:
- Create a network definition.
- Save the network definition to a file or database.
- Generate the network configuration files.
- Distribute the network configuration files to the server and each of the client machines.
Creating Configuration Files
A basic configuration for a TCP/IP network not using Oracle Names is described below.
To use Oracle Network Manager:
- Start Oracle Network Manager from the Oracle for Windows program group or go to ORAWIN\BIN\NETMAN.EXE from File Manager.
The Oracle Network Manager appears with the Open Network Definition dialog box.
- Choose Cancel.
- Choose New from the File drop-down menu in the Oracle Network Manager menu bar, or choose the New icon from the Command Tool Bar.
You are asked if you want to have a configuration walk-through. If you choose Yes, on-screen instructions appear on how to use Oracle Network Manager.
If you choose No, continue to Step 4.
- Choose the Community icon or choose Community from the Create menu to bring up a property sheet for a new community. Use this property sheet to provide information about the protocol (or network community) the clients and servers share.
In the General page of the Community property sheet:
- a. Enter TCP for name of the community in the Name field.
- b. Choose the TCP/IP protocol from the Protocol drop-down list.
- c. Choose OK to close the property sheet.
TCP.world (the new community) is added to the Treeview.
- Choose the Node icon or choose Node from the Create menu to bring up a property sheet for a new node. Use this property sheet to provide information about the node on which the Oracle server is installed.
In the Node property sheet:
- a. Enter the name of your Windows NT server in the Name field. If you are unsure of the name of your computer, go to the Control Panel and choose the Network icon. It displays a Network dialog that displays the name of your computer.
- b. Select User Defined for the NT operating system from the Type drop-down list.
- c. Choose the Communities tab, then choose the TCP.world community and choose << Add to add it the Selected list.
- d. Click OK to close the page and place the node on the Treeview community.
- Choose the listener icon or choose Listener from the Create menu to bring up a property sheet for a new listener. Use this property sheet to provide information about the listener for the Oracle7 server.
In the Listener property sheet:
- a. The default name LISTENER appears; you do not need to change it unless there is more than one listener for the server. If there are multiple listeners for a server, each listener must have a unique name.
- b. If only one node has been defined, it appears in the Node field; you do not need to change it.
- c. If more than one has been defined, select the down arrow and select the desired node from the drop-down list box that appears.
- d. Choose the Addresses tab and choose Create. A Service Address property sheet appears in which to define the protocol-specific address of the listener, but do not make any changes, unless you want to change the host to the IP address of the Windows NT or the port number from the default.
- e. Choose OK to close the Service Address property sheet. A short form of the new address displays on the Addresses page.
- f. Choose OK to exit the Listener property sheet.
- Choose the Database icon or choose Database from the Create menu to bring up a property sheet for an Oracle7 database.
In the Oracle Database property sheet:
- a. Enter the name of the database you want to use in the Name field. This is going to be your SQL*Net connect string. In most cases you use your SID name if you have multiple SIDs on your database, or your computer name for systems that have one database name.
- b. Enter the name of the database in the SID field. The default database name is ORCL.
- c. Choose OK to exit from the Oracle Database property sheet.
- Choose Validate from the File menu of the Oracle Network Manager window to verify that the information you entered is consistent and complete.
- Save the data you have entered into a network definition file by selecting Save from the File menu.
The Save Network Definition dialog box displays the option to save the definition to the file system as a default choice.
- a. Choose OK. The Save As dialog appears, prompting you for a file name.
- b. Enter any name (this example uses GEN) and choose OK.
- Choose Generate from the File menu or choose the Generate icon from the Command Tool Bar to create the configuration files for your network.
- a. From the Export Network Definition dialog box that appears, choose File System. The Select a directory dialog box appears.
- b. Select the ADMIN directory to save the network configuration files to C:\ORAWIN\NETWORK\ADMIN and choose OK.
The configuration files are created.
- Choose Exit from the File menu.
Results of Oracle Network Manager
After creating the configuration files with Oracle Network Manager, the C:\ORAWIN\NETWORK\ADMIN\GEN directory contains two subdirectories:
The following configuration files exist where host_name is the name of the Oracle7 Server that you entered in Step 5.a.:
The generated server configuration files need to distributed to ORACLE_HOME\NETWORK\ADMIN on the server, and the client configuration files need to distributed to \ORACLE_HOME\NETWORK\ADMIN on all clients.
See Chapter 6, "Distributing the Configuration Files," in the Oracle Network Manager Administrator's Guide for complete information on the various distribution methods, including FTP and NETFETCH.
SQL*Net requires minimal configuration (TCP/IP, SPX and Named Pipes networks only) through Oracle Names. SQL*Net minimizes configuration by having:
Oracle Names Server configuration does not require a TNSNAMES.ORA on the clients. Additionally, if the DDO is used, SQLNET.ORA is not required on the clients.
Choosing Whether to Use Oracle Names and the Dynamic Discovery Option
Oracle Names contains an option that provides dynamic registration of servers with well-known Names Servers on the network and automatic replication of data between Names Servers. If you use Oracle Names to provide a naming service for your network, you must decide whether to use the DDO.
If you choose to use the DDO in your network, you do not have to use Oracle Network Manager to create configuration files. If you are using SQL*Net for the first time, and are willing to accept all default parameters, with the Dynamic Discovery Option, the only configuration file needed is a LISTENER.ORA for each listener. That file is created as part of the installation process.
The DDO in Oracle Names 2.0 is not for every network. There are several factors o consider before using DDO on your network.
To configure an Oracle Names Server:
- Ensure the listener is not running. Enter:
LSNRCTL
LSNRCTL>STATUS [listener_name]
where listener_name is the name of the listener defined in the LISTENER.ORA file. It is not necessary to identify the listener if you are using the default listener, named LISTENER.
If the STATUS command indicates the listener is running, continue to Step 2. If the listener is not running, skip to Step 3.
- Stop the listener. Enter:
LSNRCTL>SET PASSWORD password
LSNRCTL>STOP [listener_name]
SET PASSWORD is only required if the password is set in the LISTENER.ORA file. The password defaults to ORACLE.
- Exit from the LSNRCTL utility. Enter:
LSNRCTL>QUIT
- Ensure your network administrator has configured an alias for the installed Oracle Names Server in the Domain Name Server (DNS) with one of the following well-known names:
If you are using the DDO, skip to Step 6. If you are not using the DDO, continue to Step 5.
- Use Oracle Network Manager to:
- a. Create a network definition using Network Manager property sheets.
- b. Generate network component configuration files using the GENERATE command in Oracle Network Manager.
- c. Distribute the configuration files to the appropriate nodes on the network.
Configuration is complete. Skip to Step 8.
- On every client and the server, edit the NAMES.DIRECTORY_PATH parameter so it points to ONAMES in the SQLNET.ORA file:
NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES)
- On every client and server, ensure the following line is in the SQLNET.ORA file:
AUTOMATIC_IPC = OFF
- Comment out all ADDRESSes (including IPC) that you are not using in the LISTENER.ORA. For example:
(ADDRESS_LIST =
# (ADDRESS=
# (PROTOCOL= IPC)
# (KEY= oracle.world)
# )
# (ADDRESS=
# (PROTOCOL= IPC)
# (KEY= ORCL)
# )
# (ADDRESS=
# (COMMUNITY= NMP.world)
# (PROTOCOL= NMP)
# (SERVER= hr-PC)
# (PIPE= ORAPIPE)
# )
(ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Port= 1521)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Port= 1526)
)
)
- Add the GLOBAL_DBNAME and USE_PLUG_AND_PLAY_listener_name (for DDO) parameters to the LISTENER.ORA file on the server: using a text editor:
SID_LIST_listener_name=
(SID_LIST =
(SID_DESC =
(SID_NAME = SID)
(GLOBAL_DBNAME = global_dbname.domain)
)
)
USE_PLUG_AND_PLAY_listener_name = ON
USE_PLUG_AND_PLAY indicates to use the DDO and GLOBAL_DBNAME identifies the globally unique name for the database instance. Think of it as a database alias.
- Create and start the OracleNamesService by using the Names Control Utility, NAMESCTL. Enter:
NAMESCTL
NAMESCTL>START
The OracleNamesService is created and configuration is complete.
- Continue to the next section, "Testing the Configuration on the Server."
Testing the Configuration on the Server
Once you have configured the network, test the configuration by performing a loopback test on the server.
This section covers the following:
These instructions are valid for a network with or without an Oracle Names Server.
In order to perform a loopback test, the following must be performed prior to performing a loopback test:
- Starting Oracle Names (if not already started)
- Starting the Listener
Starting Oracle Names
Command Line
To start Oracle Names from the command line:
- Verify whether the Oracle Names Server is running or not running by using the Names Control Utility, NAMESCTL. Enter:
NAMESCTL
NAMESCTL>STATUS
If the STATUS command indicates the Oracle Names Server is running, continue to Step 3. If the Oracle Names Server is not running, continue to Step 2.
- Start the Oracle Names Server. Enter:
NAMESCTL>START
- Exit from the NAMESCTL utility. Enter:
NAMESCTL>QUIT
Control Panel
To start the Oracle Names Server from the Windows NT Control Panel's Services dialog box:
- Choose the Services icon in the Control Panel window.
The Services dialog box appears.
- Look for the OracleNamesService.
A blank in Status column indicates that the service is stopped.
If the service is not running, continue to Step 3. Otherwise, skip to Step 4.
- Select the OracleNameService service and choose Start.
The service is started.
- In the Services dialog box, choose the Close button.
Starting the Listener
For SQL*Net to accept connections on the server, a listener must be started. If you have started an Oracle Names Server, the listener upon startup automatically register the databases specified in the SID_LIST_listener_name section of the LISTENER.ORA file with the well-know Oracle Names Servers.
Command Line To start the listener from the command line:
- Verify whether the listener is running or not running by using the Listener Control Utility, LSNRCTL. Enter:
LSNRCTL
LSNRCTL>STATUS [listener_name]
where listener_name is the name of the listener defined in the LISTENER.ORA file. It is not necessary to identify the listener if you are using the default listener, named LISTENER.
If the STATUS command indicates the listener is running, continue to Step 2. If the listener is not running, skip to Step 3.
- Even if the listener is running, it advised to stop and start it again. To stop the listener, enter:
LSNRCTL>SET PASSWORD password
LSNRCTL>STOP [listener_name]
SET PASSWORD is only required if the password is set in the LISTENER.ORA file. The password defaults to ORACLE.
- Start the listener. Enter:
LSNRCTL>START [listener_name]
- Exit from the LSNRCTL utility. Enter:
LSNRCTL>QUIT
Control Panel
To start the listener from the Windows NT Control Panel's Services dialog box:
- In the Control Panel window, choose the Services icon.
The Services dialog box appears.
- Look for the OracleTNSListener service.
A blank in Status column indicates that the service is stopped.
If the listener is running, continue to Step 3. If the listener is running, skip to Step 4.
- Select the OracleTNSListener service and choose Start
The service is started.
- In the Services dialog box, choose the Close button.
Performing a Loopback Test on the Server
Once your network is configured and a SQL*Net network listener is started on an Oracle8 Server, clients connect to the Oracle8 Server using a SQL*Net service name (or database alias). The service name is mapped to the connect descriptor. Connect descriptors define protocol adapter information for the destination server's address and the system ID (SID) for the destination server.
This section show how to execute:
A loopback uses SQL*Net to go from the server right back to itself. Performing a successful loopback verifies that SQL*Net works on the server.
To execute a loopback using Server Manager:
- Start Server Manager. Enter:
SVRMGR23
The SVRMGR> prompt appears:
- Connect to the database. Enter:
SVRMGR>CONNECT SYSTEM/MANAGER@service_name
or
SVRMGR>CONNECT SYSTEM/MANAGER@global_dbname
The service_name is the database alias you defined earlier with SQL*Net Easy Configuration or the Oracle Network Manager and the global_dbname is the global database name you defined in the LISTENER.ORA for the Oracle Names Server.
Server Manager returns the following message:
You probably do not have to use the full service name. There are two parameters in the SQLNET.ORA file which, if set, automatically adds domains to any connect string you use. These parameters are NAMES.DEFAULT_DOMAIN and NAME.DEFAULT_ZONE.
For example, if your service name in the TNSNAMES.ORA file reads ORACLE.WORLD and the two .DEFAULT parameters are set to WORLD in the SQLNET.ORA file, the command to do a loopback is:
SVRMGR> CONNECT SYSTEM/MANAGER@oracle
The two parameters in SQLNET.ORA add a .WORLD extension to ORACLE, which matches the ORACLE.WORLD defined in the TNSNAMES.ORA file.
- Issue SQL commands.
- When done, enter:
SVRMGR>EXIT
Exiting Server Manager closes the database connection.
- Continue to the section, "Testing the Configuration on the Client."
Loopback with SQL*Plus
To execute a loopback using SQL*Plus :
- Start the SQL*Plus application:
A Log On dialog box appears:
- Enter SYSTEM in the User Name field, MANAGER in the Password field, and the database alias (from the TNSNAMES.ORA file) or the global database name for the Oracle Names Server (from the LISTENER.ORA file) in the Host String field.
- Choose OK.
The Oracle SQL*Plus window appears with a SQL> prompt.
- Issue SQL commands.
- When done, enter:
SQL>EXIT
Exiting SQL*Plus closes the database connection.
- Continue to the next section, "Testing the Configuration on the Client."
Testing the Configuration on the Client
After performing a loopback test, follow the procedures in this section:
Verifying TCP/IP Network Connections
If your are using TCP/IP, follow the instructions below to specify the destination address for TCP/IP and use PING to see if the server is running.
Most TCP/IP transports attempt to use the DNS. DNS is a machine used to translate the host name specified in the TNSNAMES.ORA file into the host internet address (IP). If a Domain Name Server is present on your network and the TCP/IP vendor supports DNS, the host name is successfully translated to the host address. The host IP address can be determined by using the Control Panel's Network utility to access DNS information.
Depending on your vendor, workstation configuration, and network configuration, your TCP/IP software can also use a HOSTS file to map host names to Internet addresses if DNS is not detected or supported.
If DNS and the HOSTS file are unable to resolve the host name during a remote database connection, the following error message appears:
If your network administrator cannot resolve the problem, the solution to this error message is go around DNS and the HOSTS file by modifying the (HOST = server_name)
section of the TNSNAMES.ORA so server_name is changed to the IP address of the server.
The following sections explain how to determine the server's IP address and verify that DNS and the HOSTS file are working correctly.
If you are not using TCP/IP, skip to "Verifying Oracle Database Connections Using TNSPING" in this chapter.
The instructions below explain how to determine the IP address from Windows NT 4.0. The instructions are different on Windows NT 3.51. Please see your operating system documentation for specific DNS information.
To determine the server's TCP/IP internet address:
- In the Control Panel window, choose the Network icon.
The Network window appears.
- Choose the Protocols tab.
The Protocols view appears:

- From the Protocol view, select the TCP/IP Protocol adapter and choose Properties...
The Microsoft TCP/IP Properties dialog box appears with the IP Address view:

- Obtain the IP address and choose Cancel to close the Microsoft TCP/IP Properties dialog box.
- Choose Cancel to close the Network window.
- Continue to the next section, "Using PING."
Using PING
If you are using TCP/IP, PING allows you to determine if DNS or the HOSTS file are correctly set up and your network operating system is functioning correctly.
To use PING:
- From the client, enter:
PING server_name
where server_name is the host name, alias, or Internet address of the server to which you are trying to connect. If your network in functioning correctly, the following message appears:
Reply from server_name: bytes=nn time=nnms
If there is a problem, this message appears:
Request timed out
Or:
Reply from server_name: Destination host unreachable
The following is a partial list of reasons why a host is inaccessible:
If PING returns an error message, ask your network administrator to help you resolve the problem. If the problem is not resolved, and you attempt to make a SQL*Net connection, you may receive one of the following error messages:
- Continue to the next section, "Verifying Oracle Database Connections Using TNSPING."
Verifying Oracle Database Connections Using TNSPING
Use the TNSPNING utility to determine whether or not you can reach the listener service. TNSPING, however, never actually connects with the listener. A socket is never created and opened. TNSPING just checks to make sure a listener is running on the server side.
When you connect to a listener using TNSPING, an estimate of the round trip time in milliseconds appears. If TNSPING fails, a network error message appears without the overhead of a database connection.
To use TNSPING:
From the client, enter:
TNSPING service_name count
where service_name is the database alias (or service name) and count is the number of times the program attempts to reach the server. count is optional.
The output looks like:
TNS Ping Utility for 32-bit Windows: Version 3.0.2.0.0 - Production on 12-DEC-
96 20:20:33
Copyright, 1996(c) Oracle Corporation 1995. All rights reserved.
Attempting to contact
(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=server_name)(Port=1521))
OK (60 msec)
Closing a Database Connection
Closing a database connection involves:
Stopping Oracle Names
Stop the Oracle Names Server (if you are using it) when you have completed database connections.
Command Line
To stop Oracle Names from the command line:
- Stop the Oracle Names Server by using the Names Control Utility, NAMESCTL. Enter:
NAMESCTL
NAMESCTL>STOP
- Exit from the NAMESCTL utility. Enter:
NAMESCTL>QUIT
Control Panel
To stop the Names Server from the Windows NT Control Panel's Services dialog box:
- Choose the Services icon in the Control Panel window.
The Services dialog box appears.
- Look for the OracleNameService service.
- Select the OracleNameService service and choose Stop.
The service is stopped.
- In the Services dialog box, choose the Close button.
Stopping the Listener
Stop the listener when all database connections have completed and the Oracle Names Server has been stopped.
Command Line
To stop the listener from the command line:
- Stop the listener from the Listener Control Utility, LSNRCTL. Enter:,
LSNRCTL
LSNRCTL>SET PASSWORD password
LSNRCTL>STOP [listener_name]
where listener_name is the name of the listener defined in the LISTENER.ORA file. It is not necessary to identify the listener if you are using the default listener, named LISTENER.
SET PASSWORD is only required if the password is set in the LISTENER.ORA file. The password is defaulted to ORACLE.
- Exit from the LSNRCTL utility. Enter:
LSNRCTL>QUIT
Control Panel
To stop the listener from the Windows NT Control Panel's Services dialog box:
- Choose the Services icon in the Control Panel window.
The Services dialog box appears.
- Look for the OracleTNSListener service.
- Select the OracleTNSListener service and choose Stop.
The Services confirmation dialog box confirms it is OK to stop the Service.
- Choose Yes.
The listener is stopped.
- Choose the Close button in the Services dialog box.
 |
Oracle Network Products Getting Started for Windows Platforms |
Contents
|
|
Index |
|
 |
|
 |