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.

 

WIMBLEDON 2013 CHAMPIONS

 

The huge event Wimbledon 2013 bids adieu with lot of exciting games and moments. It has shown the mixture of hard work, emotion, human value, excitement, temperament, pride and the list goes on. May the best win is the mantra of Wimbledon and this year the Wimbledon 2013 championship was bagged by Andy Murray and Marion Bartoli in men & women’s singles event respectively.

 

 

Andy Murray wins Wimbledon 2013 men's final with straight-sets victory over Novak Djokovic. British tennis has been waiting for this moment for almost 77 years and the wait is over now. Murray became the first British men’s singles winner at The Lawn Tennis Championships since Fred Perry in 1936. He is also the first British man to win Wimbledon in short trousers. “Winning Wimbledon is the pinnacle of tennis,” said Andy Murray. He added that the few days before the tournament are really difficult and for the last four or five years, it’s been very, very tough, very stressful, a lot of pressure. 

 

Murray had a story of lot of tough losses, but every year he had been finding little bit of improvement which everyone could sense with the way his ranking was going. He admitted that he did not want to go to sleep last night in case his Wimbledon win turned out to be a dream. In the dramatic final game, even after winning two sets against Djokovic, Murray was not able to breathe easy as everyone knows the recovery caliber of Novak and he could bounce back from nowhere and so the environment, but finally the day went in favour of the British man.

 

Marion Bartoli beats Sabine Lisicki in straight sets to win Wimbledon 2013 women's singles final. Winning her first grand slam title with this dominant 6-1, 6-4 victory and dominating throughout the entire tournament without dropping a set shows her caliber and I would say the cup deserves her rather than saying she deserves the cup. Her father Walter was the pillar behind her and he was the one whom she thanked most generously, the one she embraced most tenderly when it was all over. Her happiness reflected in her words. She expressed her joy as “You went through pain, you went through tears, and so in those five or 10 seconds before you shake the hand of your opponent you feel almost like you are not walking any more on Earth.” Bartoli has established a reputation as a fast learner. She has recorded an IQ of score of 175, as well as showcasing ability this fortnight to recite the Fibonacci sequence by rote. 

Bartoli had won £1.6m for her first grand slam title and when she was asked about that she replied "I don't even know how much I won, so it will be a surprise and that's not what I'm thinking about right now, I don't even realize I won Wimbledon so the first step is for me to actually realize that I won Wimbledon, then we'll see what is happening with the money."The opponent in the final Sabine Lisicki dissolved in tears after the first set as she had not offered even a glimpse of her best. As Lisicki began to cry midway through the second set, Bartoli said she wanted to "give her a hug" but her empathy is matched by her drive and her determination to win.

 

ICC World Championship Events

The BCCI (Board of Control for Cricket in India) was awarded the two events during the ICC (International Cricket Council) Annual Conference held in London on Saturday. The ICC finalized its global events from 2015 to 2023 during the conference and it has been confirmed that BCCI would host the World Twenty20 in 2016 and 50-over World Cup in 2023. Also India is hosting second edition of ICC World Test Championship in 2021. The inaugural ICC World Test Championship will be hosted by England and Wales Cricket Board (ECB) in 2017.

  

ICC World Championship Events:

World Twenty20 (2014)  -  Bangladesh

World Twenty20 (2016)  -  BCCI (India)

ICC World Test Championship (2017)  -   ECB (England)

50-over World Cup (2019)  -   ECB (England)

World Twenty20 (2020)  -  CA  (Australia)

ICC World Test Championship (2021)  -   BCCI (India)

50-over World Cup (2023)  -   BCCI (India)

Also the ICC decided that full members have to play a minimum of 16 Tests over a four-year period to retain their Test status. To make sure that all ODIs played over the four-year cycle between ICC Cricket World Cups count towards a team's ranking, the ICC Board agreed to change the ODI rankings period from three years to four years. Afghanistan was confirmed as the 37th Associate Member of the ICC and Romania was accepted as an Affiliate Member.

Missing or invalid version of SQL library PSORA

When I tried logging into data mover after creating a shell database in Windows OS, below  error popped up. Also once I have experienced the same error in log file while booting up the application server domain. 

PeopleSoft has been making the move from a 32bit application to a 64bit application and it would be working everywhere in 64bit mode, except for in windows. So if you encounter this error, make sure that the 32-bit libraries are installed and are being referred to for the client. Install 32 bit Oracle client, provide listener configuration information in it and add the 32-bit bin path in pointing to 'Add to PATH' parameter in psappsrv.cfg and try to login. Your issue will be resolved. Also ensure the DBBIN parameter in psprcsrv.cfg points to 32-bit Oracle bin path.

INDIA Lifts ICC Champions Trophy 2013

India once again proved everyone that they are the real champions after defeating England in ICC Champions Trophy final and retains the No 1 spot in One-Day International team list. India has won all five of their matches after a pair of warm-up victories in this Champions Trophy, thereby backing up their 2011 World Cup win with another ODI trophy. India has won six games in succession in the ICC Champions Trophy and also is the first team to win the final of the ICC Champions Trophy batting first.

This is the rightly balanced team with an average age of 26-27 and energetic lads like Virat Kohli, Suresh Raina, Ravindra Jadeja, Rohit Sharma, Shikhar Dhawan and Dinesh Karthik who have show and n the world what they are capable of, it came to such a point that the international media covering the tournament labeled the Indians the best fielding unit in the world — something unheard of in the past. 

MS Dhoni (31), the oldest of current team is the first captain to win all three ICC trophies - ICC World Cup, ICC World Twenty20 and the ICC Champions Trophy. Shikhar Dhawan has established an Indian record for the highest run-aggregate with strike rate of 100-plus in an ICC Champions Trophy competition - 363 runs (ave.90.75) in five matches, including two hundreds and a fifty. He has also received his first Player of the series award in ODIs. Ravindra Jadeja is the leading wicket-taker with 12 wickets at 12.83 runs apiece. He is the MOM of the final and is his fourth MOM award against England is his seventh in ODIs.