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 […]
Category: Troubleshooting
SP2-0768: Illegal SPOOL command
Recently I ran into a problem were executing a SQL script where I received an SP2-0768: Illegal SPOOL command.
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 […]
Linux Error 111: Connection refused
When attempting to start the listener you get an error like the one below.
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.