Mapping Groups in Active Directory to Oracle OBIEE and Weblogic

Mapping Groups in Active Directory to Weblogic
http://www.rittmanmead.com/2012/03/obiee-11g-security-week-connecting-to-active-directory-and-obtaining-group-membership-from-database-tables/

Oracle OBIEE 11.1.1.6 Start/Stop

To start and stop the Oracle OBIEE server do the following:


Start the NodeManager -
<MW_HOME>/wlserver_10.3/server/bin/startNodeManager.sh
Stop the NodeManager
Use WLST Scripting Tool
MW_HOME/Oracle_BI1/common/bin/wlst.sh
wls:/nm/base_domain> stopNodeManager()
Stopped Node Manager Process successfully
wls:/offline>exit()
Or kill -9 <nodemanager pid>

Start the Administration Server -
MW_HOME/user_projects/domains/bifoundation_domain/bin/startWebLogic.sh
Stop the Administration Server -
MW_HOME/user_projects/domains/bifoundation_domain/bin/stopWebLogic.sh

Start the Managed Server -
MW_HOME/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.sh bi_server1 http://<admin_server>:7001
or via EM or via WLST Scripting tool
Stop the Managed Server -
MW_HOME/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.sh bi_server1 http://<admin_server>:7001
or EM or WLST

Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition
http://docs.oracle.com/cd/E28271_01/bi.1111/e10541.pdf

Oracle 11gR2 Audit Trail Cleanup scripts

Initialise the Cleanup -
Do this once.
Watch out for tablespace problems in SYSAUX tablespace. Even if SYSAUX has auto extend ON

BEGIN
DBMS_AUDIT_MGMT.INIT_CLEANUP(
AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
DEFAULT_CLEANUP_INTERVAL => 12 );
END;
/

Set a clean_up batch size

BEGIN
DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_PROPERTY(
AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
AUDIT_TRAIL_PROPERTY => DBMS_AUDIT_MGMT.DB_DELETE_BATCH_SIZE,
AUDIT_TRAIL_PROPERTY_VALUE => 100000);
END;
/

Run a manual audit trail cleanup
BEGIN
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
USE_LAST_ARCH_TIMESTAMP => TRUE );
END;
/

Schedule a purge job

BEGIN
DBMS_AUDIT_MGMT.CREATE_PURGE_JOB (
AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
AUDIT_TRAIL_PURGE_INTERVAL => 12,
AUDIT_TRAIL_PURGE_NAME => 'Standard_Audit_Trail_PJ',
USE_LAST_ARCH_TIMESTAMP => TRUE );
END;
/

purge interval is in hours

Oracle 11gR2 Disabling Fast Recovery Area (FRA)

Disabling the Fast Recovery Area

If Flashback Database is enabled, then disable it before you disable the fast recovery area.
ALTER DATABASE FLASHBACK OFF;
If you are using fast recovery area for archive logs, then set the initialization parameter LOG_ARCHIVE_DEST_n to use a non-fast recovery area location.
eg.
LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/ORACLE/DBS/';

Disable the fast recovery area initialization parameter.
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='';

(From Oracle Database Backup and Recovery User's Guide)

Oracle ORA-00904 "ORA_ROWSCN": invalid identifier

Oracle ORA-00904 "ORA_ROWSCN": invalid identifier occurs when querying a table with Fine Grained Auditing (FGA) Policy defined using sqldeveloper.

The fix is to go to preferences -> database -> Object Viewer and deselect the checkbox for use ROWSCN