Category: Oracle Database 11g

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

Reset the SYSMAN password in OEM12c/13c

By October 24, 2016 Oracle Database 11g, Oracle Database 12c, Oracle Enterprise Manager 12c (OMS12c), Oracle Enterprise Manager 13c 0 Comments
[ad#ad-post] Stop all the OMS $OMS_HOME/bin/emctl stop oms Modify the SYSMAN password $OMS_HOME/bin/emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <sys pwd> -new_pwd <new sysman pwd> Re-start all the OMS $OMS_HOME/bin/emctl stop oms -all $OMS_HOME/bin/emctl start oms [ad#ad-post]...
[Continue reading...]