listener

How to Resolve ORA-00132: syntax error or unresolved network name

by Ed Chen
March 31, 2023March 27, 2023

ORA-00132 Found error ORA-00132 in the alert log, when we're starting up a database. 2023-03-01T22:41:54.802021-05:00 WARNING: Invalid value for listener related parameter MIXED LISTENER 2023-03-01T22:41:54.803545-05:00… Read More »

How to Resolve ORA-12162: TNS:net service name is incorrectly specified

by Ed Chen
March 29, 2023September 6, 2023

ORA-12162 To know how to solve ORA-12162 depends on where the database is. A local database? or an external database? Local Database (ORACLE_SID) A local… Read More »

Which Process Listening to Specific Port

by Ed Chen
March 24, 2023March 25, 2023

To check which process is listening to a specific port on Linux or AIX, we use commonly supported command netstat to know it: Check Port… 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 »

How to Resolve ORA-12526: TNS:listener: all appropriate instances are in restricted mode

by Ed Chen
November 17, 2021June 11, 2022

ORA-12526 When we tried to connect to the database, it failed with ORA-12526 like the following. SQL> conn hr/hr@orcl ERROR: ORA-12526: TNS:listener: all appropriate instances… Read More »

How to Open Port 1521 on Windows Server

by Ed Chen
October 26, 2019December 10, 2022

After our Oracle database 12.2 has been created on Windows server, we should open port 1521 on firewall for incoming connections. For Linux, you can… Read More »

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect

by Ed Chen
February 14, 2019August 18, 2023
28 Comments

ORA-12514 ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As… 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 Srvctl Add Listener to Default Network

by Ed Chen
December 26, 2016November 18, 2022
4 Comments

Cluster listeners have a very special feature that can generate endpoint listeners dynamically on all nodes, one for each, to establish the connections either from… Read More »

How to Resolve Listener Not Starting in RAC

by Ed Chen
June 5, 2016November 6, 2022

Listener Not Starting You may found out the listener seems not working: [oracle@primary01 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 05-JUN-2016… Read More »

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