Online Documentation for SQL Query for Oracle
Advanced connectionon settings
You need the installed Oracle client on the client computer where SQL Query for Oracle will be used. The version of the Oracle client should be compatible with the version of Oracle server you need to connect.
You need to add the connection settings of Oracle server databases to your TNS names file (tnsnames.ora file). This is a configuration file which contains databases description.
If you use Database Client the tnsnames.ora file is located in the %HOME_name\NETWORK\ADMIN directory.
If you use Instant Client for oracle, you should create tnsnames.ora file manually. since it does not exist. File should be created in the same directory where Oracle instant client is installed (e.g. C:\OracleInstantClient\). This file can be created using any text editor (create a simple text file and then change its name and extension).
Only for Instant Client: After the tnsnames.ora file is created and database description is added, create TNS_ADMIN environment variable. For this please do the following:
- Right-click 'My computer'.
- Select 'Properties' menu item.
- Proceed to the 'Advanced' tab and press 'Environment Variables' button.
- Press 'New...' button in the 'System variables' section.
- Set 'Variable name:' TNS_ADMIN, 'Variable value:' C:\OracleInstantClien\tnsnames.ora
- Press 'OK' button to save the variable.
Find PATH variable in the same dialog, double-click it and add path to the Oracle Instant client libraries (they are located in the directory where client is installed, i.e. C:\OracleInstantClient\). Remember that the paths entries should be separated with semicolons ( ; ).
SQL Query for Oracle connects to the server (with the help of Oracle client) via TCP/IP protocol. Here is an example of TCP/IP connection specified in TNS names file:
(ADDRESS = (PROTOCOL = TCP)(HOST = Host_name)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = Database_Name)
PROTOCOL is the keyword that identifies the specific protocol adapter used. For this protocol, the value is TCP. The value can be entered in either uppercase or lowercase.
HOST is the host name or IP address.
PORT is the TCP/IP port number.
SERVICE_NAME the name of service on server; the database instance name may differ from the actual database name, but generally the names match.
DB_Alias any name of the connection
When the client is installed, you can register a database in SQL Query for Oracle. To open the wizard, select the Database | Register Database... main menu item, or use the Register Database button on the main toolbar. You can also use the Shift+Alt+R shortcut for the same purpose.
At the firs step select Oracle client HOME in Home name dropdown list. Proceed to the step Setting registration options and select database from the Database name dropdown list. The databases names are taken from the tnsnames.ora file.