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. Read more »
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 the view and any further attempt to drop the view would report success. However; an attempt to recreate the materialized view would result in an ORA-00955.
Read more »
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.
Read more »
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.
Read more »
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 similarity of this error number to ORA-12154.
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 method for diagnosis and resolution to a scenario in which an ORA-12543 is raised during the connection to a database.
Read more »
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 method for diagnosis and resolution to a scenario in which an ORA-12545 is raised during the connection to a database.
Read more »
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 error message, such as the one below, was generated every time a connection was made to the target database as SYSDBA through Oracle Enterprise Manager 11g R1 Grid Control.
Read more »
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 error and finally how to resolve the error.
Read more »