Tuesday, April 25, 2017

DBTutorial #1 - Setting Up Oracle Database 11G R2 on a Windows Machine

Learning databases begins with doing practical hands on a functional database application software. Database is used across all dimensions of software development and will always remain integral part of any application. In the upcoming series of tutorials that I am writing, we will focus on learning databases from beginner’s point of view. Currently in software industry, Oracle Database is the most widespread used software for deploying database for range of enterprise applications as per client’s needs.   Pre-requisite for learning Oracle Database is basic knowledge about database concepts and SQL queries.

Oracle Database installation is a simple process with easy to understand GUI installer provided with Oracle. In this tutorial, we will talk about setting up Oracle 11G R2 database on a windows machine (Windows 10). The oracle database can be installed on any Virtual machine as well like CentOS using VMWare about which we will cover in next set of tutorial as the steps will be a bit different as comparison to GUI setup of Oracle database. Also please note that this installation is for basic desktop class database setup to maintain simplicity. We will work on in-depth details in upcoming tutorials.

Download the Oracle 11G R2 database installation files from Oracle website. Follow the installation as per the steps described in the screenshots (Click on any screenshot to view larger screen resolution version).
  • Step 1 - Mount the database setup and click on setup

  • Step 2  -  Let Oracle Universal Installer perform required system diagnosis.

  • Step 3 - Oracle setup will launch

  • Step 4 - Enter your email id if you want to receive updates from Oracle. 

  • Step 5 - Select create and configure a database option and click next

  • Step 6 - Select Desktop class option as we want to set up a beginner level database for learning purpose. Server class option is mostly used when installing on Windows Server Operating system for deploying production level database catering to large number of users. 

  • Step 7 - Provide basic parameters like installation location, user id, passwords. Leave the Database edition and character set to default. Note down important parameters like global database name/password details in a separate notepad file for future references. 

  • Step 8 - Oracle universal installer will perform some prerequisite checks and provide summary of setup so far. Click Finish to begin the installation. 

  • Step 9 - Setup will start and will take 10-20 minutes depending upon your machine's hardware capacity. Sit back & relax till the installation finishes.

  • Step 10 - Allow access to JDK if windows firewall prompts a security alert. 

  • Step 11 - The setup will complete and Database configuration assistant will prompt summary of installation. You can use Password Management option to set/change passwords of default users. We will skip this for this point of time.

  • Step 12 - Oracle Database setup is now complete. Close the installer. 

  • Step 13 - Now it's time to check if Oracle Database is up and running or not on our system. We have two ways to do so - one from CMD and another from local host GUI oracle db manager. For CUI, open command prompt and type following command - C:\> set ORACLE_SID=orcl.
  • The oracle SID (System ID) is used to identify the database installed on a system. When we use this command, we instruct our system to work on a particular database. 

  • Step 14 - After setting ORACLE_SID, use following command to connect to SQL*Plus that will allow you to perform basic database administration tasks. 
c:\> sqlplus userid/password as sysdba

Once you are connected to SQL*Plus, use following command to retrieve the name of the database instance you are currently working on.

SQL > select name from v$database;

  • Step 15 - You can also access GUI console for managing your database. The local host URL will be generated at the end of the installation. Simply enter your user id and password. Select your role and connect to database.

  • Step 16 - Upon logging in, you will get the GUI console to administer your database. 

So after performing all these steps, we have confirmed that our database is finally setup and is up and running perfectly. 

In next set of tutorial we will continue further... Thanks for reading guys. 

Wednesday, April 19, 2017

The Corporate Retreat - A Weekend Getaway - JIM Corbett National Park

It was 5.30 PM in the evening. The usual time to wind up your day, pack your bags, flash your access card at the ODC gate, take the lift, board the bus and get lost in oblivion till you reach home.
However, this evening was different. This day was for breaking the usual routine. Yes, you guessed it right. It's team-building trip for the SITA project. People were all excited; the happiness of an office group tour was showing up on everyone's face. The state of bliss has already set up.

What a start of financial year 2017-2018. SITA IS & TCOE teams are heading to Jim Corbett national park for its team-building trip. Everyone was enthusiastic that evening. We finished our work, grabbed our new office T-shirts and started for the JIM Corbett around 11.30 pm after a brief by the HR team.

Boarding the bus late midnight with your team members, playing UNO cards, Bluff cards, Antakshari en route was an amazing experience. Nobody was going to sleep this night. Travelling late night always add a special appeal to any journey and with everyone together, this was going to be altogether an astonishing experience.

We took a break at 3 AM in Gajraula for some late-night tea and snacks. We clicked few pics, exchanged conversations with teammates and started our journey ahead. We finally reached our resort in the morning. The drive through midnight to the dawn was an amazing experience.

It was a refreshing experience in the Acorn Hideaway Resort. Away from life’s daily chores, everyone was in nature’s laps. Fresh air, green surrounding and the entire aura was mesmerising.
The resort became one big home for the SITA TCOE & IS family. As soon as people reached the resort, everyone headed to their rooms & got refreshed. Some moved towards the swimming pool and enjoyed while taking a dip in chilly water in early morning. For others, it was breakfast time. For some, it was time for Table tennis, snooker, badminton and a bit of Photography.

After having breakfast, it was time for the team building activities and games. Many people interacted with each other for the first time. For starters, team-building activities meant to incorporate cooperation, effort and dedication among a team with equal amount of fun. Relating the team building activities with the work we actually do back in our office, we find many common things between them. The overall idea behind a team-building event is about fostering a feeling of team spirit among everyone. The sense of togetherness that we developed in this team building will stay for long among all of us.

The big bash DJ party that was the most awaited part of the trip started in the evening. It was amazing to see how all the people rocked the dance floor. For audiophiles & hi-fi enthusiasts, the music was loud, clear and crisp. Everyone was musically high and for those moments, all were carefree from the concerns of life.

After enjoying the music followed by delicious dinner, we started immersing in the beauty of the resort. Sitting beside the swimming pool outside your cottage, with full moon in the sky and chatting up with your colleagues at 2 am in the night is one experience, no one will ever forget.

Next morning after catching some sleep, we all were ready to start back for our home. Nobody wanted to go back after spending eventful time here but we started back with hopes of going to another team-building event soon in the future. We started around 11 am and reached our homes in the evening. The team-building trip was so much fun. The team-building event and the memories that it gave us will be always close to our hearts and will cherished forever.