Say it’s that day again. You try to connect to a (new) database and once again you are facing SQL*Net problems.
SQL*Plus: Release 10.1.0.4.0 - Production ON Thu Sep 2910:37:152005
Copyright (c)1982,2005, Oracle.ALL rights reserved.
SQL> conn firstname.lastname@example.org
TNS:could NOT resolve the CONNECT identifier specified
Blast!. What can you do? Once in a while i get a lot of these SQL*Net problems (network changes, etc, the wrong weather type). So to help you (and me), here i will you give you my grey-matter checklist (it’s not complete but should help you to resolve 80% of the problems) Read MoreSmall introduction to SQL*Net debugging [client side]
Sometimes you want to search for Oracle database messages, their meaning or you are in search of specific database event settings.
For instance, a long time ago i was searching for an event that would trace when an datafile would expand / autoextend. I encountered latching problems on a Siebel system based on an new Oracle Failsafe environment (Windows 2000 cluster). I wanted to be sure that these latching problems weren’t introduced by the newly introduced datafile AUTOEXTEND feature. Read MoreOERR – In search of Error Messages/Events