Connecting to Oracle

To connect to an Oracle server, you need to specify the database server host name or IP address, the port the Oracle server is listening, the service name or SID, the user name and password to sign in.

note Important Note

Your Oracle server must be available through the Internet in order for Skyvia to connect to it. Oracle Cloud is also supported.

If you are connecting to Oracle server on your local computer, allow such connections in your firewall. If you are connecting to a computer in your local network you should use port forwarding.

Skyvia will access your server from the IP 40.118.246.204.

oracle-connection-new

You need to specify the following parameters for Oracle connection:

Name - connection name that will be used to identify the connection on the Connections page and when selecting a connection for a package.
Server - the name or IP address of the Oracle server host to which to connect.
Port - Oracle server connection port; default value is 1521.
Connection Syntax - determines whether to use Service Name or SID to connect.
Service Name - alias to an Oracle database instance (or many instances) to use.
SID - unique name for an Oracle database instance
User - the user name to login with.
Password - the password to login with.
Connect As - Specify how you want to connect to the Oracle server. This parameter is set to 'Normal' by default. Alternatively, you can select administrative privileges, such as: SYSDBA, SYSOPER, SYSBACKUP, SYSDG, SYSKM.

note Important Note

If you need to pass UTF8 characters to an Oracle database, click the Advanced button and select the Unicode check box.

In the Advanced parameters you can also select the Unicode check box to use Unicode encoding for the connection and specify the Command Timeout interval. The latter specifies the wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data.

Additionally the Advanced parameters include the Connection Timeout parameter. This parameter determines the time (in seconds) to wait while trying to establish a connection before terminating the attempt and reporting an error. Generally you don't need to modify it, but in some specific cases when a connection to the database server is not good you may try increasing their values.