4.3.9.4 LIST DATABASEHOMES

This command lists the existing Oracle database homes.

Syntax

LIST DATABASEHOMES
[ WHERE
     { ID=database_home_id | 
       CLUSTERNUMBER=cluster_number [ NAME=database_home_name ] |
       CLUSTERNAME=cluster_name [ NAME=database_home_name ] |
       CLUSTERID=cluster_id [ NAME=database_home_name ] } ]

Arguments

The following arguments are available in the WHERE clause:

  • ID : Specifies the es.xml ID for the target database home

  • CLUSTERNUMBER : Specifies the cluster number in the es.xml, starting at 1

  • CLUSTERNAME : Specifies the name of the cluster

  • CLUSTERID : Specifies the es.xml ID of the cluster

  • NAME : Specifies the name of the target database home