Connect to an Oracle database

Make sure the relevant versions of Oracle Client & Visual C++ Redistributable Package are installed on your PC.
In the Oracle Database Connection window, in the Connection group box, enter the user name and password. If the Save password for the current connection check box is selected, the password for the current connection is saved encrypted for the next use.
To avoid an unauthorized access from your PC to a database, we recommend that this option should be disabled.
Select one of the connection types: TNS, Direct, or LDAP:

  • For TNS, select a database to which you would like to connect.
  • For Direct, enter a host name, port, and SID or service name.
  • For LDAP, enter an LDAP server and its attributes.
From the Connect as drop-down list, select the type of connection: connect as a normal user, as SYSDBA, or SYSOPER.
From the DB type drop-down list, select a database type which you would like to assign to the database. This feature helps organize your database connections in groups, e.g. Development, Production, Test, or others. Define background and foreground colors for each type to easily identify them while working with the content of your mission critical databases.
A primary Oracle home is selected by default. Use the drop-down list to select another home if needed.
Click Connect. The application connects to the database, and the Oracle Database Connection window closes so you can proceed with ClearSQL.
  • Enable the Auto connect option to automatically connect to the selected database at the next application launch.
  • Use Oracle Wallet to securely store database credentials, instantly update and manage them across multiple databases. For more details, refer to Oracle Documentation.
This document was last updated on February 20, 2020