Using Oracle Net Configuration Assistant to Configure Network Components
Oracle Net Configuration Assistant configures basic network components during installation, including:
Oracle Net Configuration Assistant runs automatically during software installation, as described in the Oracle Database installation guide. It can also be run after installation in standalone mode to configure naming methods, the listener, network service names
in the tnsnames.ora file, and directory server usage.
- Listener names and protocol addresses
- Naming methods the client uses to resolve connect identifiers to connect descriptors
- Net service names in a tnsnames.ora file
- Directory server usage
To start Oracle Net Configuration Assistant do the following:
On Linux and UNIX, run netca from the ORACLE_HOME/bin directory.
On Microsoft Windows, select Programs from the Start menu, and then select
Oracle - HOME_NAME.
Next, select Configuration and Migration Tools, and then Oracle Net Configuration Assistant.
View the Net Assistant
- This is the initial window of the Net Assistant.
We will be creating a new database node. Begin by clicking the Net Service Names folder in the directory tree.
- Click the + button to start creating a new Net Service Name.
- The first page of the Net Service Name screen wizard appears. In this example, type TESTDB as the Net Service Name, then click Enter. Note:
The name does not have to correspond with the SERVICE_NAME of the database. Press the Next button.
- Accept the default protocol of TCP/IP by clicking the Next button.
- Now, enter the name of the host computer on which the database service resides. For this example, type CAROLSPC and click the Next button. Accept the default port number of 1521.
- This page specifies the database instance into which this network node will connect. Since we are defining a node that contains an Oracle8i database, accept the radio button setting for Oracle8i release 8.1.
For this example, type orcl.carol.org in the Service Name box and click the Next button. Accept the default port number of 1521.
- Here you can either continue or you can test the parameters you have specified. The test will try to connect to the database according to the parameters. Click the Test button to run a test.
- As you can see, the test begins immediately, using the standard user name of SCOTT and the password of TIGER. If the target database does not contain this user or the SCOTT user has a different password,
you can specify a different username and password by clicking the Change Login button. Since our test worked, we will not do that. Click the Close button to continue.
- You are now ready to complete this node definition. Click the Finish button to end the wizard.
- The wizard has completed and the new database node is displayed in the Net Assistant window. Click the Advanced button in the right frame.
- This is where you can specify some of the new Net parameters, such as INSTANCE_NAME and MTS_DISPATCHERS (called Handler name in this window).
The Use Dedicated Server check box sets the SRVR=DEDICATED parameter so that a dedicated service is used even if the database is set up as an MTS.
The Use for Heterogeneous Services checkbox sets the HS = OK parameter and sets up this node for non-Oracle database connections. Click the Cancel button to exit this window.
- Now it is time to save the configuration to the tnsnames.ora file. Click the File menu selection.
- Click Save Network Configuration in the sub-menu selection.
- Once saved, you see the main Net Assistant screen again. Your new node has been saved in the tnsnames.ora file.