Before you can connect to an Oracle database within iBridge you must install and run
the Net Configuration Assistant software on each client computer. The Net Configuration
Assistant creates or modifies the file tnsnames.ora, this contains the connection
information for any Oracle servers, and is normally located in the folder oracle\admin.
You can edit this file manually or you can use the Net Configuration Assistant tool
supplied with the Oracle client software.
To perform a typical TCP/IP Net Configuration setup using the Net
Configuration Assistant tool:
-
Start the Net Configuration Assistant tool from the Start menu:
Note: The path may be different depending on your
operating system.
-
Select Local Net Service Name configuration from the
list of configurations to use and click Next to display
the Net Service Name Configuration page.
-
Select Add and click Next to
move to the Net Service Name Configuration, New Service Name page.
-
Enter a service name in the Net Service Name box, this
is composed of the database name followed by the Oracle domain name. You can
find out the Oracle domain name by looking in the init.ora
file. An example of the line of the file you would see is db_domain =
my_domain.com. Click Next to display Net
Service Name Service Configuration, TCP/IP Select Protocols page.
-
Select TCP and click Next to
display the Net Service Name Service Configuration, TCP/IP protocol page.
-
Ensure that the port number is correct. The number defaults to 1521 and you
should not normally need to change this. Click Next to
display the Net Service Name Service Configuration, Test page.
-
Click Test to check the connection. The Connection Test
dialog is displayed and the connection is tested. When this is complete click
Close to close the Connection Test dialog and finish
the New Configuration setup.