sqlplus Connecting Hang?
SQL*Plus Network Issues At times, we see that some logins and connections are not responding and indefinitely hang in tools like SQL*Plus. In most cases,… Read More »sqlplus Connecting Hang?
Firewall
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-12170: TNS:Connect timeout occurred
ORA-12170 At some points, the client sides received intermittent ORA-12170 repeatedly: ORA-12170: TNS:Connect timeout occurred Meanwhile, the server side did not receive any errors either… Read More »How to Resolve ORA-12170: TNS:Connect timeout occurred