• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » adopmon and adopreports utility R12.2.5

adopmon and adopreports utility R12.2.5

June 18, 2016 by techgoeasy 2 Comments


adopmon utility in R12.2.5

R12.2.5 provides a  utility name adopmon to monitor the progress of adop session.The adopmon utility is useful both in following the overall progress of a patching cycle and identifying the various individual actions that are being taken.

The following example shows how adopmon is used, with some sample output from the finalize phase.
$ adopmon

Running script. Press Ctrl-C to quit.

Enter the APPS password:
Validating credentials…

2016/01/04 1:29:02 test          EVENT        Checking for existing adop sessions.
2016/01/04 1:29:02 test          EVENT        Checking for pending hotpatch session.
2016/01/04 1:29:02 test          EVENT        Checking for pending cleanup session.
……………………………………………………………….
………………………………………………………………..
2016/01/04 2:01:56 testsystem          EVENT        The finalize phase completed successfully.

adopreports utility in R12.2.5
Online Patching Diagnostic Reports utility, $AD_TOP/bin/adopreports, can be used to help diagnose issues or simply gather information about the status of your system.

The adopreports utility is invoked by entering the command:
$ adopreports <APPS username> <APPS password>

This displays the adopreports Main Menu:
Online Patching Diagnostic Reports Main Menu
——————————————–

1.  Run edition reports
2.  Patch edition reports
3.  Other generic reports
4.  Exit

Choosing option 1 from the Main Menu displays the Run Edition Reports Sub Menu:
Run Edition Reports Sub Menu
—————————-

1.  All
2.  Count of uncovered objects per edition
3.  List of uncovered objects per edition
4.  Cleanup status – summary of covered objects per edition,etc.
5.  Show covered objects count per edition.
6.  Show list of covered objects per edition.
7.  Back to main menu

Choosing option 2 from the Main Menu displays the Patch Edition Reports Sub Menu:
Patch Edition Reports Sub Menu
——————————

1.  All
2.  Patch status – new/changed objects
3.  Objects patch in the current edition
4.  Table manager status
5.  Back to main menu

Choosing option 3 from the Main Menu displays the Other Generic Reports Sub Menu:
Other Generic Reports Sub Menu
——————————

1.  Editions summary
2.  Editioned objects summary
3.  Free space in important tablespaces
4.  Status of critical AD_ZD objects
5.  Actual objects in current edition
6.  Objects dependencies
7.  Objects dependency tree
8.  Editioning views column mappings
9.  Index details for a table
10.  Inherited objects in the current edition
11.  All log messages
12.  Materialized view details
13.  Database sessions by edition
14.  Table details (Synonyms, EV, etc.)
15.  Count and status of DDL execution by phase
16.  Back to main menu


Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: adopmon and adopreports utility R12.2

Reader Interactions

Comments

  1. uday jampani says

    April 18, 2017 at 3:28 am

    I believe adopmon is introduced in AD/TXK 7;My ad/txk 5 env don’t have this.; both are 12.2.3

    Reply
    • techgoeasy says

      May 5, 2017 at 4:26 am

      adopmon is available from AD/TXK 7 only. When R12.2.5 was released ,AD/TXK 7 was also released and we are suppose to apply the latest AD/TXT patches for upgrade to R12.2.5

      Reply

Leave a Reply Cancel reply

Primary Sidebar

Top Posts & Pages

  • Oracle Indexes and types of indexes in oracle with example
  • Top 30 Most Useful Concurrent Manager Queries
  • Top 46 Oracle ASM Interview Questions
  • Oracle dba interview questions and answers
  • 40 question you must know about R12.2



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • EBS PDB service name disappear from listener in 19c
  • how to download oracle e-business suite 12.2 software
  • Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0)
  • Step by step upgrade process for R12.2 Upgrade Part -1
  • Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.x Release Update Pack)

Copyright © 2021 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us