Which Process Listening to Specific Port
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 »Which Process Listening to Specific Port
listener
How to Run NETCA in Silent Mode
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 Run NETCA in Silent Mode
How to Resolve ORA-12526: TNS:listener: all appropriate instances are in restricted mode
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 Resolve ORA-12526: TNS:listener: all appropriate instances are in restricted mode
How to Open Port 1521 on Windows Server
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 Open Port 1521 on Windows Server
How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect
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 Resolve ORA-12514: TNS:listener does not currently know of service requested in connect
How to Configure SID_LIST_LISTENER Static Listener
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 to Configure SID_LIST_LISTENER Static Listener
How Srvctl Add Listener to Default Network
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 Srvctl Add Listener to Default Network
How to Resolve Listener Not Starting in RAC
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 »How to Resolve Listener Not Starting in RAC