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)