FAQ   OBIEE   Installation     
       
          A collection of bugs, boojums and Oracle oopsies!   

 

 

 

OC4J starts automatically on reboot after installation

 

Q: The OBIEE installation guide in the section on initialization states that OC4J cannot be restarted automatically, but it’s starting automatically after the reboot.  Have I done something wrong during the installation?

 

No you haven’t.  There’s a section in the installation wizard that asks you for the “Service Startup Type” for each of the OBIEE services.  If you accept the defaults the “Oracle BI Java Host” service will be set to “Automatic” (you can verify the setting by navigating to “Start => Control Panel => Administrative Tools => Services”).  With this setting the service will start automatically and you’ll see a command line window with output that begins with “Starting OC4J from ...\oc4j_bi\j2ee\home ...” and that ends, if successful, with “... Oracle Containers for J2EE 10g (10.1.3.1.0) initialized”.  After the reboot following the installation, OC4J should start up all by itself.  If not, then navigate to “Start => All Programs => Oracle Business Intelligence” and select “Start OC4J” or start the service from the Windows “Services” page.

 

 

Data source and logon for post-installation BI Client Test

 

Q: The postinstallation test for the Oracle BI Client says to navigate to Oracle Business Intelligence and select the ODBC Client.  But it doesn’t say what data source to log on to or how to logon?

 

Yes, it’s not very helpful.  Just bringing up the “Oracle BI ODBC Client” window doesn’t mean you can connect to the BI Server and query a data source. 

 

Now as part of the installation process an ODBC data source called “Analytics Web” is configured using the “Oracle BI Server” driver, and this data source points to the BI Server on port 9703.  This configuration allows any ODBC client to access the BI server directly, without involving any of the other OBIEE components – so you can access the BI Server using the simple “ODBC Client” tool from the “Oracle Business Intelligence” menu.  The configuration file “NQSConfig.INI” (in directory “\server\config”) that comes with the BI Server points to a default repository called “samplesales.rpd”, containing tables such as “Time” and “Customers”.  This data source is stored as an XML file in directory “\server\sample\samplesales”.  Because the XML file can be read without a network connection, attempting to access it provides a good test of whether or not the BI Server is working.

 

To confirm that the BI Server is working, from the “ODBC Client” window select “File => Open DataBase”.  In the pop-up window select “AnalyticsWeb” for DSN from the list of values.  Enter a value of “Administrator” for the “UID” and the “Password”.  You don’t need to enter a value for the “Database”.  Then press “OK” and you’ll be returned to the previous screen.

 

Select “Utility => View Schema” from the menu.  If everything is working correctly you should see the “Time” and “Customers” tables in the “DataBase Tables” pop-up (you can select a table and then drill down to columns and attributes if you like).  Close the window.  Select “Utility => Enter SQL Query” from the menu.  Enter, say, “select * from customers” into the pop-up window and press “Execute”.  A second window will pop-up showing the rows in the “Customers” table.  Close both windows and then select “File => Close” from the menu to close the data source.  Finally select “File => Exit” from the menu to exit the “ODBC Client”.

 

 

Configuring BI Scheduler with Oracle 11g database

 

Q: I’m using the Job Manager to configure the BI Scheduler with an 11g database, but the Database Type LOV in the Connection Pool settings doesn’t support 11g?

 

In the other components of OBIEE you’ll find LOVs with values like “Oracle 10g R2/11g”, but Oracle seems to have forgotten to update this setting in the case of the Job Manager.  Select “Oracle 10g R2” from the list of values and use that instead.  The corresponding call interface will also work with 11g.