Oracle Database 11g Installer Disappears After Prerequisite Checks

Recently I was attempting to install Oracle Database 11g on Windows 7 64 Bit.
The installer was not behaving by disappearing without a trace after running the prerequisite checks.

This forum post was helpful, https://forums.oracle.com/forums/thread.jspa?threadID=2190825

Specifically, I used the jreLoc flag to setup.exe and specified a different JDK.
Also, the flag did not like the JRE under "Program Files" I think due to the space in the name, so I had to copy my jdk to C:\ to make it work.


C:\database>setup -jreLoc "C:\Program Files\Java\jdk1.7.0_02"
Did not work...
However,
C:\database>setup -jreLoc c:\jdk1.7.0_02
works fine.

Unable to Open HFM Applications - A null reference pointer was passed to the stub.

Very strange error when opening any HFM Application. 

A null reference pointer was passed to the stub.

Error Code: -2147023116

File: CHFMwManageApplications.cpp;Line: 212;Ver: 11.1.2.0.0.2762;

Additional errors in the Windows Event Viewer:

Error 11; SYSTEM;<Num>-2147220966</Num><Type>0</Type><File>CHsxClient.cpp</File><Line>2417</Line><Ver>11.1.2.0.0.2762</Ver><ExErr>Unknown Error</ExErr></ESec></EStr>

Error 11; SYSTEM; 09/05/2012 12:26:01; HsvADMDriverSessionInternal.cpp; Line 355; <?xml version="1.0"?>

<EStr><Num>-2147467261</Num><Type>0</Type><DTime>9/5/2012 12:26:01 PM</DTime><File>HsvADMDriverSessionInternal.cpp</File><Line>355</Line><Ver>11.1.2.0.0.2762</Ver></ESec></EStr>

Turns out that the HFM Web node had an issue that corrupted the Financial Management ADM Driver. 

I ran the installer, chose re-install, and selected the HFM ADM component. This resolved the errors. 

The Hyperion Config Tool list of database connections.

Here is a little insight into the list of database connections listed in the config tool. This much detail is not necessary in most cases, but it is good to have an understanding of how the information is stored. Also, this same information is stored in the Shared Services Registry, which provides a GUI to manipulate this information.

The list of databases available is stored in the Shared Services relational database, under the HSS_COMPONENT table. This table contains pretty much all the relationships in Shared Services including all the product metadata, so it is necessary to be more specific. To list only the database connections, limit the query use component_type_id 7.
    Select * from HSS_COMPONENT where COMPONENT_TYPE_ID=7;

This shows the list of database connections that are a 1 to 1 match with the config tool database connections above. To get more details regarding the database connections simply query the relational tables associated with the component_id:

select hss_component.component_name, hss_component_property_values.* FROM
    HSS_COMPONENT, HSS_COMPONENT_PROPERTY_VALUES  WHERE
    HSS_COMPONENT.component_type_id = 7 AND
    HSS_COMPONENT.component_id = hss_component_property_values.component_id;

This lists all the component properties of the database connections.

Here it is possible to view and manipulate any database related information directly from the underlying database connection. This is the same information that is stored in the Shared Services Registry which provides a GUI for manipulating this information.

This information can provide useful clues to help debug registry related errors and might be useful as an aid in manipulating database passwords providing the config tool is failing.