ORA-12170: TNS:Connect timeout occurred

When I tried to connect to my database via SQLPLUS, I was getting the error "ORA-12170: TNS:Connect timeout occurred".  I understood that the error could be due to firewall issue or database down or listener down or bad sqlnet.ora parm or even because of network issue. I did check on everything and found the firewall block caused the issue in my Windows server 2008 R2. Now I have to turn off the firewall that blocks the database port.

How to Turn off Firewall for DB Port:

Navigate to Control Panel --> All Control Panel Items --> Windows Firewall, click on Turn Windows Firewall on or off option and check the status of Firewall. If it is On, turn it Off and try connecting to database.

If it works, then the problem is due to firewall blockage. Now turn it On and go back to Windows Firewall page. Click on Advance settings option; create a new rule as shown in the snapshot below.

Follow the below screenshots to know the options to be followed while creating the rule to unblock DB Port. 

Specify the DB port you have given while setting up the DB.

Whatever name and description give here will be reflected in the Inbound Rules page.

 

 

Now try connecting to the database. It worked for me and I hope this will help you as well. If you have any doubts, please feel free to comment on it.

If you find the error is because of slow network or system, then reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT,SQLNET.SEND_TIMEOUT,  SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access.  Also verify that your hosts file has a DNS entry. Eg: 102.54.94.97    

In Windows, the hosts file is located at win/system32/driver/etc/ and on UNIX, Linux, it is located in /etc/hosts. 

Java.lang.NullPointerException - Invocation Target Exception (Tuxedo Installation)

I was given a task to create a finance demo environment with PeopleTools 8.49 on Windows 2008 R2 machine with a plan upgrading the same later to PeopleTools 8.53. I created the database, installed web logic server and everything went fine. But when I tried installing the Tuxedo 9.1, it was throwing the errors as mentioned in the below screenshots.

I had installed the same earlier and it used to take hardly 5 minutes, but this time it took almost an hour in the first step (below) - GUI mode.

I decided to install the same in command prompt, but resulted the same with below message.

Please find the error message screenshots below. I have come across java null exception kind of messages in web server domain but when I experienced in Tuxedo install, I was completely lost. 

 

Guys… Don’t panic if you get into this situation. The solution is so simple and please follow the below instructions to resolve it.

Select the select file --> right click --> properties, select compatibility tab and check the compatibility mode tab, change the OS as Windows server 2003, then apply. Now start installing and it will go smoothly without any issues.

 

How To Enable Telnet In Windows Server 2008

Telnet is a network protocol used on the Internet or LAN to provide a bidirectional interactive text-oriented communication facility. Users of different platform use this facility mainly to check the communication between 2 servers or machines. In Windows Server 2008, Telnet is not enabled by default but included as a feature ‘Telnet Client’. Basically allows a computer to connect to a remote Telnet server and run applications on that server.

Unlike Windows 2003, if you give the Telnet command in Windows Server 2008 you will be promoted below message. 

 

Follow the below steps to enable Telnet on Windows Server 2008.

• Click Start  > Server Manager, Open Server Manager.
  
  
  
  
  
  
  In Server Manager, click on Features and then Click on Add Features.
  
  
  
  
  
  
  
  
  Select Telnet Client from the available list of features, then click Next.
  
  
  
  
  
   Installation in Progress...
  
  
  
  
  
  
  
  
  Installation is Completed .
  
  
  
  Now run the telnet command and as you expect, it is recognized by Windows Server 2008 and you can start using it to connect to your telnet servers.