13
Jun

DataPump Job fails after Database Upgrade

Author: Shakeeb Petkar | Category: TroubleshootingComments Off on DataPump Job fails after Database Upgrade | Tags: , , , , , , , , , , ,

Symptoms:

DataPump job fails with the following errors:

[oracle@ebsdb01 expdp]$ expdp system/manager tables=employees directory=EXPDP dumpfile=emp_data.dmp logfile=expdp.log
 
Export: Release 11.2.0.4.0 - Production on Thu Jun 10 15:19:55 2021

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-01403: no data found

ORA-39097: Data Pump job encountered unexpected error 100

Read more...

16
Apr

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

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on Login to internal node gets redirected to external node after adding new DMZ node in EBS R12.2.x | Tags: , , , , , , , , , , ,

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