Say it’s that day again. You try to connect to a (new) database and once again you are facing SQL*Net problems.
C:/oracle/product/10.1.0/client/BIN>sqlplus /nolog SQL*Plus: Release 10.1.0.4.0 - Production ON Thu Sep 29 10:37:15 2005 Copyright (c) 1982, 2005, Oracle. ALL rights reserved. SQL> conn firstname.lastname@example.org ERROR: ORA-12154: 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]