Create Oracle credentials

If you are scanning Oracle databases, you can create Oracle credentials. The tnsnames.ora file is updated automatically after you create an Oracle credential.

  1. Navigate to Configuration > Discovery Management > Credentials.
  2. Click Create New Credential +.

Create New Oracle Credential

  1. Enter a Credential Name.
  2. From the Type list, select Oracle.
  3. Provide a username and password, and confirm it.
  4. Select an Access level from the list: Standard, SYSDBA, or SYSOPER.
  5. Select additional connection options:
    • Connect To: Select Database SID or Named Service.
    • Enter the database SID or name of the service, depending on which option you had selected.
    • Protocol: Select TCP, TCPS, or NMP.
    • Host: Enter the host name where the Oracle database resides. If this credential is used for multiple Oracle hosts, separate each host name by a comma.

IPv4 addresses, IP address ranges, CIDR notation, and named hosts are supported formats. Multiple SIDs, named services, TCP ports, and pipe names are not supported.

  • Port: The default port is 1521. Use the + and - buttons to change this if necessary.
  1. Enter a key and confirm if those fields are available.

The Key and Confirm Key fields display only when your administrator has enabled the global site setting to require access keys for discovery credentials: Configuration > System > Site Options > Global Discovery Credential.

  1. Click Create Credential.