ORA-00600 [LibraryCacheNotEmptyOnClose]

If you are running Oracle 10gR2 10.2.0.1 to 10.2.0.5 and encounter this error on shutdown you ran into either unpublished bug 4483084 or bug 7572335. Both bugs deal with objects left in the library cache […]

ORA-00354 corrupt redo log block header

I ran in to an issue recently where a database was reporting ORA-00257 archiver error, connect internal only, until freed. However when looking at the system I could not find evidence to support the ORA-00257.

Numerous m000 trace files in which KEWROCISTMTEXEC encountered ORA-12899

While clearing up some space in diag/trace directory, I noticed numerous trace files were being generated by the Memory Monitor slave process (m000). These trace files were being generated at regular intervals.

ORA-04020 When Dropping Materialized View with a Spatial Index

While upgrading our GIS development database from 11gR1 to 11gR2 we found that we were getting deadlocks when dropping materialized views that had spatial indexes. The deadlock always occurred on the first attempt to drop […]

ORA-20200: Database/Instance does not exist in STATS$DATABASE_INSTANCE

When attempting to run a Statspack instance report using spreport.sql the following error is generated.

08S01: Communication link failure. System call recv() failed with OS error 104 ECONNRESET

When attempting to establish a connection to a remote Oracle TimesTen database using ttIsqlCS on Linux you receive the following error.

java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbc1121 in java.library.path

When trying to execute a Java program that connects to remote Oracle TimesTen database you receive the following stack trace.

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders. Many times the source of confusion lies in the […]

ORA-12543: TNS:destination host unreachable

Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders. This aim of this document is to show a […]

ORA-12545: Connect failed because target host or object does not exist

Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders. This aim of this document is to show a […]

NI cryptographic checksum mismatch error: 12599

In testing of Oracle Enterprise Manager 11g R1 Grid Control we noticed frequent ORA-12599 errors in the alert logs of the monitored databases including the repository database. Upon further investigation we found that the ORA-12599 […]

Message #### not found when attempting to start the listener, tnsping, or SQL*Plus

Problem When attempting to start the listener you receive the following error. Or you may receive the following when attempting to use tnsping. Or you might have attempted a connection using SQL*Plus and received the […]

ORA-12154: TNS:could not resolve the connect identifier specified

Questions on this error seem to be a regular occurrence on Oracle related forums so I decided to add a post about it here. This post will demonstrate the error, how to look up the […]

Setting up Oracle Net Services Tracing on the Client and Server

Tracing the Oracle Net Services provides detailed information to aid in diagnosing connectivity issues. This document will detail the parameters used in tracing Oracle Net Services along with providing an example of tracing a connection […]

Using the OERR Utility to Aid in Error Investigation

Many Oracle products on UNIX have a utility called OERR that can be used to aid error investigation. The OERR utility is not documented so many new to Oracle on UNIX may not be aware […]

Data Guard Standby Archive Destination Full

Problem: You notice the following error in the alert.log of the Data Guard Standby database. Your Standby is configured to write its archive logs to the Fast Recovery Area. Solution: You have several of options […]

SET AUTOTRACE fails with error SP2-0618

Problem: You attempt to set autotrace and receive the following error message. Solution: The user executing AUTOTRACE needs to have the PLUSTRACE role. By default the PLUSTRACE role does not exist and can be created […]

Error: cannot restore segment prot after reloc: Permission Denied

When attempting to use SQL*Plus or other OCI based programs on either Red Hat Enterprise Linux or Oracle Enterprise Linux 5.0 or greater you receive errors such as the following.