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.