Sunday, 29 April 2018

OBIEE Variables overview

Below screen shot shows the overview of OBIEE variables.

OBIEE Start services Error -- Server state changed to FORCE_SHUTTING_DOWN

weblogic server is not starting up and giving the below error 

Error :-

#Aug 18, 2014 12:34:29 AM PDT# #Notice# #WebLogicServer# #BEA-000365# #Server state changed to STARTING#
#Aug 18, 2014 12:34:29 AM PDT# #Info# #WorkManager# #BEA-002900# #Initializing self-tuning thread pool#
#Aug 18, 2014 12:34:29 AM PDT# #Notice# #Log Management# #BEA-170019# #The server log file /u01/app/oracle/config/domains/Vinay/servers/AdminServer/logs/AdminServer.log is opened. All server side log events will be written to this file.#
#Aug 18, 2014 12:34:29 AM PDT# #Critical# #WebLogicServer# #BEA-000386# #Server subsystem failed. Reason: java.lang.AssertionError: Could not obtain the localhost address. The most likely cause is an error in the network configuration of this machine.
java.lang.AssertionError: Could not obtain the localhost address. The most likely cause is an error in the network configuration of this machine.
                at weblogic.server.channels.AddressUtils$AddressMaker.getLocalHost(
                at weblogic.server.channels.AddressUtils$AddressMaker.#clinit#(
                at weblogic.server.channels.AddressUtils.getIPAny(
                at weblogic.protocol.configuration.ChannelHelper.checkConsistency(
                at weblogic.server.channels.ChannelService.start(
                Truncated. see log file for complete stacktrace
Caused By: pocsrv2: pocsrv2
                at weblogic.server.channels.AddressUtils$AddressMaker.getLocalHost(
                at weblogic.server.channels.AddressUtils$AddressMaker.#clinit#(
                at weblogic.server.channels.AddressUtils.getIPAny(
                at weblogic.protocol.configuration.ChannelHelper.checkConsistency(
                Truncated. see log file for complete stacktrace
#Aug 18, 2014 12:34:30 AM PDT# #Notice# #WebLogicServer# #BEA-000365# #Server state changed to FAILED#
#Aug 18, 2014 12:34:30 AM PDT# #Error# #WebLogicServer# #BEA-000383# #A critical service failed. The server will shut itself down#
#Aug 18, 2014 12:34:30 AM PDT# #Notice# #WebLogicServer# #BEA-000365# #Server state changed to FORCE_SHUTTING_DOWN#

Solution :-

In Windows:

Add the hostname in the /etc/hosts file. If you are specifying the IP address in the config.xml then try with the hostname instead eg., also specify this in the /etc/hosts file.

In Linux:
 1) Update the hostname value  for root user by using the following command:
export $HOSTNAME

2) After these changes the env variable for root user is modified to the correct hostname value as shown below:                    
SSH_CLIENT= 1401 22

OBIEE 11g Error: 500 Internal Server Error

If you are getting the error following error 

Error 500--Internal Server Error 
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

FMW_SECURITY_SERVICES_URL in NQSConfig.ini has wrong IP. checking log file its noticed that this parameter has invalid IP which caused the after updating with correct IP address its got working fine so this is permanent solution.

Below screen short shows the FMW_SECURITY_SERVICES_URL in NQSConfig.ini file.

Try to update your static IP address like below screen,

Then try to re - start your bi services then Error: 500 Internal Server Error won't come again.

Monday, 12 March 2018

File Locations for Oracle BI 12c

BI Tools (e.g.,,,

TNSNAMES file (to configure Oracle db connections):

Weblogic scripting tool (

Log files (for BI system and weblogic servers):

BI Catalog:

Live RPD:

NOTE: You need to use to download the live RPD

Weblogic configuration:

FMW Configuration:

BI System configuration (instanceconfg.xml, NQSConfig.xml etc):


Presentation Services configuration: .../biconfig/OBIPS/instanceconfig.xml
BI Server configuration: .../biconfig/OBIS/NQSConfig.INI

BI Publisher Configuration:

Tuesday, 19 January 2016

weblogic admin account creation : OBIEE 11g

When you lost the weblogic account or security files are corrupted then create a new admin account (web logic) using following commands as shown below


don't forgot to give ( . )  at the end with space after the password

If you get below error while creating admin account set the path using 

Error: Could not find or load main class


Editing a report on Criteria tab instead of Results tab in OBIEE

By default when you click on Edit report, your OBIEE Answers opens it on the Results tab. Apply the account settings to navigate directly to the Criteria tab when editing.

  • Go to top right corner of the screen and click on My Account:


  •       In Preferences tab change Analysis Editor setting to Start on Criteria tab when editing Analysis and click OK.

Tuesday, 26 November 2013

Direct Links to various OBIEE User and Administration Presentation functions

These are some direct links to various OBIEE User and Administration functions.  These can be useful to know for efficiency and at times can also be useful for debugging security.

To go directly to “Home Page”

To go directly to “Dashboard”

To go directly to “Manage Privileges”

To go directly to “Manage Catalog Groups”

To go directly to “Manage Sessions”

To go directly to “Manage Agent Sessions”

To go directly to “Issue SQL”

To go directly to “Manage Map Data”

To go directly to “Manage BI Publisher”