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