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...

22
Jan

ADOP Fails with message " [ERROR]: Domain might be locked by some other WLS user process" and "[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on ADOP Fails with message " [ERROR]: Domain might be locked by some other WLS user process" and "[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script | Tags: , , , , , , , , , ,

Symptoms:

While running an ADOP session it fails due to the Weblogic domain being locked by another process.

 

[applprod@erpapp1 ~]$ adop phase=fs_clone force=yes

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
Run Edition context : /u01/oracle/EBSPROD/fs2/inst/apps/EBSPROD_erpapp1/appl/admin/EBSPROD_erpapp1.xml
Patch edition context: /u01/oracle/EBSPROD/fs1/inst/apps/EBSPROD_erpapp1/appl/admin/EBSPROD_erpapp1.xml
Patch file system free space: 273.40 GB

Validating system setup.
Node registry is valid.
[WARNING] SYS.DUAL table has incorrect privileges
Shut down the application tier services and then run the following commands in the order shown
sqlplus apps/ @ $AD_TOP/patch/115/sql/ADFIXUSER.sql
sqlplus apps/ @ $AD_TOP/sql/adutlrcmp.sql

Checking for existing adop sessions.
No pending session exists.
Starting new adop session.

===========================================================================
ADOP (C.Delta.11)
Session ID: 48
Node: erpapp1
Phase: fs_clone
Log: /u02/oracle/EBSPROD/fs_ne/EBSapps/log/adop/48/20190902_123003/adop.log
===========================================================================

Validating configuration on node: [erpapp1].
Log: /u02/oracle/EBSPROD/fs_ne/EBSapps/log/adop/48/20190902_123003/fs_clone/validate/erpapp1
[WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
[ERROR]: Domain might be locked by some other WLS user process
[UNEXPECTED]Error occurred running "perl /u02/oracle/EBSPROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/oracle/EBSPROD/fs2/inst/apps/EBSPROD_erpapp1/appl/admin/EBSPROD_erpapp1.xml -patchctxfile=/u01/oracle/EBSPROD/fs1/inst/apps/EBSPROD_erpapp1/appl/admin/EBSPROD_erpapp1.xml -phase=fs_clone -logloc=/u02/oracle/EBSPROD/fs_ne/EBSapps/log/adop/48/20190902_123003/fs_clone/validate/erpapp1 -promptmsg=hide"
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on erpapp1

Read more...

22
Oct

Oracle Database Startup Failed due to diskgroup being inaccessible

Author: Shakeeb Petkar | Category: TroubleshootingComments Off on Oracle Database Startup Failed due to diskgroup being inaccessible | Tags: , , , , , , , , , , , , , , ,

Symptoms:

Error starting database with diskgroup is incomplete error.
 

Try to start the database.


SQL> startup
ORACLE instance started.

Total System Global Area 1.0055E+10 bytes
Fixed Size 2261888 bytes
Variable Size 3858762880 bytes
Database Buffers 6174015488 bytes
Redo Buffers 19742720 bytes
ORA-00205: error in identifying control file, check alert log for more info

 
Error in alert log:
ALTER DATABASE MOUNT
This instance was first to mount
NOTE: Loaded library: System
ORA-15025: could not open disk "/dev/mapper/mpathe"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/mapper/mpathg"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/mapper/mpathi"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/ebstest/controlfile/control01.ctl'
ORA-17503: ksfdopn:2 Failed to open file +DATA/ebstest/controlfile/control01.ctl
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-205 signalled during: ALTER DATABASE MOUNT...


Read more...

6
Jan

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

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on ADOP Prepare Phase Fails With Error "runSyncFS sub-routine is called" | Tags: , , , , , , , , , , , , ,

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...

1
Nov

Utlrp.sql results to "Warning: XDB Now Invalid, Could Not Find Xdbconfig"

Author: Shakeeb Petkar | Category: TroubleshootingComments Off on Utlrp.sql results to "Warning: XDB Now Invalid, Could Not Find Xdbconfig" | Tags: , , , , , , , , , , ,

Symptoms:

When trying to recompile invalid objects by running the utlrp.sql script, the below error is thrown:
"XDB now invalid, could not find xdbconfig"
 
Furthermore, Oracle XML Database (XDB) is INVALID.

Error:

ERROR at line 1:
ORA-31024: Parser initialization failed with LPX-201 error
while parsing a stream to XOB
ORA-06512: at "SYS.UTL_RECOMP", line 865
ORA-06512: at line 4

Read more...

Next Page »

Back to Top