Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
128 views

Oracle RAC discovery issue

Hi Experts,

 

UCMDB 10.11 with CP14.

 

The discovery job "Oracle RAC Topology by Shell" has recently started failing with the following errors,

 

<CMD>[CDATA&colon; /u01/app/oragrid/product/11.2.0.4/grid/bin/srvctl status database -d DBNAME ; echo ERROR_CODE:$?],/CMD>
<RESULT>[CDATA&colon; PRCD-1027 : Failed to retreive database DBNAME
PRCD-1229 : An attempt to access the configuration of the database DBNAME was rejected because its version 11.2.0.3.0 differs from the program version 11.2.0.4.0.
Instead run the program from /u01/app/<dir>/product/11.2.0.3/dbhome_1

 

The communication log contains the following error,

 

UDA: Internal error. Details: Traceback (most recent call last):
File "oracle_rac_topology_by_shell", line 404, in DiscoveryMain
File "oracle_shell_utils", line 353, in setOracleHomeEnvVar Value
Error: No ORACLE_HOME passed to the UnixOracleEnvConfig class

 

The DBA tells me this is because the Oracle Grid Infrastructure (GI) is at a higher patchset version than the database i.e. GI is at 11.2.0.4 whereas the database is at 11.2.0.3

 

Has anyone come across this issue before?, if yes did you resolve it?.

 

Possible options I can think off are,

 

1. Wait for the databases to be upgradede to 11.2.0.4, at which point the discovery job should complete successfully again. Not a great option as its likely to take some time to upgrade all the dbs.

 

2. Amend the "Oracle RAC Topology by Shell" job so it uses the srvctl program from within the respective database homes. Has anyone done this?, how could this be acheived (e.g. via adapter configuration setting or would it require changes to the Jython code?)

3. Use another method to discover Oracle RACs, for instance is it possible to integrate with Oracle GI and obtain RAC information from here?

 

Any advice greatly appreciated.

 

Thanks
Chris

0 Likes
1 Reply
Highlighted
Established Member..
Established Member..

Re: Oracle RAC discovery issue

Hi Chris

 

Can we have a full commlog here?

thanks

 

Jerry

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.