I faced with that error message our 12c exadata system. Our development team send that error message to dba team.

Complete error message is:

[Error] Execution (1: 1): ORA-29548: Java system class reported: release of classes.bin in the database does not match that of the oracle executable
ORA-06512: at “MDSYS.SDO_JAVA_STP”, line 370
ORA-06512: at “MDSYS.SDO_UTIL”, line 3188
ORA-06512: at “MDSYS.SDO_UTIL”, line 321

Read the rest of this entry »

I faced with that error while I was trying to take rman backup to our new NFS mount point.

The complete error message is:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of crosscheck command on ORA_DISK_1 channel at 10/04/2019 20:14:34
ORA-19587: error occurred reading 512 bytes at block number 1
ORA-17500: ODM err:KGNFS READ FAIL:Permission denied
ORA-27041: unable to open file
SVR4 Error: 13: Permission denied
Additional information: 7
ORA-17503: ksfdopn:6 Failed to open file /orabackup_nfs/SASKI_dbfull_20191003_8puddo78_1_1.rman
ORA-17500: ODM err:KGNFS READ FAIL:Permission denied

Read the rest of this entry »

I faced that warning message during my restore process from RAC Database with ASM that has been converted or restored to the Standalone Single Instance Non-ASM Database.

I also noticed RMAN is taking significant time than normal restore time.

From the RDBMS alert.log, it is showing continuous following messages.

ASMB started with pid=32, OS id=28124 
WARNING: failed to start ASMB (connection failed) state=0x1 sid=''
WARNING: ASMB exiting with error
Starting background process ASMB

Read the rest of this entry »

I faced with this error during trying to create second instance I hit below errors:

1

After investigate issue I have been found below explanation from this link

From link:

Read the rest of this entry »

I faced with that error during running DBCA in silent mode. Complete error message is:
ORA-27104: system-defined limits for shared memory was misconfigured

I have been checked all related parameter such as /etc/sysctl.conf & /etc/security/limits.conf

Read the rest of this entry »

You may hit this error during connecting your database by using 3th party tools such as Toad etc.

You are hitting this error If the Oracle client was installed using the domain administrator account instead of the local administrator.

Read the rest of this entry »

I have an issue on 11.2.0.4 database (2 node RAC system) on AIX.  Our system is already around 25T and our full backup size almost 3,7Tb with using compress option.

Our number of datafiles are almost 1054.  We are taking our backup to disk using 16 channel. Total full backup duration is almost 4,5 hours.

Our backup duration became almost 7,8 hours last 3 days. I investigated backup log file and I noticed backup start 16 channels and that 16 channel backupsets job done almost 4:30 hours. After 16 channels backupsets  end,  one new channel opening and it keep taking backupsets by using 1 channel.

Read the rest of this entry »

I have been faced with this problem on R12.1.3 2 node 11.2 RAC database on the AIX system. After closed instance 2, it started to gives ORA-17611: ksfd: file ” cannot be accessed, global open closed errors at alert.log file

After making some search We noticed that this is referring publish bug which will be fixed in12.1 (Future Release). Here is the possible solution for this error:

Read the rest of this entry »

I have 11.2.0.4  2 node RAC system on AIX. Due to do security issue I can not get root password.

As you know, I need to close CRS by using crsctl stop crs commandTo can achieve run this command We need to have a root privileges user or root user’ password.

In this post I will share Which grant you need to can stop CRS instead of the Root user.

Read the rest of this entry »

I have faced with that issue on our 12.1.3 EBS system on AIX system with 2 node 11gR2 RAC databases.

During the full backup operation, I noticed that RMAN log mention below error message at the backup log file.

RMAN-03009: failure of backup command on ORA_DISK_3 channel at 03/29/2012 22:19:19
ORA-19566: exceeded limit of 0 corrupt blocks for file +ORADATA/PROD/datafile/apps_ts_xxcustom_data.308.752148073
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 03/29/2012 21:42:32
ORA-19566: exceeded limit of 0 corrupt blocks for file +ORADATA/PROD/datafile/apps_ts_xxcustom_data.395.741949465
RMAN-03009: failure of backup command on ORA_DISK_8 channel at 03/29/2012 22:18:24
ORA-19566: exceeded limit of 0 corrupt blocks for file +ORADATA/PROD/datafile/apps_ts_xxcustom_data.583.753881375

Read the rest of this entry »