Establishing Connectivity: Oracle Net Service Names

Create a Net Service Name for use by an Agentry Server.

Prerequisites
Address the following items prior to performing this procedure:
  • 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.

Task

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.

  1. Start the Oracle Net Configuration Assistant and select Local Net Service Name configuration.

    Click the [Next] button to continue.

  2. Select Add to create the Net Service Name.

    Click the [Next] button to continue.

  3. Select the Oracle database version used in your environment.

    Click the [Next] button to continue.

  4. Enter the Database Service Name to which the Agentry Server will connect.

    Click the [Next] button to continue.

  5. 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.

  6. Enter the Communications Protocol-specific configuration information.
    • TCP or TCPS: Enter 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: Enter the IPC Key value for the local Oracle database service.

    • NMP: Provide the Database Host Computer Name. You must also enter the database pipe name or choose the default pipe name provided.

    Click the [Next] button to continue.

  7. 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.

  8. Perform a test by following 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 Server. Once the testing is complete, click the [Next] button to continue.
  9. 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.

  10. 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.

  11. 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.

Next

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.