Skip to main content

Targeting an Oracle Database

For each Oracle, add a target system (Manage the system > Resources > Target systems):

  • Type is Oracle Database .

  • Address :

    Server: The TNS Name configured previously or TNS entry

    Alternatively, you can specify the connect descriptor; for example:

    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostdbsvr)(PORT = 1521)))(CONNECT_DATA=(SID=ORACLE)(SERVER=DEDICATED)))

    (key: server)

    Authentication type: Target system administrator authentication type, either "Database" or "External", default is "Database".

    (key:authType)

  • Administrator ID and Password are the login ID and password for the target system administrator you configured in earlier.

    Set Administrator ID and Password to the Windows login user’s credentials when external authentication is selected, in the format of <DOMAIN>\<USERNAME> . Ensue the runas option is enabled for the administrator. Also ensure NTS is enabled in sqlnet.ora .

    If the target administrator’s ID contains lowercase characters, enclose it in double quotes.

    Bravura Security Fabric normally connects to Oracle database with "SYSTEM" administrator privileges. Higher level privileges may be required; for example, for create user or reset password operations. To allow Bravura Security Fabric to connect with "sysdba" privileges, specify the administrator ID followed by /SYSDBA (all uppercase), for example, sys/SYSDBA .

The full list of target system parameters is explained in Target system options.