Author Archives: pradeepvattem

ORA-03135: connection lost contact RMAN-10041: Could not re-create polling channel context following failure. RMAN-10024: error setting up for rpc polling #Standby #RMANClone

Issue: The issue is observed when I was re-building the standby database from PRIMARY after downgrading the database from 12c (12.2.0.2) to 11g (11.2.0.4) in a RAC environment. ORA-03135: connection lost contact continuing other job steps, job failed will not … Continue reading

Posted in Oracle Database | 1 Comment

RMAN-03009: failure of backup command on C05 channel at 02/12/2019 09:22:10 ORA-17628: Oracle error 19505 returned by remote Oracle server continuing other job steps, job failed will not be re-run

Issue: While the RMAN Active Duplicate is initiated, the rman job failed with the below errors, RMAN-03009: failure of backup command on C05 channel at 02/12/2019 09:22:10 ORA-17628: Oracle error 19505 returned by remote Oracle server continuing other job steps, … Continue reading

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

ORA-01078: failure in processing system parameters LRM-00101: unknown parameter name ‘__inmemory_ext_roarea’

Issue: The Standby database was converted to Logical Standby Database and upgraded to 12.2 (from 11.2.0.4); later, it has been flashbacked to the guaranteed restore point. The database was throwing below errors when trying to start instance from 11g OH. … Continue reading

Posted in Oracle Database, Oracle Database Upgrade | Leave a comment

ORA-00603: ORACLE server session terminated by fatal error ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-00904: “ACDRROWTSINTCOL#”: invalid identifier Process ID: 11866 Session ID: 1485 Serial number: 2943

Issue: When trying to flash back the standby database to a guaranteed restore point, the issue was seen when the database was tried to “open”. SQL> alter database open read only; alter database open read only * ERROR at line … Continue reading

Posted in Oracle Database, Oracle Database Upgrade, Uncategorized | Leave a comment

ora-16025: parameter log_archive_dest_2 contains repeated or conflicting during database upgrade while performing DB upgrade, PRCR-1079, CRS-2501

Issue: While performing database upgrade from 11.2.0.4 to 12.2.0.1, DBUA exists in pre-upgrade section giving the below error, ora-16025: parameter log_archive_dest_2 contains repeated or conflicting during database upgrade Resolution: This is because of excess parameters, mostly due to net_timeout, have … Continue reading

Posted in Oracle Database, Oracle Database Upgrade | Leave a comment

ORA-16664: unable to receive the result from a database; DGM-17017: unable to determine configuration status

Issue: We have setup Standby and configured the DG broker as well. The functionality of archive shipment and applying the archives/redos was working fine. Also status check in DGMGRL from all nodes was working good except on oratestsb01; and was … Continue reading

Posted in Oracle Database | Leave a comment

OAK INSPIREON – My Guest Lecture for Students at Oakridge International School, Hyderabad

The year 2019 started off with a great opportunity. I was invited to speak with class#6 students of Oakridge International School about any topic related to Information Technology (IT). Being a DBA by profession, I picked “Data & Databases – … Continue reading

Posted in Conferences/UserGroups | Leave a comment

Oracle Cloud – Tools & Utilities for Oracle DBAs #OracleCloud #Oracle #AIOUG #SANGAM18

I got an opportunity to share my knowledge on various Tools & Utilities in Oracle Cloud Specific to PaaS offerings; it was a 45 minute session in which I was able to deliver speaking on ‘dbaascli, raccli, oracle-dbcs-cli, psm’ utilities. … Continue reading

Posted in Conferences/UserGroups, Oracle Cloud | Leave a comment

Fantastic 2018 #AIOUG #Oracle #Sangam18

2018 has been a fantastic year for me, right from being an active regular speaker across cities in India, privileged to Join the AIOUG Board, able to attend ‘my dream’ conference OOW18 (Oracle Open World 18), receiving the most exiting … Continue reading

Posted in Conferences/UserGroups | Leave a comment

All About Sangam18 (#Sangam18)

The journey of Sangam18 is very special to me and for AIOUG as well, as its 10th Anniversary for Sangam as a conference… It all started by our Leader Sai Penumuru the very next day ODevCYatra was wrapped at North … Continue reading

Posted in Conferences/UserGroups | Leave a comment