Recently started seeing this error on few of the Exadata environments. ORA–00600: internal error code, arguments:[KUTYXTTE_TRANSFORM:FAILED] As per metalink this is a known Bug 28194173 Patch 28194173: SQL ON 12.2 QUARANTINED AND CELL THROWING ORA-00600 [KUTYXTTE_TRANSFORM:FAILED] I’ve seen this in 12.2.
Category: ORA-ERRORS
ORA-600[KCLANTILOCK_17]
Recently started seeing this error on few of the RAC environments. ORA–00600: internal error code, arguments:[ORA-600[KCLANTILOCK_17] After upgrade to 12.2, Due to this Instance got crashed. As per metalink this is a known Bug 27162390 Patch 27162390: LNX64-181-RAC: LMS HIT ORA-600[KCLANTILOCK_17], INST CRASH I’ve seen this in 12.2. As per Oracle it’s fixed in version 18.1
ORA-600 [KDZA_CHECK_EQ NOT IN DICTIONARY]
Recently started seeing this error on few of the RAC environments. ORA–00600: internal error code, arguments:[KDZA_CHECK_EQ NOT IN DICTIONARY] As per metalink this is a known Bug 24818566 Patch 24818566: SQLLOAD FAILED WITH ORA-600 [KDZA_CHECK_EQ NOT IN DICTIONARY] I’ve seen this in 11204 ,12102,12.2 both. As per Oracle it’s fixed in version 18.1
TNS-12547: TNS:lost contact
Being DBA we all are aware that we must have knowledge of OS level too because Database not just runs over the only one OS. In a different organization, we have a different OS. Being a part if IT we understand that different OS environment has a different parameter. We have to set them. Today […]
ORA-12154: TNS:could not resolve the connect identifier
We are continuing with the same series of listener errors. Let’s have looked over the new error. Let’s go for the steps [oracle@hostname]$ sqlplus sys@test_1as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 7 15:01:04 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter password: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified […]
ORA-12516:TNS protocol stack in Oracle
Let’s start the series of Oracle listener. Now are going to focus over the issue for the following errors. Let’s have looked over the steps and solve the issues. TNS-12516 TNS: listener could not find an instance with the matching protocol stack ORA-12516 TNS: listener could not find available handler with the matching protocol stack […]
ORA-12505: TNS:listener in Oracle
Being human being we have a lot of unlimited qualities. Listening is one of them. Normally we ignore it but it is most important for all. Good listing keeps us away from 99% problems away and life makes us simple but if we don’t listen properly we invite unlimited problem in our life. In same […]
ORA-12162: TNS:net service name is incorrectly specified
Let’s have look on some listener issues in the database. Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified. Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If […]
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
As we are working on the series of listener errors. Now we are going to work on “ORA-12514“. Let’a have look on the steps which we use to resolve this issue. Cause: “The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a SID […]
rtld: 0712-001 Symbol CreateIoCompletionPort was referenced
In My Case Cause of below the issue at storage level. failing currently due to LVM inconsistency Below screenshot where CRS services are running on another node. iocp0 is now available on pdb02 Ref: AIX 12.1.0.2 Installation Fails with “rtld: 0712-001 Symbol CreateIoCompletionPort was referenced ” (Doc ID 1949184.1)