Adop Online Patching Phases in Oracle E-Business Suite R12.2.X

All patches starting from Release R12.2.X are online patches and is applied using new adop (AD online Patching utility). Key points about:- A.. If patch does not contains new updates to files or database to the objects in system then is does not take any action . B.. If is detects a previously failed session … Continue reading Adop Online Patching Phases in Oracle E-Business Suite R12.2.X

Adop patching AutoPatch error :- Error running SQL and EXEC commands in parallel in Oracle E-Business Suite R12.2.X

1.. Adop patching  AutoPatch error :- Error running SQL and EXEC commands in parallel 2.. As given above patch failed and worker has quited . Navigate to  $AD_TOP/bin and check worker status by using adrctl utility. You can try restarting worker but it will not start. 2.. Now Login to Oracle Database and check alert log … Continue reading Adop patching AutoPatch error :- Error running SQL and EXEC commands in parallel in Oracle E-Business Suite R12.2.X

Enabling AutoConfig in a New RDBMS ORACLE HOME for Oracle E-Business Suite 12.2.X

In Release 12.2, AutoConfig is enabled by default on the application tier. But, it might not be enabled on the database tier in the following scenarios. 1.1. The database tier was not created by Rapid Install 1.2. Cross-platform migration has been performed on the database tier 1.3. The database has been upgraded to Oracle Database … Continue reading Enabling AutoConfig in a New RDBMS ORACLE HOME for Oracle E-Business Suite 12.2.X

The ADR Command Interpreter (ADRCI) Or ADR:- setting in Oracle Database 12cR1

The ADR is a file based repository for database diagnostics data such as traces, incident, dumps, and packages, the alert log ,health monitor reports ,core dumps and more. It has unified directory structure across multiple instances and many products. Stored outside of the database. There for it is available for problem diagnosis when the database … Continue reading The ADR Command Interpreter (ADRCI) Or ADR:- setting in Oracle Database 12cR1

Configure Transparent Data Encryption (TDE) in Oracle 12c database

1… Create a directory for the key store 2.. Specify key store location in sqlnet.ora 3.. Login with SYSKM or SYSDBA privilege 3.1  Once logged in create keystore file 3.2 Now once key store is created, open the software key file 3.3  Create the master encryption key which is stored encrypted in the keystore file … Continue reading Configure Transparent Data Encryption (TDE) in Oracle 12c database

User is Unable to See a Responsibility In the Home Page of Oracle E-business suite…

SYMPTOMS :- A user has been assigned a responsibility, however the responsibility is not shown in the user's home page. Data in Workflow Directory tables has been checked and found to be OK. Neither clearing the global cache nor bouncing Apache solve the issue ... CAUSE :- Responsibility has been explicitly hidden by user, through … Continue reading User is Unable to See a Responsibility In the Home Page of Oracle E-business suite…

Creation of basic networking components of Virtual Cloud Network in OCI and provisioning Compute Instance

1.. Login to OCI Cloud account click on hamburger menu and again click on Networking Tab. Once You are on the Networking page, select compartment where you want to create your VCN. 2.. Give name for VCN and enter CIDR block and select CREATE VIRTUAL CLOUD NETWORK ONLY to create all other basic networking components … Continue reading Creation of basic networking components of Virtual Cloud Network in OCI and provisioning Compute Instance

Creating User in Oracle Cloud Infrastructure in simple way

What is user in Oracle Cloud Infrastructure ? An individual employee or system that needs to manage or use company's Oracle Cloud Infrastructure resources. Users might need to launch instances, manage remote disks, work with your virtual cloud network, etc. End users of your application are not typically IAM users. Users have one or more … Continue reading Creating User in Oracle Cloud Infrastructure in simple way

How to find Installed Modules in Oracle E-Business Suite R12 …..

First Method :- 1.. Login Oracle E-Business Suite as SYSADMIN user. 1.2.. Click on System Administrator responsibility and OAM Setup tab. 1.3.. Once you have clicked on OAM setup, click on Site Map 1.4..  Now click on Licensed Products under the tab Reports 1.5 Your screen will appear like given below with summary for licensed, … Continue reading How to find Installed Modules in Oracle E-Business Suite R12 …..

Recovery of Non-system Datafile without backup using rman in 11gR2

Assumption :- For tablespace RECOVERY one datafile is backedup using rman and other datafile is not backedup. 1.. Create tablespace called RECOVERY with one datafile recovery01.dbf 2.. Take full backup of Database using rman Now again add a new datafile as recovery02.dbf to RECOVERY Tablespace that you have created. 3.. For testing purpose create a … Continue reading Recovery of Non-system Datafile without backup using rman in 11gR2