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 …

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 …

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 …

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 …