Showing posts with label OBIEE. Show all posts
Showing posts with label OBIEE. Show all posts

Monday, December 17, 2012

AIX - a sample script to start/stop OBIEE

# Check passed parameters
if [ $# -ne 2 ]
  echo "Please provide parameters"
  echo "Parameter 1 - Domain"
  echo "Parameter 2 - start or stop"

Tuesday, April 17, 2012

Cannot connect to database from OBIEE 2.4 BI Admin Tool

If you have connection issue, modify bi_init.bat under BI install folder\oraclebi\orahome\bifoundation\server\bin, replace all ORACLE_HOME to OBIEE_HOME, and add new ORACLE_HOME for the actual oracle installation path:
@echo off
set OBIEE_HOME=C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome
set ORACLE_HOME=D:\oracle\product\\owb
set ORACLE_INSTANCE=C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst
set ORACLE_BI_APPLICATION=coreapplication
rem call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\%ORACLE_BI_APPLICATION%\setup\user.cmd
if NOT "%1" == "" set COMPONENT_NAME=%1
set PATH=%OBIEE_HOME%\bifoundation\server\bin;%OBIEE_HOME%\bifoundation\web\bin;%OBIEE_HOME%\bin;C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\jre\bin;%ORACLE_HOME\bin%;%windir%;%windir%\system32;%PATH%
if NOT "%2" == "" %2
[nQSError: 46029] for OBIEE 2.3.2

If OBIEE is unabled to be started because of Error: [nQSError: 46029] Failed to load the DLL $BIHOME/server/Bin64/ Check if 'Oracle OCI 10G' database client is installed.
  • Make sure export LD_LIBRARY_PATH=$ORACLE_HOME/lib/ and export SHLIB_PATH=$ORACLE_HOME/lib is in the profile.
  • Also make changes in $BIHOME/setup/
export TNS_ADMIN
export PATH
export LIBPATH
OBIEE Catalog Manager Cannot be launched

When getting Java error from OBIEE Catalog Manager lauching:

Modify C:\OracleBI\web\catalogmanager\catalogmanager.ini:
Change to

Purging Cache via OBIEE analytics page

  1. Log into OBIEE using an Admin account (as weblogic)
  2. a) Go to Administration Page –
  1. Select “Issue SQL” under “Maintenance and Trouble Shooting”