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\11.2.0.3\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

Oracle Workflow ORA-24247

If you see the following errors:

ORA-24247:Network access denied by access control list(ACL) ORA-06512 at......

 

ORA-29532 when starting OWB Service

Run $ORACLE_HOME/owb/rtp/sql/start_service.sql with OWBSYS user.

If you have the following error:

Not Available

Diagnostics:

service startup failure using command "$ORACLE_HOME/owb/b

in/unix/run_service.sh -manual 1 $ORACLE_HOME OWBSYS 10.8

4.80.186:1521:bidev" reason ORA-29532: Java call terminated by uncaught Java ex

ception: java.io.IOException: service early exit: code=1 : err=JVMJ9VM015W Init

ialization error for library j9gc23(2): Failed to instantiate heap; 768M reques

ted

Could not create the Java virtual machine.

: out=

please invoke [owbhome]/owb/rtp/sql/service_doctor.sql for more information

PL/SQL procedure successfully completed.

[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/libnqsdbgatewayoci10g64.so. 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/user.sh:

ORACLE_HOME=/orasw/app/oracle/product/11.2.0.3
export ORACLE_HOME
TNS_ADMIN=/orasw/app/oracle/product/11.2.0.3/network/admin
export TNS_ADMIN
PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
export PATH
LIBPATH=$ORACLE_HOME/lib:$LIBPATH:/opt/j2se/jre/lib/sparc
export LIBPATH

OBIEE Catalog Manager Cannot be launched

When getting Java error from OBIEE Catalog Manager lauching:

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

-Xmx1440M
Change to-Xmx512M

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”

gather_system_stats

SQL> exec dbms_stats.gather_system_stats (gathering_mode => 'noworkload');

PL/SQL procedure successfully completed.

SQL> select sname, pname, pval1 from sys.aux_stats$;