January 2016

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

In my previous article, ORA-12514: TNS:listener does not currently know of service, I demonstrated the relationships between a client requesting a connection to a database, and the database services known to the listener. In that article I focused only on the immediate cause of the error, deferring the discussion of exactly how databases get registered
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