How to configure the Oracle agent on Windows

SUMMARY

The purpose of this article is assist with the configuration of the Oracle agent

ISSUE

The purpose of this article is assist with the configuration of the Oracle agent on Windows.  By properly configuring the Oracle agent credentials you will have the option of performing backups of your Oracle databases, and doing so avoids related alerts due to inventory sync warnings.

RESOLUTION

1. Remove the credentials stored for the Protected Asset (Client) in the (CONFIGURE > Protected Asset <tab>) . By doing so, we are connected to the client as NT AUTHORITY\SYSTEM, which is a member of the ora_dba group by default.  You can validate this on your Windows server by viewing the members of the ora_dba group.
   
   
2. On the Oracle server, modify the sqlnet.ora file configuration parameters  $ORACLE_HOME/network/admin/sqlnet.ora and change

   SQLNET.AUTHENTICATION_SERVICES = (NONE)

    to

   SQLNET.AUTHENTICATION_SERVICES = (NTS)

3. On the Unitrends appliance perform an Inventory Sync to which will pole the Oracle databases.  You should now see the list of databases without error.

You can confirm that the daily inventory_sync command (runs at 8:00 pm) does not create the alert by running it manually and then refreshing the list of open alerts.  The command is:   /usr/bp/bin/inventory_sync

TASKS

For more information, review Oracle's Database Net Services Reference