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

12
Jan

ADOP Prepare phase fails while cloning Run Context file to refresh Patch context file

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on ADOP Prepare phase fails while cloning Run Context file to refresh Patch context file | Tags: , , , , , , , ,

Issue:

While running adop phase=prepare, it fails on one node while trying to clone Run Context file to refresh Patch context file.

Error:

It fails with the following error in the ADOP Session.
ADOP prepare phase fails with [UNEXPECTED] occurred during CONFIG_CLONE Patch File System from Run File System

The log file has the following error:

ERROR: Could not clone the Run context file due to the following exception:
AC-00005: No write permissions for creating the Context file - /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
ERROR: Failed to clone Run Context file to refresh Patch context file

applpreprod@ebsapp01:~$ adop phase=prepare

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

Validating credentials.

Initializing.
Run Edition context : /u01/PREPROD/fs1/inst/apps/PREPROD_ebsapp01/appl/admin/PREPROD_ebsapp01.xml
Patch edition context: /u01/PREPROD/fs2/inst/apps/PREPROD_ebsapp01/appl/admin/PREPROD_ebsapp01.xml
Patch file system free space: 83.74 GB

Validating system setup.
Read more...

Back to Top