What is the auto-discovery algorithm for Oracle environments?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I know Delphix does some sort of auto-discovery when I add/refresh an environment.  What exactly does it do?
Photo of Johnston Davis

Johnston Davis

  • 634 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of David Gillespie

David Gillespie, Employee

  • 1,010 Points 1k badge 2x thumb
Hi Johnston,
Delphix does quite a few things. In general this is what is occurring:

Determines cluster version and home

Get cluster nodes

Determine scan listener

Determine cluster name

Discover each nodes listener

Discover Oracle Homes

Discover running instances

Determine listener end points

Create jdbc strings for databases

I hope this helps.

Cheers,
Dave G.

Photo of Johnston Davis

Johnston Davis

  • 634 Points 500 badge 2x thumb
I'm trying to figure out why a certain Oracle Home was not detected.  Can you tell me if the algorithm uses the inventory, the oratab file, or both?
Photo of David Gillespie

David Gillespie, Employee

  • 1,010 Points 1k badge 2x thumb
In Discover Oracle Homes we check for the oraInst.loc file which will be in either /etc/oraInst.loc or /var/opt/oracle/oraInst.loc depending on the OS. From here we find the oracle inventory directory which this file points to. We then will traverse that to find the Oracle installations.
The Delphix_OS user will need access to /etc/oraInst.loc or other listed above and the oracle inventory location as well as read access to the files under the inventory location. We need to gather data from some of the oracle xml files to determine the Oracle Home locations etc.
We will then need access to the ORACLE_HOME as well.
The best solution is to run hostchecker on any new target or source server to verify things are setup correctly as the delphix_os user.
I hope this helps.
Cheers,
Dave G.
Photo of Ranzo Taylor

Ranzo Taylor, Employee

  • 1,572 Points 1k badge 2x thumb
Johnston, you may be interested in this article, which explain the algorithm in detail:
https://community.delphix.com/delphix/topics/oracle-single-instance-autodiscovery-algorithm