Category Archives: Oracle Database

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 | Leave a comment

ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38709: Recovery Area is not enabled. (#OracleDataguard)

Issue: When trying to turn on the flash back in Oracle database, it gives the below error, SQL> alter database flashback on; alter database flashback on *ERROR at line 1: ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38709: Recovery Area … Continue reading

Posted in Oracle Database | Leave a comment

ORA-16664: unable to receive the result from a database

Issue: The “show configuration verbose” command in dgmgrl is showing the below error, when the primary database server was rebooted. KING_ADG – Physical standby database Error: ORA-16664: unable to receive the result from a database Cause:  The network between primary … Continue reading

Posted in Oracle Database | Leave a comment

ORA-16642: DB_UNIQUE_NAME mismatch while adding a Standby Database in DG Broker

Issue: ORA-16642: DB_UNIQUE_NAME mismatch while adding a Standby Database in DG Broker. DGMGRL> add database KINGADG as connect identifier is kingadg maintained as physical; Error: ORA-16642: DB_UNIQUE_NAME mismatch   Resolution: Make sure the DB_UNIQUE_NAME is different in all DBs (Primary and … Continue reading

Posted in Oracle Database | Leave a comment

make: Fatal error: Command failed for target `libnmemso’ while running “adlnkoh.sh” to relink Oracle Home

Issue: make: Fatal error: Command failed for target `/u01/app/oracle/product/KING/11204/sysman/lib/libnmemso.so’ Current working directory /u01/app/oracle/product/KING/11204/sysman/lib *** Error code 1 make: Fatal error: Command failed for target `libnmemso’ Failed linking targets agent /u01/app/oracle/product/KING/11204/sysman/lib Resolution: Try to relink the OH after performing “clone.pl”. cd /u01/app/oracle/product/KING/11204/clone/bin … Continue reading

Posted in Oracle Applications/Apps DBA, Oracle Database | Leave a comment

Migrating 2 node RAC Cluster to new H/W and Adding a Failed Node back in RAC Cluster (#OracleRACAddNode, #OracleRAC)

Scenario: RAC Cluster Database which was setup on 2 nodes, needs a migration to new H/W. Also, adding to this, the 2nd node of RAC Cluster is dead just before this activity was started (& this 2nd node cannot be … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment

ORA-39117: Type needed to create table is not included in this operation

Issue: ORA-39117: Type needed to create table is not included in this operation. Failing sql is: CREATE TABLE “MVDEMO2″.”CITIES_US” (“LOCATION” “MDSYS”.”SDO_GEOMETRY” , “CITY” VARCHAR2(42 BYTE), “STATE_ABRV” VARCHAR2(2 BYTE), “POP90” NUMBER, “RANK90” NUMBER) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS … Continue reading

Posted in OBIEE, Oracle Database | Leave a comment