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 Resolve TNS-12541: TNS:no listener

Posted on
TNS-12541 Let’s see how we reproduce TNS-12541. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 22-JUL-2014 19:20:06 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) […]
Firewalld

How to Resolve TNS-12535: TNS:operation timed out

Posted on
TNS-12535 Let’s see how we reproduce TNS-12535. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 22-JUL-2014 19:03:21 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) […]
Listener

How to Prevent Remote Service Register with Listener

Posted on
A vulnerability related to TNS listener has been reported in Oracle Security Alert for CVE-2012-1675, which is disclosed as “TNS Listener Poison Attack”. Attackers may exploit it to manipulate database instances without any authentication. A remote user may exploit it to influence the confidentiality, integrity and availability of database systems. With applying Class of Secure […]