Useful Scripts related to Editioned Database in Oracle Apps

There are a number of SQL*Plus scripts that can provide useful information about the state of your editioned database environment. All ADZD* scripts are found under $AD_TOP/sql.

ADZDDBCC - the database compliance checker, shows violations of the database object development standards. Warning: this script takes a long time to run.

ADZDSHOWED - Show database editions and current editions.

ADZDSHOWLOG - Show full diagnostic log for online patching infrastructure.

ADZDSHOWLOGEVT - Show only event and error messages from the online patching diagnostic log (a useful summary, without the detailed statement text).

ADZDSHOWLOGERR - Show only error messages from online patching diagnostic log.

ADZDSHOWEV TABLE_SYNONYM_NAME - Show editioning view column mapping for the table.

ADZDSHOWTAB TABLE_SYNONYM_NAME - Show table information and related objects.

ADZDSHOWMV MVIEW_NAME - Show materialized view information and related objects.

ADZDSHOWTS - Show important tablespace status. Ensure that you have enough SYSTEM tablespace.

ADZDCMPED - Compare Patch Edition with Run Edition. Warning: this script may take a long time to run.

ADZDSHOWDDLS - Show stored DDL summary by phase.

ADZDALLDDLS - Show stored DDL statement text.

ADZDDDLERROR - Show stored DDL execution errors and messages.

adutlrcmp - Recompile all objects, with before/after the status report. Warning: this script may take a long time to run.

ADZDSHOWOBJS - Show Object Summary per edition. Counts of actual and stub (inherited) editioned object per edition.

ADZDSHOWAOBJS - Show Actual Objects in the current edition. These are the editioned objects that have been changed by the patch.

ADZDSHOWIOBJS - Show Inherited Objects in the current edition. These are the editioned objects that remain untouched in the patch edition. This script is used to confirm that the adop actualize_all command has worked properly.

ADZDSHOWCOBJS - Show Covered Object Summary per edition. Count of objects in old editions that have a replacement in the run edition. This script is used to confirm that the adop cleanup command has worked properly.

ADZDSHOWCOBJX - Show Covered Object List. List of objects in old editions that have a replacement in the run edition.

ADZDSHOWSM - Show Seed Manager status.

ADZDSHOWTM - Show Table Manager status.

ADZDSHOWAD - AD (online patching) database object status

ADZDSHOWSES - Show sessions connected to the database (by edition).

ADZDSHOWDEP OBJECT_NAME - Show objects that OBJECT_NAME depends on.

ADZDSHOWDEPTREE OBJECT_NAME - Show the full dependency tree of objects that OBJECT_NAME depends on.

If you like please follow and comment

Comments

WebLogic migration to OCI using WDT tool

WebLogic migration to OCI using WDT tool Oracle WebLogic Deploy Tool (WDT) is an open-source project designed to simplify and streamline the management of Oracle WebLogic Server domains. With WDT, you can export configuration and application files from one WebLogic Server domain and import them into another, making it a highly effective tool for tasks like migrating on-premises WebLogic configurations to Oracle Cloud. This blog outlines a detailed step-by-step process for using WDT to migrate WebLogic resources and configurations. Supported WLS versions Why Use WDT for Migration? When moving Oracle WebLogic resources from an on-premises environment to Oracle Cloud (or another WebLogic Server), WDT provides an efficient and reliable approach to: Discover and export domain configurations and application binaries. Create reusable models and archives for deployment in a target domain. Key Pre-Requisites Source System: An Oracle WebLogic Server with pre-configured resources such as: Applica...

How to Validate TDE Wallet Password in Oracle Database

How to Validate TDE Wallet Password in Oracle Database Validating the Transparent Data Encryption (TDE) wallet password is crucial, especially when ensuring that the password is correct without using the OPEN or CLOSE commands in the database. This blog post explains a straightforward method to validate the TDE password using the mkstore utility. Steps to Validate TDE Wallet Password Follow these steps to validate the TDE wallet password: Step 1: Copy the Keystore/Wallet File Navigate to your existing TDE wallet directory. Copy only the ewallet.p12 file to a new directory. If a cwallet.sso file exists, do not copy it . The absence of cwallet.sso ensures that the wallet does not use auto-login, forcing the utility to prompt for the password. Step 2: Validate Using mkstore Use the mkstore utility to check the contents of the wallet file. The mkstore utility will prompt you for the TDE wallet password, allowing you to validate its correctness. Command Syntax To display the conten...

EBS 12.2 ADOP Interview Questions With Scenarios

EBS 12.2 ADOP Interview Questions With Scenarios Note: Check the patch cycle log is important to fix any issues. Location: $ADOP_LOG_HOME Useful Adop Commands Click here 1.What is ADOP concept in oracle apps Online patching is the most important new feature in Oracle E-Business Suite Release 12.2. It is the ability to patch a running system without having to take the system down for a significant period of time while the patches are applied. 'adop' is the utility we use to apply patches in R12.2 2.What is PATCH_TOP directory in R12.2 In R12.2 there is a new directory location environment variable called $PATCH_TOP which points to $NE_BASE/EBSapps/patch $NE_BASE points to <Non-Editioned-filesystem-directory> Download the patch into the patch top directory and unzip it. This is the default location where the adop will look for patch files. If you are planning to put patches in non-defualt location then you need to use adop parameter 'patchtop=<patch_path>' to...

foalabs

Search This Blog