Oracle Application DBA

How to Recreate Oracle Enterprise Manager - Database Control Repository Applies to:             Enterprise Linux – Version: 5             Oracle Database 11gR1             Oracle EBS R12.1 Description:             After Cloning of EBS, Oracle Enterprise Manager is not started. Solution:             To recreate the Database Control Repository do the following simple steps:                         Make sure that the Database environment is properly set.             To check ORACLE_HOME and ORACLE_SID values properly set:                          [oraprod@ebsdev ~]$  echo $ORACLE_HOME              /d01/oracle/TEST/db/tech_st/11.1.0              [oraprod@ebsdev ~]$  echo $ORACLE_SID             TEST              [oraprod@ebsdev ~]$  sqlplus / as sysdba SQL> drop user sysman cascade; SQL> drop role mgmt_user; SQL> drop user mgmt_view cascade; SQL> drop public synonym mgmt_target_blackouts; SQL> drop public synonym setemv

Error Message PRVF-7532 Missing Packages elfutils-libelf-devel and pdksh Applies to:             Oracle Enterprise Linux – Version: 7 64-bit             Oracle Database 11gR2 11.2.0.4 Description:             I am going to install Oracle Database 11gR2 on OEL-7 64-bit but Oracle Universal Installer going to fail with following error messages in installAction.log file: Error Message: PRVF-7532: Package “elfutils-libelf-devel” is missing Error Message: PRVF-7532: Package “pdksh” is missing Solution:             You can resolved the above issue by following simple steps: ·          Copy the Oracle Database source media from DVD to local Disk <path>/database ·          Go to the path: cd <path>/database/stage/cvu/cv/admin ·          Backup cvu_config file: cp cvu_config cvu_config_bak ·          Edit the cvu_config file and change the following line: CV_ASSUME_DISTID=OEL4 To CV_ASSUME_DISTID=OEL6 ·          Save the cvu_config file