listener.ora

How to Revert Read-Only Oracle Home 21c Linux

by Ed Chen
July 10, 2023August 31, 2023

Read-Only Oracle Home After installing Oracle database 21c on Linux, we found that some features are different from our sense. That's because Read-Only ORACLE_HOME is… Read More »

How to Run NETCA in Silent Mode

by Ed Chen
February 13, 2023June 6, 2023

By design, we split the entire installation into several clear sections and make the job easy to troubleshoot. Install Oracle Software Only in Silent Mode… Read More »

Alter System set Local_Listener Multiple Examples

by Ed Chen
November 24, 2022June 27, 2023

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 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 »

How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect

by Ed Chen
March 20, 2021June 30, 2022

ORA-12505 ORA-12505 means that the SID you provided in the connect identifier does not match any SID registered with the listener. Basically, SID means $ORACLE_SID,… Read More »

How to Configure SID_LIST_LISTENER Static Listener

by Ed Chen
August 3, 2018December 11, 2022

SID_LIST_LISTENER Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service… Read More »

How Oracle Auto Start Database in Solaris

by Ed Chen
March 31, 2018December 11, 2022
2 Comments

For Linux Os, you should check this post: How to Auto Start Oracle Database on Linux. Assuming that you already have some knowledge about how… Read More »

How Oracle Auto Start Database in Linux

by Ed Chen
March 24, 2018December 11, 2022
4 Comments

For Solaris OS, you should check this post: How to Auto Start Oracle Database on Solaris. Assuming that you already have some knowledge about how… Read More »

How to Resolve TNS-12546 Error Message

by Ed Chen
February 10, 2018October 3, 2021
4 Comments

TNS-12546: TNS:permission denied I got TNS-12546 when I tried to start the listener as oracle. oracle@solaris11vm:~$ lsnrctl startLSNRCTL for Solaris: Version 11.2.0.4.0 - Production on… Read More »

Why Tnsping Hang

by Ed Chen
April 9, 2017March 25, 2023

sqlplus, tnsping or lsnrctl Hangs I can't cover all situations in this post, but I have some cases to share with you. Those hanging all… Read More »

JavaScript is not enabled. Please enable it and reload the page.