Oracle Human Resources Integration: Networking Setup

Configuring Network Connectivity

Before configuring the HR agent it is necessary to ensure you have database connectivity between OID and your HR database. Using the NETCA (Network Configuration Assistant) you can add a Net Service Name to your OID tnsnames.ora file. Follow these steps if you need database network connectivity between OID and Oracle HR.

Step 1. Start the "netca" application.

Step 2. Select "Local Net Service Name configuration".

Step 3. Select "Add".

Step 4. Select the database version you are connecting too. In this example we are connecting to an Oracle 8i or later database.

Step 5. Enter a "Service Name" AKA "Global Database Service Name". In our example we will use HRDB.US.ORACLE.COM as our Global Database Service Name.

Step 6. Select the TCP network protocol.

Step 7. Enter the fully qualified host name of the HR server and the port number that the HR database is listening on.

Step 8. Select "Do not test". We will test the connection using the "tnsping" command line tool at the end of this lesson.

Step 9. Enter a "Net Service Name. In our example we will use "HRDB".

Step 10. Select "No" to the question about configuring another "Net Service Name"

Step 11. Click finish.

Step 12. Test the new connection using the "tnsping" command line tool.

Example:

# tnsping hrdb

If you successfully connect you should see something similar to this:

Here is a viewlet to show you how its done.