Ask the Community
Groups
Linux Oracle not detecting any databases, dependency is installed - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>Linux or Solaris agent and Oracle dependency agent are both installed on a server with a supported version of Oracle. The appliance UI does not indicate any databases are found on the oracle server. </p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p>Either an Oracle Home is not defined for the database, more than 1 home is defined for the database where it must only have a single home, or the database is a RAC configuration that is unsupported by this agent. </p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p>On the Linux box you should be able to run:<br><br>cat /etc/oratab<br><br>This will give you a list of databases deployed on the current system. It will be a : separated list of sid:home:boot. Ensure each Oracle instance one home has been defined. </p> <p>After a home is defined, perform an inventory sync from the Unitrends UI of the oracle server and the databases should now be visible. </p> <p> </p> <p>This is also a good time to verify user/group permissions that will be required. <br>For each unique home path you should run the following:<br><br>export ORACLE_HOME=home<br>${ORACLE_HOME}/bin/osdbagrp</p> <p>This will give you the oradba system group used to manage the Oracle Instance</p> <p>Using this group run:<br><br>lid -g <group><br><br>That command should give you a list of users that could be used as system level oracle dbas for that unique home. Ensure you use a user of this group as your oracle credential or add/change user permissions as necessary in Linux so that a valid account credential can be provided to Unitrends.</p> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p>The Oracle backup needs to have a user that is known by the Linux OS and the Oracle DBand each Oracle Instance requires a defined home path.. </p> </article> </main>