Registering the server definitions for an Oracle data source

You must register, in the federated database, each Oracle server that you want to access.

1. If you plan to use the NODE server option to specify which remote database to connect to, locate the node name in the Oracle tnsnames.ora file.
   For example, in the following tnsnames.ora file the node name is paris_node:

   paris_node =
     (DESCRIPTION =
       (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = somehost)(PORT = 1521)))
     (CONNECT_DATA = (SERVICE_NAME = ora9i.seel)))

2. To register the server definitions for an Oracle data source, use one of the following methods:

   Method	Description
   Use the Administration Explorer in IBM® Data Studio.	In the Federated Database Objects folder, right-click the Remote Servers folder, and select Create Remote Server.
   Issue the CREATE SERVER statement for a database that is cataloged.	The NODE option is required. For example: CREATE SERVER server_name TYPE oracle VERSION 11.0 WRAPPER net8 OPTIONS (NODE 'abc') After the server definition is registered, use the ALTER SERVER statement to add or drop server options.