Home > Documentation > Oracle to PostgreSQL > Tutorial
Step 2 of 7. Connect to Oracle Server
This page allows specifying the necessary settings to establish
connection with Oracle server:
- Server - IP address or network name of Oracle server. If Oracle to PostgreSQL converter has been installed on the server machine, "127.0.0.1" or "localhost" can be specified in this box.
- Database name - enter the same title that is used by SQLPlus or any other standard Oracle tools to point the database.
- Port - port for connecting to Oracle. It must be specified only when the value differs from the default value 1521.
- Username - Oracle user name
- Password - Oracle user password
Oracle to PostgreSQL migration tool provides two methods of connecting
to Oracle server: direct and via TNSNAME.ORA entry. To use the first method
enter information in all fields except the port if it is configured
by default (1521). The second method requires leaving both "Server"
and "Port" fields empty and enter Oracle service name as it
appears in TNSNAME.ORA file in "Database" field.
Sometime user may get the following error: "Oracle data source doesn not exist. Check to verify correct name was given." despite of the fact that all Oracle connection settings have been specified properly. It means the converter failed to conect to Oracle server using TNSNAME.ORA. To bypass the error leave both "Server" and "Port" fields empty and enter in "Database" field the connection string as follows:
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=IP address of Oracle server)(PORT=the port)))
Of course, it is required to replace "IP address of Oracle server" and "the port" by actual values.
Have questions? Contact us