How to resolve SP2-0750: You may need to set ORACLE_HOME in Oracle 10g

Hi,

This post will help you to set the ORACLE_HOME when you are getting error while connecting to SQL* plus like below

Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

How to unlock SCOTT account in Oracle 10g

Hi,

Oracle Corporation by default will provide the SCOTT user with tiger as password. Scott is the best user for beginners in Oracle. SCOTT User is providing the tables like EMP, DEPT which are having complex logic. As a Oracle beginners we can practice more on the Scott user table improve our knowledge in Oracle. So here I wanna show you how to unlock the SCOTT user, if it is locked by default.
When you are logging into the SCOTT user you may get errors like

ERROR:
ORA-28000: the account is locked.

Directory Creation and Navigation through Command Prompt

Hi,

This post will give you the clear idea how to navigate and create within the directories in Command prompt. This will help you to identify the directory location and you can easily understand the UNIX environment also. For the practice purpose I am going to show every folder(directory) creation with in the command prompt only.
To Start command prompt
1.Go to start->run-> and then type cmd or command (You can use WIN+R to get run directly)
2.Command window is opened with the current user. like below

C:\Users\SK>

Where C - > is root directory
   Users - > Folder which all the users are existing
    SK      - > I am the user(It will differ from system to system)

How to backup your Gmail

Hi Friends,

Google is providing such a excellent services to the internet users like Gmail, Google Drive, Piccasa, Adsense etc... Gmail is one of the free email service provided by Google.  It will provide 10GB of space for every Gmail User. If your gmail is full  and If you have all important mails in your inbox...? How you can backup..? Don't worry. Google is providing the Gmail-Backup-Tool for Gmails backup. It's free and You can Backup in a single click.!!!!

SImple Multiplication Trick (for Multiplication beginners)

Hi Friends,

        We have so many tricks for calculation of big numbers in simple way. Here am going to explain how to multiply 2 numbers simply with out any calculator. Hope it will be helpful for you to understand the Maths multiplication. But you should know multiplication basics before you try. I am going to explain 3 Math Multiplication Tricks.

1) 2 digit multiplication.
2) Square root of no which ends with 5 and
3) Square root of a Number after 85.