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 running on, the service name or SID, the user name and password to log in with. Skyvia supports both on-premise Oracle servers and Oracle Cloud.
For connecting to local Oracle servers (in your local network), Skyvia offers two options: direct connections and agent connections.
In order to use a direct connection, your Oracle server must be available through the Internet. If you are connecting to Oracle server in your local network, allow such connections in your firewall (Skyvia accesses your server from the IP 184.108.40.206). You should also configure port forwarding.
Agent connections don’t have such requirements, but you need to install the Skyvia Agent application in order to use them.
You need to specify the following parameters for Oracle connection:
- Name — connection name that will be used to identify the connection in the objects list and when selecting a connection for a package.
- Server — name or IP address of the Oracle server host to connect to.
- Port — Oracle server connection port; default value is 1521.
- Connection Syntax — this parameter 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 — user name to log in with.
- Password — password to log in with.
- Connect as — this parameter specifies 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, SYSASM, SYSBACKUP, SYSDG, SYSKM.
If you need to pass UTF8 characters to an Oracle database, click Advanced Settings and select the Unicode check box.
In Advanced Settings, 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, Advanced Settings 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.