Tuesday, July 19, 2016

After applying the 11.1.2.3.500 EPM System Patch Set Update (PSU): 17529887 which is a combined EPM patch that includes Planning 11.1.2.3.500,

Issues Using Hyperion Planning after Applying EPM System Patch Set Update (PSU) 11.1.2.3.500 (Doc ID 1640411.1) To BottomTo Bottom In this Document Symptoms Cause Solution References APPLIES TO: Hyperion Planning - Version 11.1.2.3.000 and later Information in this document applies to any platform. SYMPTOMS After applying the 11.1.2.3.500 EPM System Patch Set Update (PSU): 17529887 which is a combined EPM patch that includes Planning 11.1.2.3.500, the following issues have been observered: Planning cannot be accessed via Workspace and the following error is found in the Planning0.log file: <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1402564062723>

Friday, July 15, 2016

not able to delete oci.dll

Download process explorer from MSDN. Find what has a lock on oci.dll (probably Distributed Transaction Coordinator). Stop the service. Delete the file. http://technet.microsoft.com/en-us/sysinte...s/bb896653.aspx svchost will be holding oci.dll

Thursday, July 14, 2016

Perform a Clean Uninstall of EPM 11.1.2 on Microsoft Windows (Doc ID 1140553.1)

Perform a Clean Uninstall of EPM 11.1.2 on Microsoft Windows (Doc ID 1140553.1) /dhyp01/hyperion/Oracle/Middleware/wlserver_10.3/uninstall/uninstall.sh /dhyp01/hyperion/Oracle/Middleware/EPMSystem11R1/uninstall/uninstall.sh /dhyp01/hyperion/Oracle/Middleware/utils/uninstall/uninstall.sh How to Uninstall Hyperion Enterprise Performance Management (EPM) (Doc ID 1265740.1) To BottomTo Bottom In this Document Goal Solution References APPLIES TO: Hyperion Planning - Version 11.1.1.0.00 to 11.1.2.0.00 [Release 11.1] Information in this document applies to any platform. *may 18,2015* GOAL To completely uninstall Hyperion Enterprise Performance Management System SOLUTION On a Windows system: 1). Using the same user that installed EPM, uninstall the EPM suite by double clicking the 'uninstall.cmd' located in the %HYPERION_HOME%\uninstall folder. 2). Reboot the server (to remove the Windows 'Services') 3). Delete the %HYPERION_HOME% folder (and all it's sub-folders) 4). Open up the Windows registry with 'regedit' and delete the 'Hyperion Solutions' key under \\HKEY_LOCAL_MACHINE\SOFTWARE 5). In the registry, navigate to \\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services. There shouldn't be any services (see 2) prefixed 'HyS9', if there are then delete them. 6). Navigate to %DRIVE%\Documents and Settings\ and delete files '.oracle.products' and 'set_hyphome_1.bat' 7) Navigate to C:\Program Files\Common Files\InstallShield\Universal\common and delete the two folders 'Gen1' and 'oracle' 8). Right-click on 'My Computer' -> 'Properties' -> 'Advanced' -> 'Environment Variables' and remove the %HYPERION_HOME% variable and any Hyperion products on %PATH%. 9). Reboot - the server should now be in a state fit for an EPM re-installation. On a UNIX system: 1). Using the same user that installed EPM, uninstall the EPM suite by double clicking the 'uninstall.sh' located in the $HYPERION_HOME/uninstall directory. 2). Delete the $HYPERION_HOME directory and it's sub-directories. 3) Navigate to the $HOME directory of the user that installed Hyperion EPM and delete the files '.oracle..products' and '.hyperion.' Please see Note 1140553.1 for additional information pertinent to version 11.1.2. REFERENCES NOTE:1140553.1 - Perform a Clean Uninstall of EPM 11.1.2 on Microsoft Windows

Perform a Clean Uninstall of EPM 11.1.2 on Microsoft Windows (Doc ID 1140553.1)

Perform a Clean Uninstall of EPM 11.1.2 on Microsoft Windows (Doc ID 1140553.1) How to Uninstall Hyperion Enterprise Performance Management (EPM) (Doc ID 1265740.1) To BottomTo Bottom In this Document Goal Solution References APPLIES TO: Hyperion Planning - Version 11.1.1.0.00 to 11.1.2.0.00 [Release 11.1] Information in this document applies to any platform. *may 18,2015* GOAL To completely uninstall Hyperion Enterprise Performance Management System SOLUTION On a Windows system: 1). Using the same user that installed EPM, uninstall the EPM suite by double clicking the 'uninstall.cmd' located in the %HYPERION_HOME%\uninstall folder. 2). Reboot the server (to remove the Windows 'Services') 3). Delete the %HYPERION_HOME% folder (and all it's sub-folders) 4). Open up the Windows registry with 'regedit' and delete the 'Hyperion Solutions' key under \\HKEY_LOCAL_MACHINE\SOFTWARE 5). In the registry, navigate to \\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services. There shouldn't be any services (see 2) prefixed 'HyS9', if there are then delete them. 6). Navigate to %DRIVE%\Documents and Settings\ and delete files '.oracle.products' and 'set_hyphome_1.bat' 7) Navigate to C:\Program Files\Common Files\InstallShield\Universal\common and delete the two folders 'Gen1' and 'oracle' 8). Right-click on 'My Computer' -> 'Properties' -> 'Advanced' -> 'Environment Variables' and remove the %HYPERION_HOME% variable and any Hyperion products on %PATH%. 9). Reboot - the server should now be in a state fit for an EPM re-installation. On a UNIX system: 1). Using the same user that installed EPM, uninstall the EPM suite by double clicking the 'uninstall.sh' located in the $HYPERION_HOME/uninstall directory. 2). Delete the $HYPERION_HOME directory and it's sub-directories. 3) Navigate to the $HOME directory of the user that installed Hyperion EPM and delete the files '.oracle..products' and '.hyperion.' Please see Note 1140553.1 for additional information pertinent to version 11.1.2. REFERENCES NOTE:1140553.1 - Perform a Clean Uninstall of EPM 11.1.2 on Microsoft Windows

Tuesday, June 14, 2016

How to Integrate OAM 11g R2 with EBS, OID and AD for WNA? (Doc ID 1900610.1)

There is no documentation on how to setup WNA with OAM and EBS. This setup is possible. Although this setup has not been certified by Oracle "as a whole", the product combinations of OAM/AD and EBS/OID have been. First, there are 2 mutually exclusive conditions from documentation: 1. AD is required as OAM User Store for WNA to work (http://docs.oracle.com/cd/E14571_01/doc.1111/e15740/wna.htm#sthref190) 2. For EBS Integration, OAM User Store must be OID (Doc ID 1309013.1) One way to make it work is: - configure OAM to use AD as a data store - configure EBS to use OID - configure Directory Integration Platform (DIP) to sync the users from AD to OID High level steps based on the 2 EBS+OAM docs (v.11i: DocID 1536941.1, v.12: DocID 1484024.1): a) Install OID latest version, please check certification matrix, it should be OID 11gR1, you can also patch OID if there are any available at this point. Note: It was recommended to backup OID as a stage gate right after installing it, so that you can restore it in a clean state if anything bad occurs. b) Register EBS with OID by following this document: Registering Oracle E-Business Suite Release 12 with Oracle Internet Directory 11gR1 and Single Sign-On (Doc ID 1370938.1) c) Integrate AD with OID using Directory Integration Platform (DIP) d) Install Oracle Access Manager 11gR2 - again use latest software (please note that OID and OAM schema goes in same database, so please use RCA 11gR1 for OID and 11gR2 for OAM). e) Integrate OAM with EBS (Doc ID 1309013.1) f) Configure OAM g) Configure WNA (For fallback, password authentication was configured from Microsoft AD using OID Java external authentication plugin). h) Configure SSL

Thursday, June 9, 2016

ORACLE AUDIT VAULT COMMAND LINE INTERFACE

http://www.oradba.ch/2013/10/avcli-audit-vault-command-line-interface/ https://docs.oracle.com/cd/E37100_01/doc.121/e27776/avcli_commands.htm#SIGAD40583 https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=440106422415516&id=1536380.1&_afrWindowMode=0&_adf.ctrl-state=13ftapd6u8_133

Sunday, May 1, 2016

OBIA 11.1.1.10.1 Installation Road Map

Activity
Install Windows 2008 R2
Install and Configure Oracle DB 12c  (12.1.0.2)
RCU for OBIEE 11.1.1.9.0
RCU for OBIA 11.1.1.10.1
WLS install 10.3.6
ODI install 11.1.1.9.0
s/w only Install BI Tech (OBIEE - EE mode)
s/w only Install BIApps (OBIA)
Apply FMW Patches (through APPLY_PATCH.pl)
Apply OPMN Patches (21811403)
Apply OWSM Patches (19294475)
Apply WLS patches
Upgrade schema - ATG
Upgrade schema - BIACM
Upgrade schema - FSM
config.bat (OBIEE Config)
configApps.bat (OBIA Config)
Load Plan Generator Plug-In      
Setup Repository Connection in ODI Studio        
Changing the ETL Location