Create a Net Service Name for use by an Agentry Server.
- Verify the proper version of the Oracle client software is installed to the intended host system for the Agentry Server.
- Gather the following information:
Database Service Name: The service name or global database name of the database to which the Agentry Server is to connect.
Communications Protocol: The communications protocol to use in communications 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 Server Login and Password: The login and password to the database that used by the Agentry Server to connect with the database server.
Desired Net Service Name: The Net Service Name by which the connection created is identified by on the Agentry Server’s host system.
When the Agentry Server connects with an Oracle database, the host system must have the Oracle client software installed. Using this software, an Oracle Net Service Name is created for the target Oracle database with which the Agentry Server synchronizes data. This is accomplished using the Net Configuration Assistant within the Oracle client software package.
The following procedure uses the Net Configuration Assistant as provided by version 9i of the Oracle client software. Those not familiar with this tool should review the Oracle documentation for the Net Configuration Assistant and for creating Net Service Names before proceeding.
- Start the Oracle Net Configuration Assistant and
select Local Net Service Name configuration.
Click the [Next] button to continue.
- Select Add to create the Net Service Name.
Click the [Next] button to continue.
- Select the Oracle database version used in your environment.
Click the [Next] button to continue.
- Enter the Database Service Name to which the Agentry
Server will
connect.
Click the [Next] button to continue.
- Select the appropriate communications protocol for your
environment from those available in Oracle. Click the [Help] button
for further information on these protocols.
Click the [Next] button to continue.
- Test the new Net Service Name to verify all configuration
options are correct and to validate the login and password used
by the Agentry
Server.
Click the [Next] button to continue.
- Enter the Net Service Name through which this
connection is identified on the system. Be sure to note this name
as it is needed to configure the Agentry
Server to
connect to the target database.
Click the [Next] button to continue.
- Complete the creation of the new Net Service Name and
close the wizard, or add another Net Service Name.
Selecting Yes will repeat this procedure. Selecting No will advance the wizard to the final screen, where the Net Service Name creation process is completed.
- Complete the Net Service Name wizard by clicking the [Next] button
on the final screen.
At this point the main options for the Net Configuration Assistant utility are presented again. To close this utility, click the [Finish] button.
When this procedure is complete, an Oracle Net Service Name is created on the host system to which the Agentry Server will be installed. The Server will use this Net Service Name to connect to the database with which it will synchronize data for the mobile application.
Note the Net Service Name created, as well as the login and password used by the Agentry Server to connect to the database instance. These values are needed when configuring the Agentry Server after it is installed.