Skip to main content

MOPatch failed in Oracle 12c

Detail in pdf.

Comments

  1. Satyam15 April 2017 at 08:18

    Thank you very much for sharing your valuable real time issues with detailed solution steps. It helps the people like me who are about to start upgrade activity on SNAP systems 11g to 12c.

    ReplyDelete
  2. Unknown16 April 2017 at 13:15

    Thanks for sharing. Really useful

    ReplyDelete
  3. Sonu30 April 2019 at 07:02

    Thank you so much Kanhaiya for such information will much help full for me and my team

    ReplyDelete
  4. Unknown1 November 2019 at 04:54

    thanks
    this saved my time

    ReplyDelete

Post a Comment

Popular posts from this blog

Alter System Checkpoint

Hello Techies, This happens most of the time that you need to add/drop redo log groups in Oracle databases due to any administrative reasons, however, if candidate redo group is in ACTIVE status, then you can't drop it and DBA need to wait until this comes in INACTIVE status to become this group available from drop. Here is the trick. Current status of redo log groups in my test database and you can see highlighted groups in ACTIVE status. In this situation, if DBA need to modify/drop these groups he/she need to wait until this comes in INACTIVE status. SQL> select * from v$log;     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME      NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------...
12 comments
Read more

Oracle OS Watcher - Start and generate html report

Hi Guys, OS Watcher is an excellent utility for system performance investigation. OSWatcher invokes these distinct operating system utilities, each as a distinct background process, as data collectors. These utilities will be supported, or their equivalents, as available for each supported target platform. ps top ifconfig mpstat iostat netstat traceroute vmstat meminfo (Linux Only) slabinfo (Linux Only) OSWatcher is java program and requires as a minimum java version 1.4.2 or higher. This can run on on any Unix/Windows. An X Windows environment is required because oswbba uses Oracle Chart builder which requires it. Make sure java path is set $which java $<java path>/java Following will take system snapshot in every 30 seconds and will log last 24 hours data to OS Watcher archive log files. $cd <OS watcher dir> $nohup ./startOSWbb.sh 30 24 gzip <OS Watcher file location> & Without compress $nohup ./s...
9 comments
Read more

Performance Hub Report

Hi Guys, In case you do not have Oracle Enterprise Manager or Grid Cloud Control and want to have almost similar features for Oracle monitoring purpose, Performance Hub Reports can help you up to a great extent. Performance Hub report helps to view all performance data available for a specified time period. Various tabs are available in the Performance Hub, depending on whether real-time or historical data is selected for the time period. When real-time data is selected, more granular data is presented, because real-time data for the last hour is displayed. When historical data is selected, more detailed data is presented, but the data points are averaged out to the Automatic Workload Repository (AWR) interval for the selected time period. To use the performance hub report, underlying Oracle must be at least 12c. Following is the way how to generate this report. 1.        At the SQL prompt, enter:         ...
1 comment
Read more