Oracle listener

This content has been relocated to https://edstevensdba.wordpress.com/2018/09/17/a-few-points-about-dynamic-registration/ Due to my pending retirement, edstevensdba.com will be shut down on 1 Dec. 2018. All important content is being relocated to edstevensdba.wordpress.com for on-going reference.

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