Steps for running AutoConfig on PATCH file system:
1) Disable a trigger
SQL> conn system/systemPWD
Connected.
SQL> alter trigger ebs_logon disable;
Trigger altered.
If EBS_SYSTEM account exists in db, disable same trigger owned by it to avoid errors:
$ sqlplus apps/appsPwd
ERROR:
ORA-04088: error during execution of trigger 'EBS_SYSTEM.EBS_LOGON'
ORA-00604: error occurred at recursive SQL level 1
ORA-20099: E-Business Suite Patch Edition does not exist.
ORA-06512: at line 48
2) Set PATCH env and connect to database
$ . /<EBS_HOME_BASE>/EBSapps.env patch
$ echo $TWO_TASK
EBSDEV_patch
$ sqlplus apps/appsPWD
-- If got error, compare tnsnames.ora in both RUN and PATCH file systems &
-- modifying tnsnames.ora in PATCH file system may be needed in Oracle 19c db.
SQL> show user
USER is "APPS"
SQL> exit
3) Run autoconfig in PATCH file system
$ cd $ADMIN_SCRIPTS_HOME
$ echo $FILE_EDITION
patch
$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: $INST_TOP/admin/log/MMDDHHMI/adconfig.log
... ...
AutoConfig completed successfully.
4). Enable the trigger
SQL> conn system/systemPWD
Connected.
SQL> alter trigger ebs_logon enable;
Trigger altered.
SQL> conn ebs_system/systemPWD
Connected.
SQL> alter trigger ebs_logon enable;
Trigger altered.
No comments:
Post a Comment