Imperva Cyber Community

Expand all | Collapse all

Is configuring Oracle RACs for assessment the same as monitoring?

  • 1.  Is configuring Oracle RACs for assessment the same as monitoring?

    Posted 07-02-2020 13:32
      |   view attached
    Will the instructions in the attached document (from Imperva documentation) for assessment?

    We are having issues setting up connections for Oracle RACs. The servers in the RAC can have multiple IPs, so when we add a server to a server group, then try to set up a connection, it fails because it uses the other IP address. For example, we add a server by hostname and it resolves to one of the IP address, if you delete the server and re add it, it resolves to a different IP address. Will creating the connection string allow us to create a single connection for a RAC that will allow us to access all the servers in the cluster?
    #DatabaseActivityMonitoring

    ------------------------------
    Brandon Zeitlin
    ------------------------------


  • 2.  RE: Is configuring Oracle RACs for assessment the same as monitoring?

    Imperva Employee
    Posted 07-06-2020 04:51

    HI
    Assessment is not the same as monitoring. For Oracle RAC clusters you cant just add an IP Address in the direct access database connection. it may or may not work depending on IP Address used.

    you will need to create Remote DB connection via the system definitions. expand out the oracle thin driver and add a user defined connection for the oracle RAC database and add each IP Address and port that the Oracle RAC database is assigned.

    jdbc example:

    jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=$host) (PORT=$port))(ADDRESS=(PROTOCOL=TCP)(HOST=$host) (PORT=$port))(CONNECT_DATA=(SERVICE_NAME=$dbname)))
     
    once this is done, select the manually created connection string in the database connection. otherwise add the database connection in the normal way.

    ------------------------------
    Trevor Jackson
    ------------------------------