Product Description
Oracle Pro*C is a precompiler for C and C++ that allows embedding of SQL in the C/C++ code.
Oracle Pro*C is an optional component (Oracle Programmer) of Oracle Database installation.
Identification
The pattern triggers when an Oracle Database SI is created (or confirmed) on a scan host, providing that the SI has 'ora_home' (installation directory) attribute set.
Providing that 'ora_home' and database instance name are defined, the pattern locates the installed components inventory file (comps.xml) and parses it to determine whether Pro*C is installed.
The command used to parse the file:
grep "oracle.precomp\"" <oracle_installation_dir>/inventory/ContentsXML/comps.xml | grep RELEASE - UNIX platform
CMD /C FINDSTR /R /B .COMP.NAME=.oracle\.precomp..VER= "<oracle_installation_dir>\inventory\ContentsXML\comps.xml" - Windows platform
If the results do not return any data, the pattern stops.
| Note:On UNIX platform, in order to access the comps.xml file the Foundation user will need to be in the same group as the user that is the owner of the inventory/ContentsXML/ directory and the comps.xml file |
Versioning
While Pro*C version is likely to be the same as that of the Oracle Database it was installed with, the version is obtained as part of the identification process, since the version information is also available.
The results obtained from running the command to identify Oracle Pro*C are further parsed using the following regular expressions:
VER=\"(\d+(?:\.\d+)*)\"Application Model Produced by the Pattern
Software Pattern Model
If the Oracle Pro*C installation is identified, a Detail node is created storing the information about this component of Oracle Database. Version and Oracle installation path are also stored on the Detail node.
The Detail node is then linked to the Oracle Database SI that triggered the pattern.
Management of Pro*C Detail node
Since the Detail node is not automatically managed by Foundation, the pattern itself manages it - in cases where the pattern no longer identifies Oracle Pro*C, the Detail node is deleted.
Testing
Testing to ensure that Oracle Pro*C installations were detected was performed on live installations of Oracle on Unix and Windows platforms
Reporting on Oracle Pro*C Installations
You can use the following report to show Oracle Pro*C installations.
SEARCH Detail WHERE name matches regex "^Oracle Pro*C"
SHOW name, #Detail:Detail:ElementWithDetail:SoftwareInstance.type AS DatabaseType,
#Detail:Detail:ElementWithDetail:SoftwareInstance.instance AS Instance,
#Detail:Detail:ElementWithDetail:SoftwareInstance.#RunningSoftware:HostedSoftware:Host:Host.hostname AS Hostname
Open Issues
N/A
| TOP |
|---|
Created by: Nikola Vukovljak 27 Mar 2009
Updated by: Viktor Moyseyenko 30 Mar 2009
Reviewed by: Viktor Moyseyenko 30 Mar 2009
Tideway Blog