Tuesday, August 26, 2008

Error Message

sqlplus user/user@cmspt42g
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


Description
Wrong permissions may be set on some files following installation
of the the 10gR2 base release (10.2.0.1).

eg: Some directories under $ORACLE_HOME have no world read nor
execute permission following the install (eg: rwxr-x---)

This can stop local users not in the oracle code owner group
from connecting using the bequeath driver.

Workaround:
Manually set the required permissions.
chmod -R 755 $ORACLE_HOME/*
or
Apply 10.2.0.2 or higher and run changeperm.sh
or
Download the one off patch for this bug and run changeperm.sh

Note:
A similar problem also occurs after applying the 9.2.0.7
Patch Set - that issue is covered under Bug 4533592.