Топ-100
 
logo-cerebrosql.jpg

Configuring a connection to Oracle DBMS

The section describes the procedure for creating a connection to the Oracle DBMS for its further use by both the monitoring system core, the query editor, and other program modules.

oracle-logo.jpg
Create connect oracle.jpg

Create a connection

First you need to create a tree structure according to the instructions in the section "Buttons and control of the connection tree"

  • Select the node in the tree where you want to create a connection

  • Press the "Create new connect" button

  • In the "Connection alias" field, enter a unique name within the node

  • From the "Database type" drop-down list select "Oracle"

  • In the "VendorHome" field, specify the directory where the Oracle client is installed. The directory must be specified if you want to use an Oracle "client" other than the default one used by program 

  • Specify the full path to the oci.dll library in the "VendorLib" field. The path must be specified if it is necessary to use an Oracle "client" other than the default one used by the program.

  • In the "TNS_ADMIN" field, specify the directory in which the tnsnames.ora file is located (for the case of its use)

  • In the "Comment" field, add a description of the connection (if desired)

Connection options
  • From the drop-down list "Parameter name" select the name of the parameter

  • Enter the parameter value in the "Value" field

  • Add a parameter by pressing the button "Add parameter"

  • To delete a parameter, the "Delete parameter" buttons are pressed

To test the connection, click the "Testing connect" button

To save the connection, click the "Save" button

Description of parameters and possible values
database

Description: 

The value can be one of the following:

TNS alias - Specifies which database to connect to.

TNS connection handle - as in TNSNames.ora

Oracle connection string -- as in SQL*Plus.

Examples:

  • OraDB

  • (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = OraSrv)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))

  • scott/tiger@OraDB

  • system/manager@OraDB as sysdba

  • OraDB:1521/orcl

 

OS Authentication

Description:

Specify "Yes" to use OS authentication and "No" to use DBMS authentication.

Possible values:

Default "No"

User_Name

Description:

Oracle username if OSAuthent=No

Possible values:

Scott

Password

Description:

Oracle user password if OSAuthent=No

Possible values:

tiger

AuthMode

Description:

Oracle authentication mode:

  • Normal -- a normal user. Default value.

  • SysDBA is a user with database administrator rights.

  • SysOper is a user with database operator privileges.

  • SysASM is a user with database administrator privileges for Oracle Automatic Storage Management instances.

  • SysBackup is a user with database administrator privileges for backup and restore operations.

  • SysDG is a user with database administrator privileges for Oracle Data Guard operations.

  • SysKM is a user with database administrative rights for operations with the Transparent Data Encryption key vault. 

Possible values:

Normal 

readtimeout

Description:

Specifies the timeout value in milliseconds for receive or read operations. Specifying zero means no timeout.

Note: . Use this setting in environments where clients occasionally disconnect intentionally or abnormally. Otherwise, the database server may be waiting for data from clients, which may be offline or experiencing problems.

Possible values:

WriteTimeout

Description:

Specifies the timeout value, in milliseconds, after which the database server completes a send operation to clients. Specifying zero means no timeout.

Note: . Use this setting in environments where clients occasionally disconnect intentionally or abnormally. Otherwise, the database server may continue to send responses to unreachable clients.

Possible values:

character set

Description:

The character set for the connection. If not specified, the value of the NLS_LANG variable is used.

Possible values:

  • UTF8

  • cl8mswin1251

BooleanFormat

Description:

Specifies how to represent boolean values:

  • Choose -- uses the Boolean type to represent PL/SQL boolean options. This is the default mode. Note. This is true for Oracle 12c or later. In previous versions of Oracle, the Integer type was used in Choose.

  • Integer -- uses the Integer type to represent PL/SQL boolean parameters, where False = 0 and True = 1.

  • String -- uses the String type to represent PL/SQL boolean parameters, where False = 'F' and True = 'T'.

Possible values:

Choose

ApplicationName

Description:

App name. If specified, this value is stored in the V$SESSION -> MODULE column.

Possible values:

OracleAdvanced

Description:

Additional Oracle session options. For details, see the chapter ALTER SESSION SET, paragraph "Initialization parameters and ALTER SESSION". The value format is <option>=<value>[;...].

Possible values:

NewPassword

Description:

Specifies the new Oracle user password. The program connects to the database using the old password and immediately changes it to a new one.

Possible values:

tiger2