Category: Oracle Database

Change/Update EPM/Hyperion Shared Services Database Server

By March 22, 2020 HFM, HFM 11.1.2.2, Hyperion Planning, Hyperion Planning 11.1.2.2, Oracle Database, Oracle Database 11g, Oracle Database 12c, Oracle Hyperion 9.3.1, Oracle Hyperion EPM 11.1.1.3, Oracle Hyperion EPM 11.1.2.1, Oracle Hyperion EPM 11.1.2.2, Oracle Hyperion EPM 11.1.2.3, Oracle Hyperion EPM 11.1.2.4, Planning, RHEL7, Uncategorized, Weblogic, Windows Server 2008 R2, Windows Server 2012 R2 0 Comments
Change/Update EPM/Hyperion Shared Services Database Server STEP 0: Stop ALL EPM Components STEP 1: Migrated Databases and all objects from previous database server to the new database server. STEP 2: Execute Configtool on each server to reconfigure the Shared Services/Foundation database...
[Continue reading...]

Create Oracle DB user for Qualys Scanner

By October 24, 2016 Oracle Database, Oracle Database 11g, Oracle Database 12c, Qualys, Red Hat Enterprise Linux 5 (RHEL5), Red Hat Enterprise Linux 6, Red Hat Enterprise Linux 7 0 Comments
[ad#ad-post] Create User: CREATE PROFILE "QUALYS_PROFILE" LIMIT FAILED_LOGIN_ATTEMPTS 3 PASSWORD_GRACE_TIME 10 PASSWORD_REUSE_TIME UNLIMITED PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_MAX 1; CREATE USER "QUALYS_SCAN" PROFILE "QUALYS_PROFILE" IDENTIFIED BY "<QUALYS_PASSWORD>" DEFAULT TABLESPACE "USERS" ACCOUNT UNLOCK; CREATE ROLE "QUALYS_ROLE"; GRANT "QUALYS_ROLE" TO "QUALYS_SCAN"; CREATE OR REPLACE VIEW...
[Continue reading...]

EPM Hyperion Workspace Repository Items SQL

By May 21, 2014 Essbase 11.1.2, Essbase 11.1.2.2, Essbase 9.3, HFM, HFM 11.1.2.2, Hyperion Planning, Hyperion Planning 11.1.2.2, Oracle Database, Oracle Financial Reporting, Oracle Hyperion 9.3.1, Oracle Hyperion EPM 11.1.1.3, Oracle Hyperion EPM 11.1.2.1, Oracle Hyperion EPM 11.1.2.2 3 Comments
[ad#ad-post] I had the need to look up all Financial Reporting documents in workspace. I compiled the following list of SQL commands to run against the Oracle database repository. The last command is the winner. http://hyperion-consulting.blogspot.com/2011/09/in-which-tables-reporting-objects-are.html http://hyperion-consulting.blogspot.com/2011/09/in-which-tables-reporting-objects-are.html (posted by Thigulla Krishna) Financial...
[Continue reading...]

Exporting Security Out of Hyperion Planning Application via Oracle Database Repository

By March 21, 2014 Essbase 11.1.2, Essbase 11.1.2.2, Hyperion Planning, Hyperion Planning 11.1.2.2, Oracle Database, Oracle Hyperion EPM 11.1.2.1, Oracle Hyperion EPM 11.1.2.2, Planning 0 Comments
I found the below article after hours of searching for a solution for us. I hope this helps others.   EPM 11.1.2 – Exporting Security out of Hyperion Planning application By Ruben Verghese on Sep 03, 2011 copied from https://blogs.oracle.com/pa/entry/exporting_security_out_of_hyperion You...
[Continue reading...]

Oracle Database: Remove old archive files from RMAN

By October 24, 2012 Oracle Database, Red Hat Enterprise Linux 5 (RHEL5), Red Hat Enterprise Linux 6, RMAN 0 Comments
rman target / CROSSCHECK BACKUP; CROSSCHECK COPY; CROSSCHECK ARCHIVELOG; DELETE EXPIRED BACKUP; DELETE EXPIRED COPY; DELETE EXPIRED ARCHIVELOG; RMAN> report obsolete; RMAN> delete obsolete; recent commands: delete archivelog all completed before 'sysdate -1'; backup archivelog all; crosscheck backupset; crosscheck archivelog all;...
[Continue reading...]

Oracle Database: flash_recovery_area full?

By October 24, 2012 Oracle Database, RMAN, Uncategorized 0 Comments
SELECT NAME, TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT, TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999') AS SPACE_AVAILABLE, ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST; Resize flash_recovery_area: SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 180G; [ad#ad-post]...
[Continue reading...]