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.
2) Set PATCH env and connect to database
$ . /<EBS_HOME_BASE>/EBSapps.env patch
$ echo $TWO_TASK
EBSDEV_patch
$ sqlplus apps/appsPWD
-- If it 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.
No comments:
Post a Comment