Oracle Logon Dialog
Manage your database connections, including to create a database connection.
Oracle Client Settings
| Field | Description |
|---|---|
| Oracle Home/Client | Select from the list of available Oracle Home names. |
| TNSNAMES/LDAP/SQLNET Configuration File Path | The location of your Oracle configuration files. |
| Names.Directory_Path | As specified in your sqlnet.ora file. |
Connection Parameters
Fill in the fields for one of the TNS, Direct or LDAP tabs.
TNS
| Field | Description |
|---|---|
| Database | Select from the list of database connections in the TNSNAMES.ora file. |
Direct
DIRECT is used for Direct Connection.
| Field | Description |
|---|---|
| Host | Enter the name or IP address of the machine which hosts the Oracle server. |
| Port | Enter the port number for the Oracle server. |
| Service Name | Enter the service name of the Oracle server. |
| SID | Enter the Oracle System Identifier (SID) of the Oracle server. Use this option when connecting to an instance running a version earlier than Oracle 8.1. |
LDAP
Select from the databases on the LDAP server.
Username / Password
| Field | Description | ||
|---|---|---|---|
|
Username |
Your Oracle username to the database. When Save Password is selected the username field automatically recalls username/password combinations based on the first letter(s) entered into the field. | ||
|
Password |
Your Oracle password to the database/username combination. | ||
|
Save password |
Select to save the password for this database/username combination.
| ||
|
TNSNames Editor |
Add a new service and configure the TNSNames.ora file: Oracle TNS Configuration. |
|
|
TIP: To change the logon password for the active connection: Close this dialog. Select Session | Change Password to open Change Logon Password. |
Options
| Option | Description | ||||
|---|---|---|---|---|---|
|
Bytes per Character |
Allow the system to automatically detect the number of bytes per character for the connection or select from the list of available numbers. The default preference is set in View | Preferences | General | Session. If you receive ORA-01026 errors (or similar) when working with the database, we recommend setting this preference to the minimum possible value (2, 3 or 4) that eliminates the errors. | ||||
|
Connect As |
Select the type of system privileges you want to use for this connection—Normal, SYSDBA, or SYSOPER. Your Username must first be granted these privileges. For information about system privileges, see the Oracle Database Administrator’s guide. | ||||
|
Enable using DBA views |
For more information, see DBA Dictionary Views. Your Username must first be granted appropriate Oracle privileges. | ||||
|
Enable Trace |
When selected, SQL Navigator generates a log file of database operations and results. Quest Support may request you enable trace for troubleshooting purposes. Enabling Trace slows down your access to the database. | ||||
|
Category |
Optionally, assign to the connection a category color. For more information, see Connection Category Color. |