This document describes in detail the Steps for Reinstalling Oracle Enterprise Manager Cloud Control Agent 12c using Silent methods and the graphical method to add targets.Check the complete post here: http://www.oracle-class.comSee More
Introduction:Oracle defines the ORA-7445 as an unhandled exception error that could be result of an Oracle bug. The ORA-7445 errors depend on the version of the Oracle software, OS version. For more details about the error, you need to check the trace files generated. The ORA-7445 exception generates a trace file located under the CORE_DUMP_DEST directory for oracle versions prior to 11g and under the ADR Home / cdump (Automatic Diagnostic Repository) for 11g versions. This article is not…See More
Problem:We realized Oracle RMAN Backups to Tape for small and big databases are waiting for days and showing running status in V$RMAN_BACKUP_JOB_DETAILS. RMAN backup job logs are stopped to show tape channels allocation which indicates tape backup issue not disk.Troubleshoot the issue:Oracle provides a diagnostic tool named “sbttest”. This utlity test media management software by attempting to communicate with the media manager just like the Oracle Database.Read the complete post here:…See More
Introduction:This article describes how to export / import table statistics from one user to another. The goal is to import table statistics of the user wissem to a user wiss. The table conserned is named W_WRKFC_EVT_FS. Both users are in the same database. In the case of the users are created in different databases, the same steps can be used by using export/import datapump instead of create the table statistics using CTAS (Create Table As Select).Please find the complete article here:…See More
Introduction:This article describes how to manage optimal SQL execution plans using SQL plan management. SQL plan management preserves efficient execution plans and evaluates every changed plan. Plan changes can be due to the system change (Database upgrade, changes in database parameters, changes in optimizer parameters, changes in optimizer statistics, system configuration, etc …). SQL plan management (SPM) is a proactive way to guarantee stable performance when system changes.This article…See More
January 28, 2011 at 6pm to January 31, 2013 at 7pm
Hello,I am happy to announce you that I just finished my new website: http://www.oracle-class.comFeel free to visit and find a variety of useful Oracle resources such as:Video Tutorials on topics such as general database administration in 10g and 11g, RMAN backup and recovery,database performance, dataguard, Real Application Clusters, PL SQL programming, Oracle Certifications (OCA and OCP), Secure Oracle databases.Articles on various…See More
I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.