Home » RDBMS Server » Server Administration » how to rectify this error?
how to rectify this error? [message #226989] Tue, 27 March 2007 01:15 Go to next message
sudharshan
Messages: 48
Registered: November 2006
Member
i am using oracle 10g in windows xp

1.Error 6 Initalizing SQL*plus
2.Mesage file sp1<lang>.msb not found
3.SP2 -0750 You may need to set ORACLE_HOME to your oracle home directory

Thanks and regards
sudharshan
Re: how to rectify this error? [message #226991 is a reply to message #226989] Tue, 27 March 2007 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You may need to set ORACLE_HOME to your oracle home directory

Just try it!

Regards
Michel Cadot
Re: how to rectify this error? [message #228499 is a reply to message #226989] Tue, 03 April 2007 04:12 Go to previous messageGo to next message
babai_74_cal
Messages: 6
Registered: April 2007
Location: Kolkata
Junior Member
There are several reasons for this error.
The First Solution is set the oracle sid and try to connect to sqlplus i.e.
c:\>Set oracle_sid<SID NAME>
c:\>Sqlplus /nolog
sqlplus>Connect / as sysdba

Second Solution:-
Go to my computer> right click>properties>Advanced>Environment variables>system variables>New.(Create your Oracle_HOME=SID_NAME)
Then connect to Sqlplus.
Re: how to rectify this error? [message #228503 is a reply to message #228499] Tue, 03 April 2007 04:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Both of the solutions you have proposed will not help the OP.

Maybe you meant to say:
babai_74_cal wrote on Tue, 03 April 2007 05:12

The First Solution is set the oracle sid and try to connect to sqlplus i.e.
c:\>Set oracle_sid<SID NAME>
c:\>Sqlplus /nolog
sqlplus>Connect / as sysdba

c:\>set oracle_home=<oracle_home_directory>
babai_74_cal wrote on Tue, 03 April 2007 05:12

Second Solution:-
Go to my computer> right click>properties>Advanced>Environment variables>system variables>New.(Create your Oracle_HOME=SID_NAME)
Then connect to Sqlplus.


Create your oracle_home=<oracle_home_directory>
Re: how to rectify this error? [message #228521 is a reply to message #226989] Tue, 03 April 2007 05:04 Go to previous messageGo to next message
babai_74_cal
Messages: 6
Registered: April 2007
Location: Kolkata
Junior Member
Yes I want to say that set the Oracle_Home directory with full path name.
Re: how to rectify this error? [message #228563 is a reply to message #228503] Tue, 03 April 2007 06:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Brian,

As we don't have any news from OP since my answer, I think it was THE answer and it solves his problem.

Regards
Michel
Re: how to rectify this error? [message #228568 is a reply to message #228563] Tue, 03 April 2007 06:55 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Michel Cadot wrote on Tue, 03 April 2007 07:37

As we don't have any news from OP since my answer, I think it was THE answer and it solves his problem.


Yep...I agree. I just didn't want others to get confused by babai_74_cal's post.
Previous Topic: Is it Possible
Next Topic: Passwords are not case sensitive!?!?
Goto Forum:
  


Current Time: Tue Dec 06 14:05:53 CST 2016

Total time taken to generate the page: 0.10643 seconds