6
Jan

ADOP Prepare Phase Fails With Error "runSyncFS sub-routine is called"

Symptoms:

ADOP Prepare phase fails while applying a patch.

Error:

[PROCEDURE] [END 2018/11/12 18:21:48] Acquiring lock on AD_ADOP_SESSION_PATCHES table
[PROCEDURE] [START 2018/11/12 18:21:48] Sync FS of RUN and PATCH
[PROCEDURE] Calling: /u02/oracle/ERPPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl
[EVENT] Log: /u02/oracle/ERPPROD/fs_ne/EBSapps/log/adop/42/20181112_175050/prepare/erpisup
[UNEXPECTED]Error occurred running "perl /u02/oracle/ERPPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/oracle/ERPPROD/fs1/inst/apps/erpprod_erpisup/appl/admin/erpprod_erpisup.xml -patchcontextfile=/u01/oracle/ERPPROD/fs2/inst/apps/erpprod_erpisup/appl/admin/erpprod_erpisup.xml -promptmsg=hide -console=off -patchtop=/u02/oracle/ERPPROD/fs_ne/EBSapps/patch -mode=update -sync_mode=patch -sessionid=42 -timestamp=20181112_175050 -workercount=8 -outdir=/u02/oracle/ERPPROD/fs_ne/EBSapps/log/adop/42/20181112_175050/prepare/erpisup -autoskip=No"
[PROCEDURE] [START 2018/11/12 18:22:29] Unlocking AD_ADOP_SESSION_PATCHES table
[STATEMENT] Unlocking AD_ADOP_SESSION_PATCHES table for erpisup having lock name ADPATCH

[PROCEDURE] [END 2018/11/12 18:22:29] Unlocking AD_ADOP_SESSION_PATCHES table
[UNEXPECTED]Error calling runSyncFS subroutine.
[ERROR] Prepare phase has failed.

Read more...

3
Jul

With AD-TXK Delta.9 and higher, Autoconfig Fails On PatchFS with error "ORA-12514: TNS:listener does not currently know of service requested

Symptoms:

 

When attempting to run autoconfig on patch fs the following error occurs.


ERROR
-----------------------
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.

 
Read more...

5
Jun

Change APPS password in EBS R12.2.x Delta 7 or above

Important: These steps must be carried out on the run file system. The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed. Remove the backups after you have confirmed that the changes are successfully completed. Passwords for all the 3 schemas, APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password using

 
There are 2 ways to change the APPLSYS password:
Read more...

3
May

Change APPS password in EBS R12.2.x Delta 6 or below

Important: These steps must be carried out on the run file system. The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed. Remove the backups after you have confirmed that the changes are successfully completed. Passwords for all the 3 schemas, APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password using

 
There are 2 ways to change the APPLSYS password:
Read more...

16
Apr

Login to internal node gets redirected to external node after adding new DMZ node in EBS R12.2.x

Symptoms:

For some users, login to internal node gets redirected to external node.

 

Cause:

In $IAS_ORACLE_HOME/instances/EBS_web_SID_OHS1/config/OHS/EBS_web_SID/mod_wl_ohs.conf and apps.conf files, the cluster includes the external node external.domain.com.

 

Solution:

 

To fix this issue, make the following changes to the run file system of the internal node:
Remove any reference to external.domain.com from both the files i.e. mod_wl_ohs.conf and apps.conf.

 
Node 1: /u02/oracle/EBSPROD/fs1/FMW_Home/webtier/instances/EBS_web_EBSPROD_OHS1/config/OHS/EBS_web_EBSPROD
 
Node 2: /u02/oracle/EBSPROD/fs1/FMW_Home/webtier/instances/EBS_web_EBSPROD_OHS3/config/OHS/EBS_web_EBSPROD
 
DMZ Node: /u02/oracle/EBSPROD/fs2/FMW_Home/webtier/instances/EBS_web_EBSPROD_OHS2/config/OHS/EBS_web_EBSPROD
 
Read more...

Back to Top