How to disable audit trail in E Business suite R12.2

 

How to disable audit trail in E Business suite R12.2

There could a situation where you want to stop auditing, then you must set the audit group state to either “Disable-prepare for archive” or
“Disable-Interrupt Audit” and run the “AuditTrail Update Tables” report.

1. Disable Prepare for Archive

Copies the current value of all rows in the audited table into the shadow table and then disables the auditing triggers. There is no
longer any recording of any changes. The shadow table should be archived at this point.

2. Disable Interrupt Audit

Modifies the triggers to store one "final" row in the shadow table for each row that is modified in the audit table. There is no
longer any recording of any changes.

3. Disable Purge Table

Drops the auditing triggers and views and deletes all data from the shadow table.

These options are available from the "Define Audit Groups" form. Login as the System Administrator User Responsibility: Navigate AuditTrail Groups

Select one of the above options contained in the "State" field to disable auditing. Then run the Audit Trial Update Tables report.

How to Enable Audit Trail On Tables in E Business suite R12.2

Recently I came across a requirement from a customer where they wanted to enable audit trail on EBS Application. Today I will show how to enable it.

 

Step 1.

As an example, I will be enabling auditing on table AP_CHECKS_ALL

    Navigate to Responsibility: System Administrator
    Navigation:   Profile > System
    Query Profile: 'AuditTrail:Activate'. Click FIND
    Set it to 'Yes' at Site level.

Step 2.

We will be enabling Audit Installations for username. In this case it will be AP. 

Navigate: System Admin > Security > Audit Trail >Install

Enable Audit Installation for AP

Note:- 

It is important to keep  “Audit Enabled" for a certain schema which has been enabled by default.

By default auditing is enabled for the following schemas. If any of the following schema is not enabled, it is advised to enable them.

APPLSYS GL FA AP AR INV PO CE GMA GMD GME GMF GMI GML GMP WSH FV APPLSYSPUB ZX

Step 3.

Define Audit tables and desired columns.

Before enabling the auditing on columns, please check the limitations.

The following are limitations. A.    Maximum columns 99 for a given table. Best practices are 50 columns or less due to the amount of data that audit trail generates. B.     No LONG, RAW, or LONG RAW columns C.   Your audit group must include all columns that make up the primary key for a table; these columns are added to your audit group automatically. D.   Once you have added a column to an audit group, you cannot remove it. E.    Audit Trail requires two database connections. If your operating platform does not automatically support two database connections (e.g., VMS or MPE/XL), then add the environment variable 'FDATDB=' to your environment file. F.    Because the structure of the audited table may change between product versions, Audit Trail does NOT support upgrading existing shadow tables or audited data. Before an upgrade, you should archive the shadow tables and perform all necessary reporting on the audited data.

Navigation: System Admin > Security > Audit Trail > Tables

Query for user table name ‘AP_CHECKS_ALL’ and add columns on which you want to enable trail do the same for table AP_CHECKS_ALL

Step 4:- Define an Audit Group and associated tables

    Navigation:  System Admin > Security > Audit Trail >Groups

    Create Audit group for table defined in step 3.

Here we created an audit group AP_GROUP_1 and added table name AP_CHECKS_ALL  and Save. Once added , the group state becomes enabled.

Step 4:- Run Concurrent program 'AuditTrail Report for Audit Group Validation' with parameter as your  Audit Group

Step 5.

Run concurrent program "AuditTrail Update Tables".

If the above requests complete with normal status , we can verify the audit records from backend.

Select * from ap_checks_all_A

Steps to Fix Output Post Processor Startup in EBS R12

 Steps to Fix Output Post Processor Startup

In Oracle E-Business Suite, there are occasions when we encounter issues such as the Output Post Processor failing to start up, resulting in a mismatch between the actual number of processes and the target number of processes. Consequently, many concurrent programs end up completing with errors or warnings.

Solution: To resolve such issues, follow these steps:

1. Restart the manager called "Output Post Processor" from the frontend:

   • Log in to Oracle Applications with sysadmin responsibility.
   • Navigate to: Concurrent -> Managers -> Administer.
   • Select "Output Post Processor" and click on the "Restart" button.

2. If the above step does not resolve the issue, perform a complete application stack restart:

   • Ensure no processes are running from the application end after shutting down services.
   • Execute the "ps ux" command from the OS application user to check for any running processes.
   • If any processes are found, terminate them using the "kill -9 process_id" command.

Once completed, restart the application. This should resolve the issue with the Output Post Processor.

Shell Script to run preclone on appstier in EBS R12

 

Shell Script to run preclone on appstier

vi /backup/appspreclone.sh

#!/bin/bash . /RUP10F/apps/apps_st/appl/APPSUAT_ccuine18.env   #This is apps env file cd /RUP10F/inst/apps/UAT_ccuine18/admin/scripts perl adpreclone.pl appsTier <<EOF   #Provide apps password as per your env appsuat EOF

 

$ chmod 775 /backup/appspreclone.sh

 

Now schedule it in crontab

crontab -e

1 0 * * * /backup/appspreclone.sh

 

 

 

Shell Script to run preclone on dbtier in EBS R12

 

Shell Script to run preclone on dbtier

vi /backup/dbpreclone.sh

#!/bin/bash . /RUP10F/db/tech_st/11.2.0/UAT_ccuine18.env   #This is database env file. cd /RUP10F/db/tech_st/11.2.0/appsutil/scripts/UAT_ccuine18 perl adpreclone.pl dbTier <<EOF    appsuat   # Provide apps password as per your env EOF

 

$ chmod 775 /backup/dbpreclone.sh

 

Now schedule it in crontab

crontab -e

0 0 * * * /backup/dbpreclone.sh

Query to check currently running concurrent program in EBS R12.1.3

 

Login to apps user   sqlplus apps/<apps_passwd>   SELECT sess.sid,    sess.serial#,    oracle_process_id OS_PROCESS_ID,    fusr.description user_name,    fcp.user_concurrent_program_name progName,    TO_CHAR (actual_Start_date, 'DD-MON-YYYY HH24:MI:SS')    StartDate,    request_id RequestId,    (SYSDATE - actual_start_date) * 24 * 60 * 60 ETime    FROM fnd_concurrent_requests fcr,    fnd_concurrent_programs_tl fcp,    fnd_user fusr,    v$session sess    WHERE fcp.concurrent_program_id = fcr.concurrent_program_id    AND fcr.program_application_id = fcp.application_id    AND fcp.language = 'US'    AND fcr.phase_code = 'R'    AND fcr.status_code = 'R'    AND fcr.requested_by = fusr.user_id    AND fcr.oracle_session_id = sess.audsid(+)    ORDER BY 8;

How to backup EBS R12.2 application using shell script

 

How  to backup EBS R12.2 application using shell script

Create a shell script with any name for example /home/applmgr/apps_backup.sh

#!/bin/bash date=`date +%d%m%Y` . /app/prod/apps/fs2/EBSapps/appl/APPSPROD_prodappdb.env echo "" /app/prod/apps/fs2/inst/apps/PROD_prodappdb/admin/scripts/adpreclone.pl appsTier pwd=<apps_passwd> <<EOF weblogic123 EOF echo "---------Application Preclone end `date` --------------" echo "" >> /home/applmgr/BACKUP_PROD_APPS/log/backup_$date.log echo "--------------Tar backup end `date`---------------" >> /home/applmgr/BACKUP_PROD_APPS/log/backup_$date.log cp /backup/PROD_APPS_Backup/apps_prod_$(date +%d-%m-%Y).tar.gz /remote_HDD/PROD_Backup_DND/Apps_backup/ echo "--------------backup copied to External HDD completed at `date`---------------" >> /home/applmgr/BACKUP_PROD_APPS/log/backup_$date.log

 

Once done , schedule it in crontab as per your requirement

0 0 * * * /home/applmgr/apps_backup.sh

Error "libdb.so.2: cannot open shared object file: No such file or directory "

libdb.so.2: cannot open shared object file: No such file or directory

 Applicable to :-

Oracle E-Business Suite Technology Stack - Version 12.0 to 12.1.3 [Release 12.0 to 12.1]
Linux x86
Linux x86-64

So , while doing a fresh clone in a new hardware, we faced the error message “libdb.so.2: cannot open shared object file: No such file or directory”  during startup of apache service in EBS. This error is also common in any other oracle application(such as discoverer, demantra) where oracle http service is being used.

 

Reason: This error is observed on linux server 5 and above where Soft link libdb.so.2 is missing.

SOLUTION:-

It might happen that file libgdbm.so.2.0.0 may not exist in server, for that you need to copy it from another server where this file exists or you can download it from below link

libgdbm.so.2.0.0

Now, execute the following steps:

1. Shut down all services on the Application tier

2. Copy libgdbm.so.2.0.0 inside /usr/lib

3. As the unix root user, create a soft link as follows:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

4. Start application tier services again and this time will start without error.

Error while opening EBS url after cloning - " You are trying to access a page that is no longer active."

 

Recently for one of my customer, I was doing a new R12.1.3 clone into a new server which was outside of their production domain. So after the cloning when tried to open the EBS url from browser it showed error saying  “You are trying to access a page that is no longer active.
- The referring page may have come from a previous session. Please select Home to proceed.”

So after doing a bit of google, I found a document from oracle support suggesting a possibility that if the server hostname container underscore (_) such behaviour is observed. But in our case hostname contained no underscore so this was not the case.

So I did the following to resolve the issue

Login to database as apps user

sqlplus apps/xxxx SQL> select session_cookie_domain from icx_parameters;   SESSION_COOKIE_DOMAIN ------------------------------ .olddomain.co.in

 

The session_cookie_domain column is still looking for olddomain.co.in

 

So I nulled the value

 

SQL> update icx_parameters set session_cookie_domain=null; 1 row updated.   SQL> commit; Commit complete.   SQL> select session_cookie_domain from icx_parameters; SESSION_COOKIE_DOMAIN ------------------------------

 

After this I bounced the apache services.

 

[applmgr@ebsr122 ~]$ cd $ADMIN_SCRIPTS_HOME   [applmgr@ebsr122 scripts]$ adapcctl.sh stop   [applmgr@ebsr122 scripts]$ adapcctl.sh start

 

Then I checked the url again , and it logged in without any error.

How to Download EBS R12.2.0 software

 

Many people find it problematic to download EBS software, So I will show here how to download it easily.

Login to http://edelivery.oracle.com/ using your credentials.

To download oracle ebs , write down with “Oracle Advanced Supply Chain Planning” . Don’t write Oracle E business suite as this will only download the EBS software not all the components of it. Select any version to download, for example I choose 12.2.11. This will download the base 12.2 version along with 12.2.11 files.

On top right corner click on view items and continue,

On next screen, deselect the components you don't want to download, for example I dont want to donwload EBS Languages & mobile application archive, so I did not select it.

On next screen, if you don’t want to install VISION instance, you can deselect the files written with “VISION” .

Once selection is done, click on Download and files will start downloading.

SQL Query to get details of a concurrent process in EBS R12.1.3

 To get forms process id first.

SQL> SET LINES 222

SQL> col MODULE for a40

SQL> col ACTION for a40

select sid,serial#,process,module,action from v$session where process=(SELECT p.os_process_id FROM FND_CONCURRENT_REQUESTS r, FND_CONCURRENT_PROCESSES p 

where r.controlling_manager = p.concurrent_process_id and request_id=211503612)

To get more details of process id and command kill that session:-

select s.ECID ,s.inst_id, s.SID,s.SERIAL#,p.spid,s.status,s.machine, s.ACTION, s.MODULE, s.TERMINAL,s.sql_id,s.last_call_et,s.event, s.client_info,s.PLSQL_SUBPROGRAM_ID,s.PROGRAM,s.client_identifier , ( SELECT max( substr( sql_text , 1, 40 )) FROM gv$sql sq WHERE sq.sql_id = s.sql_id ) AS sql_text , ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = 0) AS plsql_entry_object , ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = plsql_entry_subprogram_id) AS plsql_entry_subprogram , ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = 0) AS plsql_entry_object , ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = PLSQL_SUBPROGRAM_ID) AS plsql_entry_subprogram , 'alter system kill session ' || '''' || s.SID || ',' || s.serial# ||',@'|| s.inst_id||''''|| ' immediate;' kill_session from gv$session s ,gv$process p where s.process='32488'  --forms OS process ID --s.program like '%frm%' and p.addr=s.paddr and p.inst_id = s.inst_id ;

Preclone on DBTier fails with RC-20010: Fatal: Could not find Info-ZIP's zip version 2.3 in the PATH

 While running adpreclone on DB Tier , it fails with error RC-20010: Fatal: Could not find Info-ZIP's zip version 2.3 in the PATH

Environment Details:-

Application Version	R12.1.1
DB Version	11.2.0.4
OS	RHEL 7

While running adpreclone on dbTier following error message is thrown

[orapay@ccuine EIILPAY_ccuine]$ perl adpreclone.pl dbTier                       Copyright (c) 2002 Oracle Corporation                         Redwood Shores, California, USA                          Oracle Applications Rapid Clone                                   Version 12.0.0                        adpreclone Version 120.20.12010000.2  Enter the APPS User Password: … … … …   |      0% completed       RC-20010: Fatal: Could not find Info-ZIP's zip version 2.3 in the PATH. Please make sure you have zip version 2.3 in your PATH and rerun the command.zip 2.3 is normally available in $ORACLE_HOME/bin/ or it can be downloaded from http://www.info-zip.org/Zip.html  ERROR while running Stage... Fri Aug  6 22:14:12 2021  ERROR while running perl /PAYROLL/EIILPAY/db/tech_st/11.2.0.4/appsutil/bin/adclone.pl java=/PAYROLL/EIILPAY/db/tech_st/11.2.0.4/jdk/jre mode=stage stage=/PAYROLL/EIILPAY/db/tech_st/11.2.0.4/appsutil/clone component=dbTier method=CUSTOM dbctx=/PAYROLL/EIILPAY/db/tech_st/11.2.0.4/appsutil/EIILPAY_ccuine105.xml showProgress ...

Reason:- The error is observed because Zip Version other zip version is installed in whereas adpreclone.pl is expecting ZIP version 2.3.

[orapay@ccuine105 ~]$ zip -v

Copyright (c) 1990-2008 Info-ZIP - Type 'zip "-L"' for software license.

This is Zip 3.0 (July 5th 2008), by Info-ZIP.

So the above output shows our server has zip version 3 installed. And adpreclone is looking for ver 2.3

Solution:-

Solution 1: Stay with zip 2.3 

1.1 download zip 2.3 from http://www.info-zip.org/ 

1.2 unzip this file to a directory

 1.3 Add this directory in the PATH variable (now 'which zip' should give this location).

 Please make sure you have zip version 2.3 in your PATH

 1.4 Re-run adpreclone.pl

  

Solution 2 : Use zip 3.0 

2.1 Take a backup of you environment 

2.2 Review readme of Patch : 9171651 and apply all pre-requisites 

2.3 Apply patch Patch : 9171651 R12 RAPIDCLONE CONSOLIDATED FIXES JUL/2010

2.4 Retry the adpreclone.pl 

Solution 3: Copy Zip from appstier

3.1 scp or copy zip v2.3 from the apps tier’s location $ORACLE_HOME/bin,

to /usr/bin location.

3.2Make sure to take a backup of original zip in /usr/zip. And then retry adpreclone. It should work.

Once done revert back to original zip version

Autoconfig error in 19C for txkCfgUtlfileDir.sh

 

Error Details:

Database was cloned from source to target environment. While running autoconfig in DB tier  autoconfig is failing with following error

 Environment Details:- 

Application : EBS R12.1.3

Database : 19.9.0

sh adautocfg.sh  Enter the APPS user password: The log file for this session is located at: /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/EBSCLONE_ccuine105/07172228/adconfig.log   AutoConfig is configuring the Database environment... …. …. Updating rdbms version in Context file to db19 Updating rdbms type in Context file to 64 bits Configuring templates from ORACLE_HOME ...   AutoConfig completed with errors.     Logfiles shows:-   [CVM Error Report] The following report lists errors encountered during CVM Phase       <filename>  <return code where appropriate>   /u01/ebsclone/db/tech_st/19.3.0/appsutil/bin/txkCfgUtlfileDir.sh  1   No of scripts failed in CVM phase: 1     AutoConfig is exiting with status 1

 

 

Solution:-

First make sure following directories exist in target location. If its not present, create them.

 

<19c Oracle Base>/temp/<PDB NAME>

<19c ORACLE_HOME>/appsutil/outbound/<context name>

 

Make sure $APPLPTMP value in application tier is referenced in utl_file_dir supplemental parameter. The path should be correct

and should be the first entry in utl_file_dir supplemental parameter.

 

[ebscloneapp@ccuine105 EBSCLONE_ccuine106]$ echo $APPLPTMP

/ebs/EBS19C/db/tech_st/temp/EBS19C

 

mkdir -p /u01/ebsclone/db/tech_st/temp/EBSCLONE

 

[ebsclonedb@ccuine105 19.3.0]$ . EBSCLONE_ccuine105.env

[ebsclonedb@ccuine105 19.3.0]$ sqlplus apps/apps@EBSCLONE

 

 

SQL> select value from v$parameter where name='utl_file_dir';   VALUE -------------------------------------------------------------------------------- /ebs/EBS19C/db/tech_st/temp/EBS19C,/ebs/EBS19C/db/tech_st/temp/EBS19C, ,/usr/tmp/GSTR1_File_Backup,/usr/tmp/PREFERRED/OUT/NEW,/tmp,/usr/tmp/ewaybill,/var/tmp,/u01/ebsc lone/db/tech_st/temp/EBSCLONE

 

Now, since we cloned this instance from a source instance, there are many paths that dont exist in this server.

So we need to remove them from database else  txkCfgUtlfileDir script will fail during syncronization phase.

 

First, retrieve the list of directory paths that are currently stored in the UTL_FILE_DIR supplemental parameter. To do so,

source the PDB environment file and then run the txkCfgUtlfileDir.pl script in getUtlFileDir mode using the following commands:

 

[ebsclonedb@ccuine105 19.3.0]$ . EBSCLONE_ccuine105.env

 

[ebsclonedb@ccuine105 dbs]$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=getUtlFileDir -servicetype=onpremise Enter the APPS Password:   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_05_17_2021/txkCfgUtlfileDir.log Program :  started @ Sat Jul 17 23:05:19 2021   *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_05_17_2021/txkCfgUtlfileDir.log     Script Name    : txkCfgUtlfileDir.pl Script Version : 120.0.12010000.9 Started        : Sat Jul 17 23:05:20 IST 2021   Log File       : /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_05_17_2021/txkCfgUtlfileDir.log   Context file: /u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.xml exists.   ==============================================================================   Successfully generated the below file with UTL_FILE_DIR content: /u01/ebsclone/db/tech_st/19.3.0/dbs/EBSCLONE_utlfiledir.txt   ==============================================================================     Completed        : Sat Jul 17 23:05:22 IST 2021     Successfully Completed the script ERRORCODE = 0 ERRORCODE_END

 

 

Edit the created EBSCLONE_utlfiledir.txt file, as this contains all the directories list.

Remove and add any directories as per your requirement. Make sure if any directory is being added they are physically

present in the server. Also , if  deleting any directory they should not be referenced by application.

 

run the txkCfgUtlfileDir.pl script in setUtlFileDir mode using the following command:

 

ebsclonedb@ccuine105 dbs]$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir -servicetype=onpremise Enter the APPS Password:   Enter the SYSTEM Password:   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_08_56_2021/txkCfgUtlfileDir.log Program :  started @ Sat Jul 17 23:09:02 2021   *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_08_56_2021/txkCfgUtlfileDir.log     Script Name    : txkCfgUtlfileDir.pl Script Version : 120.0.12010000.9 Started        : Sat Jul 17 23:09:02 IST 2021   Log File       : /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_08_56_2021/txkCfgUtlfileDir.log   Context file: /u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.xml exists.   Value for s_applptmp on Apps Tier nodes is valid       Completed        : Sat Jul 17 23:09:07 IST 2021     Successfully Completed the script ERRORCODE = 0 ERRORCODE_END

 

 copy $ORACLE_HOME/jdk/jre folder inside $ORACLE_HOME/appsutil directory.

[oracle@ccuine106 jdk]$ cd $ORACLE_HOME/jdk

[oracle@ccuine106 jdk]$ cp -rpf jre/ $ORACLE_HOME/appsutil/

Finally, synchronize the modified UTL_FILE_DIR value with the database context file.

 

Source PDB Environment file

[ebsclonedb@ccuine105 19.3.0]$ . EBSCLONE_ccuine105.env

 

[ebsclonedb@ccuine105 ebsclone]$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=syncUtlFileDir Enter the APPS Password:   *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/txkCfgUtlfileDir.log Program :  started @ Sat Jul 17 23:14:42 2021   *** Log File = /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/txkCfgUtlfileDir.log     Script Name    : txkCfgUtlfileDir.pl Script Version : 120.0.12010000.9 Started        : Sat Jul 17 23:14:42 IST 2021   Log File       : /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/txkCfgUtlfileDir.log   Context file: /u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.xml exists. Execute SYSTEM command : /u01/ebsclone/db/tech_st/19.3.0/perl/bin/perl /u01/ebsclone/db/tech_st/19.3.0/appsutil/bin/adconfig.pl -contextfile=/u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.xml ************** -log=/u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/acfg_log_Sat_Jul_17_23_14_41_2021.log   The log file for this session is located at: /u01/ebsclone/db/tech_st/19.3.0/appsutil/log/TXK_UTIL_DIR_Sat_Jul_17_23_14_41_2021/acfg_log_Sat_Jul_17_23_14_41_2021.log   AutoConfig is configuring the Database environment...   AutoConfig will consider the custom templates if present.         Using ORACLE_HOME location : /u01/ebsclone/db/tech_st/19.3.0         Classpath                   : :/u01/ebsclone/db/tech_st/19.3.0/jdbc/lib/ojdbc8.jar:/u01/ebsclone/db/tech_st/19.3.0/appsutil/java/xmlparserv2.jar:/u01/ebsclone/db/tech_st/19.3.0/appsutil/java:/u01/ebsclone/db/tech_st/19.3.0/jlib/netcfg.jar:/u01/ebsclone/db/tech_st/19.3.0/jlib/ldapjclnt19.jar           Using Context file          : /u01/ebsclone/db/tech_st/19.3.0/appsutil/EBSCLONE_ccuine105.xml   Context Value Management will now update the Context file           Updating Context file...COMPLETED           Attempting upload of Context file and templates to database...COMPLETED   Updating rdbms version in Context file to db19 Updating rdbms type in Context file to 64 bits Configuring templates from ORACLE_HOME ...   AutoConfig completed successfully.     Completed        : Sat Jul 17 23:15:11 IST 2021     Successfully Completed the script ERRORCODE = 0 ERRORCODE_END

 

 

Now re run autoconfig on DB Tier again and it should successfully run.