lsnrctl start

How to Set Multiple Listeners in Database

by Ed Chen
November 24, 2022November 24, 2022

Multiple Listeners in LOCAL_LISTENER Theoretically, you don't have to configure parameters related to listener in database, neither LOCAL_LISTENER nor REMOTE_LISTENER. A background process Listener Registration… Read More »

How to Make a WhiteList for DB Connection

by Ed Chen
November 3, 2022November 18, 2022
2 Comments

Database Whitelist If there's only a few clients that use the database, we can make a whitelist to explicitly accept those clients. We take 2… Read More »

How to Make a BlackList for DB Connection

by Ed Chen
November 2, 2022November 18, 2022

Database Blacklist Unexpected connections may be seen in your listener log, we can make a blacklist to explicitly block those clients. We take 2 steps… Read More »

How to Resolve TNS-01201: Listener cannot find executable

by Ed Chen
October 11, 2021June 8, 2022

TNS-01201 After adding a static service to the local listener, I tried to start the listener, but it failed with TNS-01201. [oracle@test ~]$ vi $ORACLE_HOME/network/admin/listener.ora… Read More »