Category: Oracle Database 12c

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

Oracle Database 12c Client/Driver installation on Windows 7 or Windows 10

Installation of Oracle 12c Client Software Download the Oracle Client from oracle.com Launch the installation by running the .\winx64_12102_client\client after extracting the zip file Choose Administrator and click Next. Choose English and click Next. Choose Use Windows Built-in Account and click Next. Set the Oracle Base to...

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

Reset the SYSMAN password in OEM12c/13c

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