Category: Oracle Database

Change/Update EPM/Hyperion Shared Services Database Server

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...

Create Oracle DB user for Qualys Scanner

[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...

EPM Hyperion Workspace Repository Items SQL

[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...

Exporting Security Out of Hyperion Planning Application via Oracle Database Repository

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...

Oracle Database: Remove old archive files from RMAN

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;...

Oracle Database: flash_recovery_area full?

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]...
(adsbygoogle = window.adsbygoogle || []).push({});