OraFAQ Forum: Server Administration » how to rectify this error?

Home » RDBMS Server » Server Administration » how to rectify this error?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to rectify this error? [message #226989]

Tue, 27 March 2007 01:15

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

Report message to a moderator

Re: how to rectify this error? [message #226991 is a reply to message #226989]

Tue, 27 March 2007 01:18

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: how to rectify this error? [message #228499 is a reply to message #226989]

Tue, 03 April 2007 04:12

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.

Report message to a moderator

Re: how to rectify this error? [message #228503 is a reply to message #228499]

Tue, 03 April 2007 04:29

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>

Report message to a moderator

Re: how to rectify this error? [message #228521 is a reply to message #226989]

Tue, 03 April 2007 05:04

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.

Report message to a moderator

Re: how to rectify this error? [message #228563 is a reply to message #228503]

Tue, 03 April 2007 06:37

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: how to rectify this error? [message #228568 is a reply to message #228563]

Tue, 03 April 2007 06:55

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.

Report message to a moderator

Previous Topic:	Is it Possible
Next Topic:	Passwords are not case sensitive!?!?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:24:06 CDT 2024