Establishing Connectivity: Oracle Net Service Names

Create a net service name for use by an Agentry application.

Prerequisites

Verify the proper version of the Oracle client software is installed on the intended host system for the Agentry application.
Gather the following information:
- Database service name – the service name or global database name of the database to which the Agentry application is to connect.
- Communication protocol – the protocol to use for communication between the Agentry Server and the Oracle database. May be one of: TCP, TCPS, ICP, or NMP.
- Database host network name – the network name of the host system for the Oracle database server. This is needed only if the communications protocol used is TCP, TCPS, or NMP.
- Database port number – the port number used to communicate with the Oracle database server. This value is only needed if the TCP or TCPS communications protocol is used.
- Pipe name – the name of the pipe for the database service. This value is only needed if the NMP communications protocol is used.
- Agentry application login and password – the login and password to the database that used by the Agentry application to connect with the database server.
- Desired net service name – the Net Service Name by which the connection created is identified on the Agentry application’s host system.

Task

This task uses the Net Configuration Assistant that is included in version 9i of the Oracle client software. If you are not familiar with this tool, review the Oracle documentation for the Net Configuration Assistant and for creating net service names before proceeding.

Start the Oracle Net Configuration Assistant, select Local Net Service Name configuration, and click Next.
Select Add and click Next.
Select the Oracle database version used in your environment, then click Next..
Enter the database service name to which the Agentry application will connect, then click Next..
Select the appropriate protocol for your environment, then click Next. Click Help for additional information.
Enter protocol-specific configuration information:
- TCP or TCPS – the database host computer name for the database to connect to. You must also enter the database port number by entering its value or choosing to use the default value provided.
- IPC – the IPC key value for the local Oracle database service.
- NMP – the database host computer name. You must also enter the database pipe name or choose the default pipe name provided.
Click Next.
Test the new net service name to verify all configuration options are correct and to validate the login and password used by the Agentry application application. Follow the instructions on the next screen. As an added test, change the login information to use the login and password intended for use by the Agentry application. When you finish testing, click Next.
Enter the Net Service Name by which this connection is identified on the system. Make a note of this name, as you will need it to configure the Agentry application to connect to the target database.

Click Next.
Select Yes to add another service name. Select No to advance the wizard to the final screen.

Click Next, then Finish to close the wizard.

An Oracle net service name has now been created on the host system on which the Agentry application will be installed. The server uses the net service name to connect to the database with which it will synchronize data for the mobile application.