Log into Enterprise manager to view what's going on

http://localhost:7001/em

I noticed that all the services were up and running through not specifically bi publisher. Turns out that once I looked at the logs, it was stating that the repository was not configured when I installed the software (pretty sure there wasn't a step!)

The following issue:

java.lang.RuntimeException: oracle.xdo.servlet.CreateException: Failed to retrieve a Config Provider. Make sure that your repository is correctly setup
at oracle.xdo.servlet.security.SecurityHandler.getHandler(SecurityHandler.java:188)
at oracle.xdo.servlet.ui.NLSUtils.getSSOLocale(NLSUtils.java:608)
Truncated. see log file for complete stacktrace
Caused By: oracle.xdo.servlet.CreateException: Failed to retrieve a Config Provider. Make sure that your repository is correctly setup
at oracle.xdo.servlet.ReportException.fillInStackTrace(ReportException.java:124)
at java.lang.Throwable.(Throwable.java:196)
at java.lang.Exception.(Exception.java:41)

In order to get around this, you need to declare the ORACLE_INSTANCE environment variable. You can either set it within the terminal window, though below is where I included this within the .bash_profile file located within the /home/oracle directory.

vi /home/oracle/.bash_profile

Make and save the changes then save the file. You will also need to run the .bash_profile by entering in the following command

. /home/oracle/.bash_profile

Note: You can test this has worked by entering in the echo $ORACLE_INSTANCE value within the terminal window.

Restart everything apart from the oracle database as stated here.

Now log into enterprise manager

http://localhost:7001/em

You should now be able to see the service has now started. You should now be presented to the bi publisher login screen

About the author