Firewall

How to Open Port on Windows Server

Posted on
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 refer to : How to Open Ports and Survives from Reboots Use ⊞ Win + F to search for “Windows Firewall with Advanced Security”, then click it. In “Inbound Rules”, […]
Listener

How to Add Static Service Registered in Listener

Posted on
Static Service Registration Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service can be used to service external connections with or without a running instance on the server. According to Oracle 18c Advanced Features of Oracle Net Services, the use […]
Listener

When Listener Seems Not Working in RAC

Posted on
You may found out the listener seems not working:[oracle@primary01 ~]$ lsnrctl statusLSNRCTL for Linux: Version 12.1.0.2.0 – Production on 05-JUN-2016 19:40:08Copyright (c) 1991, 2014, Oracle.  All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error  TNS-00511: No listener   Linux Error: 111: Connection refusedBut the incoming connections are all established and listener seems pretty healthy from […]