Ask the Community
Groups
How to configure the Oracle agent on Windows - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>The purpose of this article is assist with the configuration of the Oracle agent</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p>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.</p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p> </p> <ol><li>Remove the credentials stored for the <strong>Protected Asset</strong> (Client) in the (CONFIGURE > Protected Asset <tab>) . By doing so, we are connected to the client as <strong>NT AUTHORITY\SYSTEM</strong>, which is a member of the <strong>ora_dba</strong> group by default. You can validate this on your Windows server by viewing the members of the <em>ora_dba group</em>.<br><br></li> <li>On the Oracle server, modify the sqlnet.ora file configuration parameters $ORACLE_HOME/network/admin/sqlnet.ora and change <pre class="code codeBlock" spellcheck="false" tabindex="0"><strong>SQLNET.AUTHENTICATION_SERVICES = (NONE)</strong></pre> to <pre class="code codeBlock" spellcheck="false" tabindex="0"><strong>SQLNET.AUTHENTICATION_SERVICES = (NTS)</strong></pre> </li> <li>On the Unitrends appliance perform an <strong><a href="https://kaseya.vanillacommunities.com/kb/articles/aliases/unitrends/hc/en-us/articles/360013266778" rel="noopener nofollow">Inventory Sync</a></strong> to which will pole the Oracle databases. You should now see the list of databases without error.</li> </ol><p><br>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: <strong> /usr/bp/bin/inventory_sync</strong></p> <h2 data-id="tasks"><strong>TASKS</strong></h2> <p>For more information, review Oracle's <a href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.oracle.com%2Fcd%2FE11882_01%2Fnetwork.112%2Fe10835%2Fsqlnet.htm%23NETRF199" rel="noopener nofollow">Database Net Services Reference</a><br><br> </p> </article> </main>