Detailed Description: The compile_invalid_objects.sh script is designed to automate the identification and compilation of invalid objects across pluggable databases (PDBs) within an Oracle multitenant database environment. Invalid objects—such as packages,…
Read MoreDetailed Description: This Bash script automates the enumeration and dynamic selection of Pluggable Databases (PDBs) in an Oracle Multitenant environment. It connects to the Oracle Container Database (CDB) as a…
Read MoreData Recovery Advisor feature helps in diagnosing and repairing data failures. It will automatically diagnose the issue and provides the recommendation for the repair that helps to resolve the data…
Read MoreWhat is a Redo log corruption? In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Each redo log file consists…
Read MoreIntroduction : Oracle database automated backups are stored in Oracle Managed Object Store Buckets in OCI. This blog covers step by step process to download the database backup from OCI…
Read MoreIntroduction : Oracle database automated backups are stored in Oracle Managed Object Store Buckets in OCI. This blog covers step by step process to Upload the database backup files from…
Read MoreSteps to upgrade the latest JDK in OEM agent : 1. Check JDK Version. Go to OEM agent location and check the java version. cd /u01/app/oracle/product/agent13c/agent_13.5.0.0.0/jdk/bin ./java -version 4. Upgrade…
Read MoreSteps to upgrade the latest OEM Agent Release update 1. Install the latest AgentPatcher Download the latest Agentpatcher from oracle support. cd <Patch location> cp p33355570_135000_Generic.zip /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 cd /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 unzip…
Read MoreIncrease the report server engine to run multiple reports in parallel. Take a backup of rwsever.conf file cd $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/repserv1 cp -rp rwserver.conf rwserver.conf_bck Change the maxEngine value from 1 to…
Read MoreFor the mail server configuration in 12c reports, need to the update the rwserver.conf files with mail server credentials. cd $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/repserv1 Edit the rwserver.conf and update the below, From :…
Read More