Super user
/opt/FJSVclora/bin/clorainfo { -c [ RMSconfiguration ] | -e | -m [ ResourceName ] | -v }
clorainfo displays configuration information and monitoring state of Wizard for Oracle.
The option displays setup information of Wizard for Oracle resources that are defined in the specified RMS configuration. Specify the RMS configuration name for RMSconfiguration
If RMSconfiguration s omitted, setup information of Wizard for Oracle resources that are currently active in the RMS configuration will be displayed.
The option displays Oracle database setup information on the local node.
Note
The kernel parameter values is not displayed.
When composing of the single installation user in scalable operation with Oracle RAC
When you compose the single installation user of Oracle Database and Oracle Grid Infrastructure, the environment variable of the Oracle RAC instance resource and the Oracle RAC listener resource is same.
The Setting of Protocol Addresses of the Oracle RAC listener resource displays information on ORACLE_HOME defined in installation user's login profile.
It is an example as follows when ORACLE_HOME of Oracle Database is defined in the login profile of the single installation user "Oracle".
Example
# /opt/FJSVclora/bin/clorainfo -e
:
node1 : Oracle1_orcl1.i
----------------------------------------------------------------
User registered in RMS (uid) : oracle (501)
User Group (gid) : oinstall (1000)
: dba (501)
: asmadmin (1100)
: asmdba (1300)
ORACLE_BASE : /u01/app/oracle
ORACLE_HOME : /u01/app/oracle/product/12.1.0/dbhome_1
ORACLE_SID : orcl1
ORACLE_SID registered in RMS : orcl1
ORA_NLS33 : ----
LD_LIBRARY_PATH : /u01/app/oracle/product/12.1.0/dbhome_1/lib
LD_LIBRARY_PATH_64 : /u01/app/oracle/product/12.1.0/dbhome_1/lib
PATH : /u01/app/oracle/product/12.1.0/dbhome_1/bin:/usr/bin:/usr/sbin
NLS_LANG : AMERICAN_AMERICA.US7ASCII
GridUser registered in RMS (uid): oracle (501)
GridUser Group (gid) : oinstall (1000)
: dba (501)
: asmadmin (1100)
: asmdba (1300)
ORACLE_BASE : /u01/app/oracle
ORACLE_HOME : /u01/app/oracle/product/12.1.0/dbhome_1
ORACLE_SID : orcl1
ORACLE_SID registered in RMS : +ASM1
ORA_NLS33 : ----
LD_LIBRARY_PATH : /u01/app/oracle/product/12.1.0/dbhome_1/lib
LD_LIBRARY_PATH_64 : /u01/app/oracle/product/12.1.0/dbhome_1/lib
PATH : /u01/app/oracle/product/12.1.0/dbhome_1/bin:/usr/bin:/usr/sbin
NLS_LANG : AMERICAN_AMERICA.US7ASCII
node1 : Oracle1_LISTENER.l
----------------------------------------------------------------
GridUser registered in RMS (uid): oracle (501)
GridUser Group (gid) : oinstall (1000)
: dba (501)
: asmadmin (1100)
: asmdba (1300)
ORACLE_HOME : /u01/app/oracle/product/12.1.0/dbhome_1
Listener registered in RMS : LISTENER
Protocol Addresses : (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))The option displays whether or not Wizard for Oracle resources are being monitored (enable: monitoring is active, disable: monitoring is inactive).
If ResourceName is specified, it will check the status of resource monitoring and returns the one of the following codes:
0: Monitoring is active (RMS is running)
2: Monitoring is inactive (RMS is running)
10: Monitoring is active (RMS is not running)
12: Monitoring is inactive (RMS is not running)
The resource name of Wizard for Oracle (ResourceName) must exist on the local node.
If ResourceName is omitted, whether or not all the resources of Wizard for Oracle on the local node are monitored will be displayed.
The option displays package information of Wizard for Oracle that is installed on the local node.
0: Normal termination or RMS is running and resource monitoring is active (“-m ResourceName” specified)
2: RMS is running and resource monitoring is inactive (“-m ResourceName” specified)
10: RMS is stopped, and resource monitoring is active (“-m ResourceName” specified)
12: RMS is stopped, and resource monitoring is inactive (“-m ResourceName” specified) Other than the above values: Abnormal termination