Category Archives: Oracle Database

ORA-16795: the standby database needs to be re-created, Recreate DB Broker

Scope: The Oracle database has been upgraded from 11.2.0.4 to 12.2.0.1 and the standby database (physical) was able to synchronize the data; but we see the error “ORA-16795: the standby database needs to be re-created” while querying DGMGRL. DGMGRL> show … Continue reading

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

ORA-16191: Primary log shipping client not logged on standby

Issue: While setting up the standby database in Oracle, the archives are not being shipped to the standby and we were continuously getting this alert when queried the V$ARCHIVE_DEST view. SQL> select DEST_ID, STATUS, DESTINATION, ERROR from V$ARCHIVE_DEST where dest_id=’2′; … Continue reading

Posted in Oracle Database | Leave a comment

Password details in sys.user$ table in 11g & 12c

Scope: The scope of this blog post is to explain the way of capturing password values in 11g & in 12c. in 11g: We normally go with the syntax “select password from user$ where name=’TEST’; But, in 12c password column … Continue reading

Posted in Oracle Database | Leave a comment

Point In Time Recovery using orec utility (#OracleCloud #orec #dbaascli)

Scope: The scope of this blog post is to understand the commands used to recover a database which is in Oracle Cloud to restore & recover till point in time. Steps Involved: When we are planning to recover a database, … Continue reading

Posted in Oracle Cloud, Oracle Database | Leave a comment

The backup process failed RMAN-03009: failure of backup command,ORA-19506: failed to create sequential file, ORA-27028: skgfqcre: sbtbackup returned error, ORA-19511: non RMAN, but media manager or vendor specific failure(#OracleCloud #bkup_api)

Issue: I was trying to take a backup of a Database which is in Oracle Cloud (DBCS) using the bkup_api utility and couldn’t succeed with the below errors. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 08/23/2018 14:15:48 ORA-19506: … Continue reading

Posted in Oracle Cloud, Oracle Database | Leave a comment

Bug in Oracle Cloud Console DBCS (#OracleCloud #DBCS #dbaascli)

This is just an informational message: Scope: I’ve noticed a bug with the console, where it doesn’t show the list of applied patches and still show the patches applicable, when the patch has been applied from CLI Description: I’ve applied … Continue reading

Posted in Oracle Cloud, Oracle Database | Leave a comment

Patching Database using dbaascli utility (#OracleCloud #dbaascli #dbpatchm)

Scope: The scope of this blogpost is to understand how a Database in Oracle Cloud (DBCS) can be patched using dbaascli utility. I will also share my 6 hours of patching experience with this utility. High Level Steps: Identify what … Continue reading

Posted in Oracle Cloud, Oracle Database | Leave a comment

Oracle Autonomous Database, 18c (#AIOUGHYDERABAD, #AutonomousDatabase, #18c)

Oracle Autonomous Database – The latest and greatest Oracle Database product as of Date (24Mar’18), which is the World’s first Self Driving Database… I feel very privileged, to be one of the Organizing committee members for Organizing the “Oracle Autonomous … Continue reading

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

Failed to connect to database instance: Failed to connect: java.sql.SQLException: ORA-28040: No matching authentication protocol

Issue: While configuring a database (12.2) from OEM 12c, the database was added to the monitoring but the status of DB was showing down. And observed below error; also observed “INVALID USERNAME/PASSWORD” sometimes. Failed to connect to database instance: Failed … Continue reading

Posted in Oracle Database | Leave a comment

ORA-03113: end-of-file on communication channel; Process ID: xxxx; Session ID: xxxx Serial number: x

Issue: SQL> startup ORACLE instance started. Total System Global Area 3.4217E+10 bytes Fixed Size 2198680 bytes Variable Size 1.7180E+10 bytes Database Buffers 1.6979E+10 bytes Redo Buffers 55943168 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 8149 Session ID: … Continue reading

Posted in Oracle Database | Leave a comment