Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

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.

Note:

  • Your password is saved in encrypted format.
  • Ensure you have safeguards in place to prevent other users from physical access to your computer (for example, automatic keyboard locking).
  • If you have saved a password then deselect Save Password to delete it.

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

Selected Use DBA views to query the Oracle Data Dictionary.
Not Selected Use ALL views to query the Oracle Data Dictionary.

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.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating