RSS

Tag Archives: vijay.mahawar

Awarded “High Ranking in Month” by Oracle PL/SQL Challenge

TrophyDear Friends,
I am ecstatic to share with you that I have been awarded by Oracle PL/SQL Challenge, an online website which offers a daily quiz on Oracle PL/SQL. The website has  quickly attracted over 1,000 daily players, making it one of the most active PL/SQL-related websites on the Internet.

I am awarded for “High Ranking in Month” for September 2015 and November 2015 in their competition “I Love Logic“.

High Ranking in Month for November 2015

High Ranking in Nov 2015

High Ranking in Month for September 2015

High Ranking in Sep 2015

Public recognition of accomplishment on PLSQL Challenge website

Accomplishment
The number next to my name shows my points on website till date.

Its an honour to win this award among 1400 active participants from across the globe 🙂 Thanks Oracle and PL/SQL Challenge for the public recognition of my accomplishment 🙂

Here is the link to the webpage which shows my accomplishment. The link to my public profile on Oracle PL/SQL Challenge is here.

Cheers!
Vijay Mahawar

 
Leave a comment

Posted by on December 12, 2015 in Oracle, PL/SQL

 

Tags: , , , , ,

Date with Self

Last updated on October 14th, 2021 at 05:38 pm

Dear All,
In my pursuit to know myself better, I wrote few lines, which I am sharing with you all.
Presenting to you my original creation – ‘Date with Self’:

Photo: Sunset view from Kua Khai bridge in Cuttack, Odisha, India

I ask myself often who am I?   
Birthplace says Tamilian,
Parents place says Bengali,
Family Roots says Hindi,
Patriotic self says Indian,
Wisdom says one world family.

I ask myself often who am I?    
Child within me says innocent,
Adult in me reveals shy,
Youth in me declares confident,
Man in me replies patience.

I ask myself often who am I?
Engineer in me recommends search on internet,
Chess player in me advices strategist,
Shutterbug in me says natural,
Moviegoer in me suggests genuine,
Fitness freak in me says healthy,
Meditator in me intuits astral.

I ask myself often who am I?
Body says mortal,
Breathe says in rhythm,
Mind says sharp,
Intelligence says master,
Memory says limitless,
Ego says don’t know,
Soul says pure.

I ask myself often who am I?
Attire exhibits formal,
Pen writes southpaw,
Backpack says systematic,
Water bottle says clear and fresh.

I ask myself often who am I? 
Keyboard types  * (read star),
Speaker plays popular,
Mouse clicks soft,
Screen displays bright.

I ask myself often who am I?
Twitter tweets @vmahawar
Instagram mentions @vijay.mahawar
Pinterest pins vmahawar
Website address www.mahawar.net

– Vijay

PS: Every time I ask this question, I get different answers. I hope one day will come, when I will have all the answers and I shall be enlightened 🙂

 
Leave a comment

Posted by on August 28, 2015 in General, Yoga

 

Tags: , , , , , ,

We Shall Overcome Someday – हम होगें कामयाब एक दिन (Hum Honge Kamyab Ek Din)

Last updated on January 16th, 2016 at 02:57 pm

Song: We Shall Overcome Someday
Singer(s): Joan Baez

Lyrics for English Version – We Shall Overcome Someday

We shall overcome, we shall overcome,
We shall overcome someday;
Oh, deep in my heart, I do believe,
We shall overcome someday.

The Lord will see us through, The Lord will see us through,
The Lord will see us through someday;
Oh, deep in my heart, I do believe,
We shall overcome someday.

We’re on to victory, We’re on to victory,
We’re on to victory someday;
Oh, deep in my heart, I do believe,
We’re on to victory someday.

We’ll walk hand in hand, we’ll walk hand in hand,
We’ll walk hand in hand someday;
Oh, deep in my heart, I do believe,
We’ll walk hand in hand someday.

We are not afraid, we are not afraid,
We are not afraid today;
Oh, deep in my heart, I do believe,
We are not afraid today.

The truth shall make us free, the truth shall make us free,
The truth shall make us free someday;
Oh, deep in my heart, I do believe,
The truth shall make us free someday.

We shall live in peace, we shall live in peace,
We shall live in peace someday;
Oh, deep in my heart, I do believe,
We shall live in peace someday.

Song: हम होगें कामयाब एक दिन (Hum Honge Kamyab Ek Din)
Singer(s): Unknown

Lyrics for Hindi Version – हम होगें कामयाब एक दिन (Hum Honge Kamyab Ek Din)

होंगे कामयाब होंगे कामयाब
हम होंगे कामयाब एक दिनहो
हो हो मन मे है विश्वासपुरा है विश्वास
हम होंगे कामयाब एक दिन॥धृ॥

hoṁge kāmayāba hoṁge kāmayāba
hama hoṁge kāmayāba eka dina
ho ho ho mana me hai viśvāsa
purā hai viśvāsa hama hoṁge kāmayāba eka dina ||dhṛ||

होगी शान्ती चारो ओर
होगी शान्ती चारो ओर
होगी शान्ती चारो ओर एक दिन
हो हो हो मन में है विश्वास
पूरा है विश्वास होगी शांती चारो ओर एक दिन ॥१॥

hogī śāntī cāro ora
hogī śāntī cāro ora
hogī śāntī cāro ora eka dina
ho ho ho mana meṁ hai viśvāsa
pūrā hai viśvāsa hogī śāṁtī cāro ora eka dina ||1||

हम चलेंगे साथ साथ
डाले हाथोमें हाथ
हम चलेंगे साथ साथ एक दिन
हो हो हो मन में है विश्वास
पूरा है विश्वास हम चलेंगे साथ साथ एक दिन॥२॥

hama caleṁge sātha sātha
ḍāle hāthomeṁ hātha
hama caleṁge sātha sātha eka dina
ho ho ho mana meṁ hai viśvāsa
pūrā hai viśvāsa hama caleṁge sātha sātha eka dina ||2||

नही डर किसी का आज
नहि भय किसी का आज
नहि डर किसी का आज के दिन
हो हो हो मन में है विश्वास
पूरा है विश्वास नही डर किसी का आज एक दिन ॥३॥

nahī ḍara kisī kā āja
nahi bhaya kisī kā āja
nahi ḍara kisī kā āja ke dina
ho ho ho mana meṁ hai viśvāsa
pūrā hai viśvāsa nahī ḍara kisī kā āja eka dina ||3||

Some other similar songs which you might like are:
Humko Mann Ki Shakti Dena
Itni Shakti Hame Dena Data
Aye Maalik Tere Bande Hum

Visit Vijay’s photo gallery here – “Through his lens!” and know about him more here

 
Leave a comment

Posted by on October 21, 2013 in Entertainment

 

Tags: , , , , , , , , , ,

Steps for Installing RAC with ASM on Oracle Database 12c

Last updated on January 17th, 2016 at 06:56 am

Hi Friends,

In  continuation to my previous posts on Workshop on RAC and ASM and 12c New Feature Pluggable Database. Today I am posting the installation steps for RAC with ASM on the latest Oracle Database 12c release, which I managed to install on my laptop.

Disclaimer: Please consider this as only checklist and steps and not a end-to-end installation guide to install RAC with ASM on Oracle Database 12c.

Following is the list of steps which I had performed for my installation:

1. Download Oracle VM VirtualBox from here.
2. Download Oracle Enterprise Linux 6 from Edelivery

EDelivery-Oracle-12c-Database-Grid-

EDelivery-Oracle-12c-Database-Grid-

3. Download Oracle 12c Database for Linux 64 bit (2 Parts – size ) from Edelivery (highlighted in above image)
4. Download Oracle 12c Database Grid for Linux 64 bit (2 Parts – size ) from Edelivery (highlighted in above image)
5. Install VM Virtual Box and OEL 6 on VM Virtual Box.
VirtualBox Guest Additions Package can be installed from this location. Post installation it will prompt you to install the extension package which can be downloaded from here.
6. OEL6 comes with pre-installed oracle users and oinstall users. Ensure that you select the package oracle-rdbms-server-11gR2-preinstall available under system tools. More information on this is available here.
7. At this point, its better if you take the snapshot of your virtual machine. This would help you to avoid repeating the previous steps incase of any issues.
8. Setup the .bash_profile, grid_env and db_env in oracle user home directory.
9. Setup the public ip address, vip address, private address and scan address in the /etc/hosts file.
10. Create directory for oracle database and inventory.
11. Copy the Oracle Software and Grid Software to the path you had mentioned in the .bash_profile.
12. Go to the Grid/rpm directory and install rpm cvuqdisk-1.0.9-1.rpm.
13. Create ASM disks and make it shareable. Login as root  partition the disks created under /dev using fdisk command.
14. Install oracleasmlib-2.0.4-1.el6.x86_64.rpm. Use the oracleasm command to createdisks for asm using the disks created in step 12.
15. Clone the Virtual Machine for second node. Ensure that firewall on both the machine are disabled.
16. Configure the second node for Network (for public address and vip address)
17. Setup the SSH password less connectivity to avoid the user equivalence error.
18. Copy the Oracle 12c database files in the inventory location (under /u01)
19. Install the Grid (from /u01/grid/runInstall)
20. This will invoke Installer for Oracle Grid Infrastructure. The wizard includes 13 steps. Including mainly cluster configuration and Creation of ASM Disk Groups.
21. Now, the system is ready to install the Oracle 12c Database (goto /u01/database and run ./runInstaller)
22. At this point, its better if you take the snapshot of your virtual machine again. This would help you to avoid repeating the previous steps in case of any issues.
23. The above command will launch the Oracle Database 12c Release 1 Installer, which is again a 13 steps.
24. Login into the sqlplus and confirm the installation. As shown in below screenshot:
OEL6-12c-DB-RAC1

Some Errors which I came across while installing RAC with ASM:

1. OEL6 by default gets installed without desktop and GUI. Default package installation of OEL6 does not include desktop GUI installation. This was resolved by clicking on custom option and selecting the desktop view. (You can also choose either gnome or kde)
2. User Equivalence Error.  This was resolved by setting the SSH connectivity and disabling the firewall.
3. Network ethernet settings post clone were not set up properly this led to error while setting up the cluster settings at the time of GRID installation.
4. I missed out step to install cvuqdisk-1.0.9-1.rpm.
5. ASM location was not showing during the GRID installation. This was due to the missing oracleasm rpm.
6. First installation failed because of shortage of disk space. Only 25GB of disk space which was allocated. This was resolved by allocating 35GB to the virtual disk. In addition to this I had allocated 5GB to each ASM disks. Making the total space for the installation for 1 rac node 50GB and if I include the clone node the total installation used up 85GB. Since ASM disks were shared between the nodes.
7. During the Database installation. Database was showing as ‘orcl.localdomain’ by default. This had to be changed to RAC as configured in the .bash_profile file.

Hope you find this steps and content useful for installing RAC on Oracle 12c with ASM. Please feel free to leave your comments.

Happy ‘RAC’ ing 🙂
Cheers!
Vijay

Visit Vijay’s Oracle photo gallery here and know more about him here

 
Leave a comment

Posted by on August 28, 2013 in DBA, Oracle

 

Tags: , , , , , , , , ,

High Accuracy in Week (18 February 2012) in PL/SQL Challenge

Last updated on November 26th, 2014 at 07:07 am

I am delighted to share with you all that I am awarded “High Accuracy in Week” by PL/SQL Challenge.
The award is for the week 18th February 2012. The prize I received is Amazon.com US$25 Gift Card 🙂

Visit my public profile on PL/SQL Challenge for other achievements

Cheers!

 
Leave a comment

Posted by on February 20, 2012 in Oracle, PL/SQL

 

Tags: , , ,

Rise of WHIZARD in World of Oracle DBA

Last updated on November 26th, 2014 at 07:08 am

This is my first stint in the blogging world. I have always wanted to write on my personal and professional life. I tried to do this couple of occasions but could not persist with the idea and hence had to give up. But today I have managed to create an account and put some life into the blog.

I hale from India and see the pace at which technology change in last couple years its breathtaking.

The land which used to be related to snake charmers and folk dances, is today considered to be one of the richest country in terms of the IT resources.

I am proud to say that origin of any new idea, gadget, device, software has not been achieved without participation of my country.

I take this blog as a medium to exchange my technical expertise, my experience in job and life so far. I also seek advice, guidance from the members and readers from all corners of the world (if there exist a corner in world!!! which is spherical in shape ;-). To know more about me click here.

Cheers.

 
Leave a comment

Posted by on September 6, 2008 in General, Oracle

 

Tags: , , , , , , ,

 
snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake