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

9
Dec

Adding a Tablespace or Datafile in Primary Database causes the MRP in Physical Standby Database to terminate with error.

Author: Shakeeb Petkar | Category: TroubleshootingComments Off on Adding a Tablespace or Datafile in Primary Database causes the MRP in Physical Standby Database to terminate with error. | Tags: , , , , , , , , , ,

Symptoms:

Media Recovery Stopped on standby database after adding datafile on primary.
 

Error:

MRP0: Background Media Recovery terminated with error 1111
 
Alert Logfile:


Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/oracle/diag/rdbms/erpdr/ERPPROD/trace/ERPPROD_pr00_44120.trc:
ORA-01111: name for data file 58 is unknown - rename to correct file
ORA-01110: data file 58: '/u01/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00058'
ORA-01157: cannot identify/lock data file 58 - see DBWR trace file
ORA-01111: name for data file 58 is unknown - rename to correct file
ORA-01110: data file 58: '/u01/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00058'
Recovery Slave PR00 previously exited with exception 1111
MRP0: Background Media Recovery process shutdown (ERPPROD)

 
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
Feb

JServer JAVA Virtual Machine Component Invalid

Author: Shakeeb Petkar | Category: EBS 12.2.x, Oracle Cloud, TroubleshootingComments Off on JServer JAVA Virtual Machine Component Invalid | Tags: , , , , , , , , , ,

Symptoms:

The JAVAVM Component has become invalid in the database.
 

Check the status of all the components in the database.
 
set pages 1000;
col comp_id for a12;
col comp_name for a35;
col version for a12;
col status for a12;
select comp_id,comp_name,version,status from dba_registry;


COMP_ID COMP_NAME VERSION STATUS
------------ ----------------------------------- ------------ ------------

MGD Oracle Machine Generated Data 11.2.0.4.0 VALID
AMD OLAP Catalog 11.2.0.4.0 VALID
EM Oracle Enterprise Manager 11.2.0.4.0 VALID
XDB Oracle XML Database 11.2.0.4.0 VALID
CONTEXT Oracle Text 11.2.0.4.0 VALID
SDO Spatial 11.2.0.4.0 VALID
ORDIM Oracle Multimedia 11.2.0.4.0 VALID
CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 INVALID
CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID
XML Oracle XDK 11.2.0.4.0 VALID
RAC Oracle Real Application Clusters 11.2.0.4.0 VALID
APS OLAP Analytic Workspace 11.2.0.4.0 VALID
XOQ Oracle OLAP API 11.2.0.4.0 VALID

15 rows selected.

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