Monthly Archives: February 2017

DAC Connectivity to MS SQLSERVER – SQLServerDriver : Unsupported major.minor version 52.0

Issue: While connecting from Oracle DAC to MS SQLSERVER 2008, I happened to see the below error. Failure connecting to “SQL Server DB”! com/microsoft/sqlserver/jdbc/SQLServerDriver : Unsupported major.minor version 52.0   Cause: The Drivers for SQL Server used are of higher … Continue reading

Posted in Oracle DAC | Leave a comment

DBUA Error – ORA-00205: Error in identifying Control file, check alertlog for more info

Issue: While Upgrading Oracle Database from 11.2.0.4 to 12.1.0.2 using DBUA, I happened to see the error “ORA-00205: Error in identifying Control file, check alertlog for more info” as a Pop-up on the screen.   Cause: The Path/Location of Controlfile … Continue reading

Posted in Oracle Database Upgrades | 1 Comment

Golden Gate – Identifying Current Processing Transactions

This is an informational blog post regarding Golden Gate. When I started working on GG initially, I used to wonder how to identify the transactions that are currently being processed by the Extract and Replicat Processes. Below are the commands … Continue reading

Posted in Oracle Golden Gate | Leave a comment

CRS-4404, CRS-4535, CRS-4530, CRS-4534- Cannot communicate with Event Manager

Issue: The Below errors may stop you from Installing or Configuring RAC CRS-4535: Cannot communicate with Cluster Ready Services CRS-4530: Communications failure contacting Cluster Synchronization Services daemon CRS-4534: Cannot communicate with Event Manager CRS-4404: The following nodes did not reply … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment

ORA-01547, ORA-01194: file 1 needs more recovery to be consistent, ORA-01110, ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL

About the issue/Background: The Database clone from PROD to Non-Prod environment is being performed using the Snap clone functionality. So, the essential part of DBA team is to put the Source Database in Begin Backup Mode. And once the Snap … Continue reading

Posted in Oracle Database, Oracle Database Clone Issues | Leave a comment

ORA-32006: SQL_TRACE initialization parameter has been deprecated

Issue: During the Oracle Database Upgrade from 11.2.0.4 to 12.1.0.2, below error may pop-up in DBAU, ORA-32006: SQL_TRACE initialization parameter has been deprecated   Cause: The Parameter SQL_TRACE is no longer valid in 12c   Resolution: Click on “Ignore” in … Continue reading

Posted in Oracle Database | Leave a comment

ORA-17502: ksfdcre:4 Failed to create file, ORA-15046: ASM file name is not in single-file creation form

Issue: While recreating the controlfile in an Oracle Database, below issue has been cropped in SQL> @SIT1_ora_11129.trc CREATE CONTROLFILE SET DATABASE “SIT” RESETLOGS NOARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-00200: control file could not be created … Continue reading

Posted in Oracle Database, Oracle Database Clone Issues | Leave a comment

Identifying the Archivelog, a GoldenGate process is currently using in Oracle

With the Integrated Capture introduced from 11.2.0.4 version, Oracle GoldenGate uses LogMiner to capture the data from the Database. So, the LogMining actually will be performed by reading the archivelog files. So, it is very important to have idea on … Continue reading

Posted in Oracle Database, Oracle Golden Gate | Leave a comment

DBUA – Entry missing in oratab

Error/Observation: The Database (Home) that is planned to upgrade is not showing up in DBUA screen Cause: Changes in oratab file Resolution: Make sure we have the entry of Database (ORACLE_HOME and DB Name) in /etc/oratab file, before invoking the … Continue reading

Posted in Oracle Database | Leave a comment

RMAN-06136: ORACLE error from auxiliary database: ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.3.0

Issue: While performing the clone of Oracle Database using ‘Active Duplication’, the clone may fail with below errors, RMAN-06136: ORACLE error from auxiliary database: ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.3.0 Cause: Target database might be having lower … Continue reading

Posted in Oracle Database Clone Issues | Leave a comment