OraFAQ Forum: Client Tools » Error 6 initializing SQL*Plus

Home » Other » Client Tools » Error 6 initializing SQL*Plus

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

Error 6 initializing SQL*Plus [message #284989]

Mon, 03 December 2007 01:29

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi Friends,

when am running sqlplus with the user X, it's ok but when running with user Y I have this error:

"$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory"

The file sp1us.msb exists.

After I installed oracle, I did a backup of the file system using UFS Dump and re-stored back again.

Thank you,
Dirish

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #284993 is a reply to message #284989]

Mon, 03 December 2007 01:36

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Is ORACLE_HOME environment parameter set?

Regards
Michel

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #284994 is a reply to message #284993]

Mon, 03 December 2007 01:38

dirish
Messages: 232
Registered: November 2006

Senior Member

when I say

echo $ORACLE_HOME
/oracle/app/oracle/product/10gdb

That's my oracle home

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #284995 is a reply to message #284989]

Mon, 03 December 2007 01:39

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

>SP2-0750: You may need to set ORACLE_HOME to your Oracle >software directory"

Set ORACLE_HOME and try

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285002 is a reply to message #284994]

Mon, 03 December 2007 01:54

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You use the wrong command.
Try "env | grep ORACLE_HOME"

Regards
Michel

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285011 is a reply to message #285002]

Mon, 03 December 2007 02:02

dirish
Messages: 232
Registered: November 2006

Senior Member

env | grep ORACLE_HOME: not found

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285013 is a reply to message #285011]

Mon, 03 December 2007 02:05

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So you did not export the variable after setting it.
Export it now and this should work.

Regards
Michel

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285018 is a reply to message #285013]

Mon, 03 December 2007 02:15

dirish
Messages: 232
Registered: November 2006

Senior Member

when i say

export ORACLE_HOME=/oracle/x/x

i have the error

is not an identifier

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285024 is a reply to message #285018]

Mon, 03 December 2007 02:32

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Copy and paste what you do and what you have.
Use code tags and not red color.
Also post "which sqlplus"

Regards
Michel

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285030 is a reply to message #285024]

Mon, 03 December 2007 02:45

dirish
Messages: 232
Registered: November 2006

Senior Member

$

export $ORACLE_HOME=/oracle/app/oracle/product/10gdb

/oracle/app/oracle/product/10gdb=/oracle/app/oracle/product/10gdb: is not an identifier

SUN8>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 3 12:47:02 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285034 is a reply to message #285030]

Mon, 03 December 2007 02:50

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

set like this

$ export ORACLE_HOME=path_of_your_oracle_home_directory
$ go to Oracle BIN directory
bin]$ ./sqlplus /nolog
SQL>

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285039 is a reply to message #285034]

Mon, 03 December 2007 02:56

dirish
Messages: 232
Registered: November 2006

Senior Member

$ export ORACLE_HOME=/oracle/app/oracle/product/10gdb

ORACLE_HOME=/oracle/app/oracle/product/10gdb: is not an identifier

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285040 is a reply to message #284989]

Mon, 03 December 2007 03:04

varu123
Messages: 754
Registered: October 2007

Senior Member

Try

ORACLE_HOME=/oracle/app/oracle/product/10gdb
export ORACLE_HOME

env | grep ORACLE_HOME

[Updated on: Mon, 03 December 2007 03:06]

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285043 is a reply to message #285039]

Mon, 03 December 2007 03:16

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is your shell?
Post "ps"

Regards
Michel

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285047 is a reply to message #284989]

Mon, 03 December 2007 03:22

varu123
Messages: 754
Registered: October 2007

Senior Member

Quote:

$

export $ORACLE_HOME=/oracle/app/oracle/product/10gdb

/oracle/app/oracle/product/10gdb=/oracle/app/oracle/product/10gdb: is not an identifier

SUN8>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 3 12:47:02 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Don't use $ sign in export

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285048 is a reply to message #285040]

Mon, 03 December 2007 03:27

dirish
Messages: 232
Registered: November 2006

Senior Member

$ ORACLE_HOME=/oracle/app/oracle/product/10gdb
$ export ORACLE_HOME

$

$ env | grep $ORACLE_HOME

LD_LIBRARY_PATH=:/oracle/app/oracle/product/10gdb/lib:/oracle/app/oracle/producb
ORACLE_HOME=/oracle/app/oracle/product/10gdb
ORACLE_SQL=/oracle/app/oracle/product/10gdb/bin
PATH=/oracle/app/oracle/product/10gdb/bin:/usr/bin
$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285049 is a reply to message #285043]

Mon, 03 December 2007 03:27

dirish
Messages: 232
Registered: November 2006

Senior Member

$ ps
PID TTY TIME CMD
2209 pts/4 0:00 sh
2216 pts/4 0:00 ps

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285050 is a reply to message #285047]

Mon, 03 December 2007 03:28

dirish
Messages: 232
Registered: November 2006

Senior Member

$ export ORACLE_HOME=/oracle/app/oracle/product/10gdb

ORACLE_HOME=/oracle/app/oracle/product/10gdb: is not an identifier

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285531 is a reply to message #284989]

Wed, 05 December 2007 00:09

varu123
Messages: 754
Registered: October 2007

Senior Member

Quote:

echo $ORACLE_HOME

Quote:

You use the wrong command.
Try "env | grep ORACLE_HOME"

Michel,
WHy it is a wrong command?

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285549 is a reply to message #285531]

Wed, 05 December 2007 00:39

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Because you can have a local variable that is not an environment variable and so is not visible in the children process.

> MYVAR=toto
> echo $MYVAR
toto
> env | grep MYVAR
> sh
$ echo $MYVAR

$ exit
> export MYVAR
> env | grep MYVAR
MYVAR=toto
> sh
$ echo $MYVAR
toto
$ env | grep MYVAR
MYVAR=toto
$ exit
>

Regards
Michel

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285551 is a reply to message #285531]

Wed, 05 December 2007 00:41

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi Friends ,

I finally found the solution, in fact the user wlogic is in group wlogic. So, I just added the user wlogic to group dba and this solved my problem.

Thank you,
Dirish

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285573 is a reply to message #285551]

Wed, 05 December 2007 01:23

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

this solved my problem

And open for many new ones.
Do you realize that now your user can now detroy your database or do anything he wants.

Regards
Michel

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285577 is a reply to message #285573]

Wed, 05 December 2007 01:27

dirish
Messages: 232
Registered: November 2006

Senior Member

Yea you are right.

I have installed oracle10g client on this server where my users will use sqlplus and sqlldr.
This is not my data server.

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285578 is a reply to message #285577]

Wed, 05 December 2007 01:33

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I can release by breath. Surprised

Surprised

Regards
Michel

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285639 is a reply to message #285549]

Wed, 05 December 2007 03:25

varu123
Messages: 754
Registered: October 2007

Senior Member

but ORACLE_SID is an environment variable.Whats the diffrence?
From where would echo $ORACLE_SID get its value?
env | grep $ORACLE_SID would search the entire ./profile file.

Report message to a moderator

Re: Error 6 initializing SQL*Plus [message #285643 is a reply to message #285639]

Wed, 05 December 2007 03:47

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is ONLY an environment variable if you declare it such, that is export it in sh, ksh...

Quote:

env | grep $ORACLE_SID would search the entire ./profile file.

I don't understand, "env" does not search in .profile, it searches in your environment (a memory area).

Regards
Michel

Report message to a moderator

Previous Topic:	sql developer
Next Topic:	Compare Data Using Toad ToolBar, Tools --> Compare Data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 22:30:45 CDT 2024