Oracle TNS

I recently assisted a user on OTN with an ora-12514 that was a bit more of a puzzle, and in the end resulted from the “interference” of the TWO_TASK environment variable.  My explanation to him looked very much like a good posting, so here’s the improved version. Background There are essentially two methods of establishing
Read More

In my previous post, Registering the Oracle Database with the listener,  I mentioned the role of the initialization parm LOCAL_LISTENER in dynamic registration of the database instance to the listener. Now I’d like to deliver on my promise to explore that piece of the puzzle. To quickly recap that post, there are two methods by
Read More

(This is a revised version of an article about ORA-12545 that I originally published at edstevensdba.wordpress.com.  At that time I was using Oracle 10g client on Windows XP.  While we have since moved on to newer versions of Oracle and Windows, the demonstrations using 10g are equally applicable to 11g and 12c installations.) Introduction to
Read More

(This is a revised version of an article I originally published at edstevensdba.wordpress.com.  At that time I was using Oracle 10g client on Windows XP.  While we have since moved on to newer versions of Oracle and Windows, the demonstrations using 10g are equally applicable to 11g and 12c installations.) Exploring the use of tnsping
Read More

(This is a revised version of an article I originally published at edstevensdba.wordpress.com.  At that time I was using Oracle 10g client on Windows XP.  While we have since moved on to newer versions of Oracle and Windows, the demonstrations using 10g are equally applicable to 11g and 12c installations.) Continuing the discussion of “why
Read More

(This is a revised version of an article I originally published at edstevensdba.wordpress.com.  At that time I was using Oracle 10g client on Windows XP.  While we have since moved on to newer versions of Oracle and Windows, the demonstrations using 10g are equally applicable to 11g and 12c installations.) Basic Client TNS (sqlnet) configuration
Read More

(This is a revised version of an article I originally published at edstevensdba.wordpress.com) Some of the most frequently asked questions on the Oracle Technology Network (OTN) forums deal with problems trying to connect to the database. Tracing the problem isn’t rocket science, but I often see people not paying attention to (or not trusting) the
Read More