That page includes instructions for completing the arcgis/oracle db connections

example: into the field lableled "Instance;" fill in the following:

1. Enter the oracle tns name. or provide one of the followig:"
1. The name of the Oracle server/Oracle service name or ID
   For example, if Oracle is installed on myserver and myosvc is the Oracle service name, type the following:
   myserver/myosvc
2. The name of the Oracle server:Oracle port number/Oracle service name or ID In this example, Oracle is installed on myserver, is listening on port 60000, and myoservice is the Oracle service name.
   myserver:60000/myoservice
3. The URL of the Oracle server
   The URL for the same instance shown in the last example would be the following:
   //myserver:60000/myoservice
4. The name of the Oracle server (You can use this if the Oracle listener on the server is configured to point to a default instance.)
5. The IP address of the Oracle server/Oracle service name or ID For example, if the address of the server is 10:10:10:10, and the Oracle service name is orasvc, type 10:10:10:10/orasvc.
   
   
6. The IP address of the Oracle server:Oracle port number/Oracle service name or ID In this example, the IP address is 10:20:30:40, port is 59999, and the Oracle service is myomy1: 10:20:30:40:59999/myomy1.
   
   An IPV6 address for the same port and service would look like the following: [6543:ef4:0:1:f587:l249:12f9:a3cd]:59999/myomy110:20:30:40:59999/myomy1.