Category Archives: Oracle Database

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

ORA-16038: log 1 sequence# 12 cannot be archived ORA-19502: write error on file “”, block number (block size=)USER (ospid: 12282): terminating the instance due to error 16038

Issue: ARCH: Closing local archive destination LOG_ARCHIVE_DEST_1: ‘/u01/oracle//arch1/DB1/DB1_1_312_963731429.dbf’ (error 19502) (DB1) ARCH: I/O error 19502 archiving log 3 to ‘/u01/oracle/arch1/DB1/DB1_1_312_963731429.dbf’ Errors in file /u01/oracle//work/diag/rdbms/DB1/DB1/trace/DB1_ora_12282.trc: ORA-16038: log 1 sequence# 12 cannot be archived ORA-19502: write error on file “”, block number … Continue reading

Posted in Oracle Database | Leave a comment

ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed. Directory &FILE_DIR is invalid, contact your system administrator

Issue: ERROR at line 1: ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed. Directory &FILE_DIR is invalid, contact your system administrator. Action: Check that the directory is a valid directory with write permissions on the database server node and is … Continue reading

Posted in Oracle Applications/Apps DBA, Oracle Database | 1 Comment