Wednesday, July 31, 2013

ICC Cricket World Cup 2015 Schedule

Pool A: 
England, Australia, Sri Lanka, Bangladesh, New Zealand, Qualifier 2, Qualifier 3 

Pool B: 
South Africa, India, Pakistan, West Indies, Zimbabwe, Qualifier 1 (Ireland), Qualifier 4

(Qualifier 1,2,3 teams are yet to be decided)

Total Matches – 49       Hosts:  Australia – 26      New Zealand - 23
14-Feb Saturday  Sri Lanka vs New Zealand  Christchurch
14-Feb Saturday  England vs Australia  Melbourne
15-Feb Sunday  South Africa vs Zimbabwe  Hamilton 
15-Feb Sunday  India vs Pakistan Adelaide 
16-Feb Monday  West Indies vs Ireland  Nelson
17-Feb Tuesday  New Zealand vs Qualifier 3 Dunedin
18-Feb Wednesday  Bangladesh vs Qualifier 2  Canberra
19-Feb Thursday  Zimbabwe vs Qualifier 4 Nelson
20-Feb Friday  England vs New Zealand  Wellington
21-Feb Saturday  Pakistan vs West Indies  Christchurch
21-Feb Saturday  Australia vs Bangladesh  Brisbane 
22-Feb Sunday  Sri Lanka vs Qualifier 2 Dunedin
22-Feb Sunday  South Africa vs India  Melbourne
23-Feb Monday  England vs Qualifier 3 Christchurch
24-Feb Tuesday  West Indies vs Zimbabwe  Canberra
25-Feb Wednesday  Ireland vs Quallifier 4  Brisbane 
26-Feb Thursday  Qualifier 2 vs Qualifier 3 Dunedin
26-Feb Thursday  Sri Lanka vs Bangladesh  Melbourne
27-Feb Friday  South Africa vs West Indies  Sydney
28-Feb Saturday  Australia vs New Zealand  Auckland 
28-Feb Saturday  India vs Qualifier 4  WACA, Perth 
1-Mar Sunday  England vs Sri Lanka  Wellington
1-Mar Sunday  Pakistan vs Zimbabwe  Brisbane 
3-Mar Tuesday  South Africa vs Ireland  Canberra
4-Mar Wednesday  Pakistan vs Qualifier 4 Napier 
4-Mar Wednesday  Australia vs Qualifier 2 WACA, Perth 
5-Mar Thursday  Bangladesh vs Qualifier 3  Nelson
6-Mar Friday  India vs West Indies  WACA, Perth 
7-Mar Saturday  South Africa vs Pakistan  Auckland 
7-Mar Saturday  Zimbabwe vs Ireland  Hobart
8-Mar Sunday  New Zealand vs Qualifier 2 Napier 
8-Mar Sunday  Australia vs Sri Lanka  Sydney
9-Mar Monday  England vs Bangladesh  Adelaide 
10-Mar Tuesday  India vs Ireland  Hamilton 
11-Mar Wednesday  Sri lanka vs Qualifier 3 Hobart
12-Mar Thursday  South Africa vs Qualifier 4  Wellington
13-Mar Friday  Bangladesh vs New Zealand  Hamilton 
13-Mar Friday  England vs Qualifier 2  Sydney 
14-Mar Saturday  India vs Zimbabwe  Auckland 
14-Mar Saturday  Australia vs Qualifier 3  Hobart
15-Mar Sunday  West Indies vs Qualifier 4  Napier 
15-Mar Sunday  Pakistan vs Ireland  Adelaide 

18-Mar Wednesday  QF1  Sydney 
19-Mar Thursday  QF2  Melbourne
20-Mar Friday  QF3 Adelaide 
21-Mar Saturday  QF4  Wellington

24-Mar Tuesday  SF1  Auckland 
26-Mar Thursday  SF Sydney 

29-Mar Sunday  Final  Melbourne

Tuesday, July 23, 2013

Indian Badminton League Auction

Indian Badminton League is a franchise league proposed by Badminton Association of India (BAI). The inaugural edition of the IBL will take place from 14 August to 31 August 2013 in India, which will have Indian as well as foreign players. The player’s auction for the first IBL was held in Delhi on 22 July 2013. The league has 6 franchises.

Team Name
BOP Group
Gavaskar, Nagarjuna, Chamundeshwarnath
Krrish Group

Lee Chong Wei:

Lee Chong Wei, the No.1 badminton player in the world was bagged by Mumbai Masters for $ 135000 which is equivalent to Rs. 8,019,032 approximately. During IBL auction, this Malaysian icon got the franchises really excited, triggering a bidding war between Mumbai Masters and the Delhi Smashers.

Saina Nehwal:

Saina Nehwal, Indian badminton's leading champion, was picked by Hyderabad franchise, Hyderabad Hotshots for $ 120000. Since Hyderabad is the home town of this 23-year-old Olympic bronze medalist, her presence would give the franchise a huge boost. Her base price was set as $ 50,000.

Parupalli Kashyap:

Parupalli Kashyap, Commonwealth Games bronze-medalist was bought by Banga Beats for $ 75,000 (Rs4,455,622 approx). He also reached the quarter-finals of the Olympics at London last year.

Juliane Schnek:

World No.4 Juliane Schnek, the 30-year old German player was bought by the Delhi Smashers for $ 90000. Her base price was set at $ 50000.

PV Sindhu:

The Rising star, PV Sindhu was lapped by Lucknow Warriors for $ 80,000 (Rs4,752,664 approx). He has been hailed as one of the brightest stars of Indian badminton.

Tinh Minh Nyugen:

Tinh Minh Nyugen, Vietnamese player was bought by the Pune Pistons for a price of $ 44000. During auction, there was a bidding battle of sorts between Pune Pistons and Delhi Smashers.

Jwala Gutta:

The energetic doubles sensational star Jwala Gutta was bought by Delhi Smashers at $ 31,000 (Rs1,841,699). Jwala's base price was $ 25,000 (Rs1,485,241). Initially her base price was set as $ 50,000 but later reduced to half.

Tine Baun:

Tine Baun was sold at base price.  She is the oldest player to win the All-England Championship earlier this year.  Mumbai Masters bought Tine Baun at the base price of $ 30,000.

Taufiq Hidayat and Carsten Morgensen were sold at base price. Hyderabad Hotshots bought Hidayat at the base price of $15,000 and Banga Beats bought Carsten Morgensen of Denmark at his base price of $ 50000.

Malaysia's Boon Heung Jan was bought for $ 50,000, double the base price. V. Diju was bought by Delhi Smashers for $ 30,000. The doubles' specialist Joachim Fischer Nielsen was bought for $ 35,000 by Pune Pistons.

Manu Attriby was bought by Mumbai Masters for $ 10,000. Akshay Dewalkar was bought by Banga Beats for $ 36,000 and Tarun Kona by Hyderabad Hotshots for $ 28,000.

Wednesday, July 17, 2013

Oracle Upgrade from Oracle10g to Oracle11g

Below are the steps to Upgrade the Oracle database from to

Step 1) Installing Oracle 11g Home:

Install 11g database as a separate ORACLE_HOME in parallel to 10g Oracle Home.

Example my 10g Oracle Home is: D:\oracle10g\product\10.2.0\db_1, then my 11g Oracle Home is: E:\oracle\product\11.2.0\ db_1

Step 2) Pre-Upgrade Utility:

In 11g Home you installed, go to $ORACLE_HOME\rdbms\admin and copy the file 'utlu112i.sql' to some temp location (C:\temp).

Then login to the 10g oracle database AS SYSDBA and run 'utlu112i.sql' you copied to temp folder.

--This script provides information about databases to be upgraded to 11.2.

Step 3) Finding the Version of existing time zone files:

SQL> select * from v$timezone_file;

WHEN 183 then 1
WHEN 355 then 1
WHEN 347 then 1
WHEN 377 then 2
WHEN 186 then case COUNT (tzname) WHEN 636 then 2 WHEN 626 then 3 ELSE 0 end
WHEN 185 then 3
WHEN 386 then 3
WHEN 387 then case COUNT (tzname) WHEN 1438 then 3 ELSE 0 end
WHEN 391 then case COUNT(tzname) WHEN 1457 then 4 ELSE 0 end
WHEN 392 then case COUNT(tzname) WHEN 1458 then 4 ELSE 0 end
WHEN 188 then case COUNT(tzname) WHEN 637 then 4 ELSE 0 end
WHEN 189 then case COUNT(tzname) WHEN 638 then 4 ELSE 0 end
FROM v$timezone_names;

If the output is 4, then it is well and good and it requires no additional steps.

If the output of this is < 4 then prior to upgrade we need to apply the Timezone patch.

SQL> select banner from v$version;

It gives DB version and accordingly you have to find the patch at Metalink. Download the zipped patch and unzip it in temp folder (C:\temp).

Step 4) Applying Timezone patch:

Copy the files from location: C:\temp\patch_file\files\oracore\zoneinfo and paste it to existing Oracle 10g location “D:\oracle10g\oracore\zoneinfo”. Make sure to keep backup of existing folder so that you could revert if any problem occurs.

Bounce the database and check the TIMEZONE version again. Again run the 'utlu112i.sql' and by now, the timezone file version should be upgraded.

Step 5) Gather Dictionary stats:

You may have found some warning messages in the output of 'utlu112i.sql' execution. Please do execute the below scripts to avoid those warnings.

Connect as SYS user,




After executing the above recommended steps, run the pre-upgrade utility 'utlu112i.sql' once again to make sure, you don’t get any critical warnings.

Step 6) Starting Upgrade:

Copy the PFILE from 10g home to 11g home. In the copied PFILE, change the COMAPATIBLE parameter from '' to ''.

Delete the old listener service (10g) & create a new one using ORADIM utility.

Set the environment variables as in the below example.

SET ORACLE_HOME=C:\oracle11g\product\11.2.0\dbhome_1
SET PATH=C:\oracle11g\product\11.2.0\dbhome_1\bin:$PATH
SET TNS_ADMIN=C:\oracle11g\product\11.2.0\dbhome_1\NETWORK\ADMIN

Connect as SYS user,

sqlplus “/ as sysdba” –> will be connected to idle instance

SQL> startup upgrade;

ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Then run the Catalog Upgrade ‘catupgrd.sql’ located in $ORACLE_HOME\RDBMS\admin.

SQL> @catupgrd.sql

--This script is to be used for upgrading a 9.2, 10.1 or 10.2 database to the new release.  This script provides a direct upgrade path from these releases to the new Oracle release.

Once the upgrades finishes, it will shut down the database automatically.

Step 7) Post-Upgrade Steps:

Login again as SYS and start the database in normal mode. 


Check the dba_registry for the components and its status.

SQL> select comp_name,version, status from dba_registry;

Run utlu111s.sql to display the results of the upgrade:

SQL> @?/RDBMS/admin/utlu111s.sql

Run catuppst.sql, located in the ORACLE_HOME/rdbms/admin directory, to perform upgrade actions that do not require the database to be in UPGRADE mode:

SQL> @?/RDBMS/admin/catuppst.sql

Check if there are any invalid objects in the upgraded database.

SQL> select count (*) from dba_objects where status = ‘INVALID’;

If the invalid objects exist, run utlrp.sql to recompile.

SQL> @?/RDBMS/admin/utlrp.sql

SQL> select count (*) from dba_objects where status = ‘INVALID’;

This completes the upgrade.

Now the Pfile would be in 10g format. Shutdown the database, change the Pfile structure to 11g and bring it up.