Home » SQL & PL/SQL » Client Tools » Error 6 initializing SQL*Plus
Error 6 initializing SQL*Plus [message #284989] Mon, 03 December 2007 01:29 Go to next message
dirish
Messages: 205
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



Re: Error 6 initializing SQL*Plus [message #284993 is a reply to message #284989] Mon, 03 December 2007 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is ORACLE_HOME environment parameter set?

Regards
Michel
Re: Error 6 initializing SQL*Plus [message #284994 is a reply to message #284993] Mon, 03 December 2007 01:38 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
when I say

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


That's my oracle home
Re: Error 6 initializing SQL*Plus [message #284995 is a reply to message #284989] Mon, 03 December 2007 01:39 Go to previous messageGo to next message
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
Re: Error 6 initializing SQL*Plus [message #285002 is a reply to message #284994] Mon, 03 December 2007 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You use the wrong command.
Try "env | grep ORACLE_HOME"

Regards
Michel
Re: Error 6 initializing SQL*Plus [message #285011 is a reply to message #285002] Mon, 03 December 2007 02:02 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
env | grep ORACLE_HOME: not found
Re: Error 6 initializing SQL*Plus [message #285013 is a reply to message #285011] Mon, 03 December 2007 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
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
Re: Error 6 initializing SQL*Plus [message #285018 is a reply to message #285013] Mon, 03 December 2007 02:15 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
when i say

export ORACLE_HOME=/oracle/x/x

i have the error

is not an identifier
Re: Error 6 initializing SQL*Plus [message #285024 is a reply to message #285018] Mon, 03 December 2007 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
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
Re: Error 6 initializing SQL*Plus [message #285030 is a reply to message #285024] Mon, 03 December 2007 02:45 Go to previous messageGo to next message
dirish
Messages: 205
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.
Re: Error 6 initializing SQL*Plus [message #285034 is a reply to message #285030] Mon, 03 December 2007 02:50 Go to previous messageGo to next message
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>



Re: Error 6 initializing SQL*Plus [message #285039 is a reply to message #285034] Mon, 03 December 2007 02:56 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
$ export ORACLE_HOME=/oracle/app/oracle/product/10gdb
ORACLE_HOME=/oracle/app/oracle/product/10gdb: is not an identifier
Re: Error 6 initializing SQL*Plus [message #285040 is a reply to message #284989] Mon, 03 December 2007 03:04 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your shell?
Post "ps"

Regards
Michel
Re: Error 6 initializing SQL*Plus [message #285047 is a reply to message #284989] Mon, 03 December 2007 03:22 Go to previous messageGo to next message
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
Re: Error 6 initializing SQL*Plus [message #285048 is a reply to message #285040] Mon, 03 December 2007 03:27 Go to previous messageGo to next message
dirish
Messages: 205
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
Re: Error 6 initializing SQL*Plus [message #285049 is a reply to message #285043] Mon, 03 December 2007 03:27 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
$ ps
PID TTY TIME CMD
2209 pts/4 0:00 sh
2216 pts/4 0:00 ps
Re: Error 6 initializing SQL*Plus [message #285050 is a reply to message #285047] Mon, 03 December 2007 03:28 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
$ export ORACLE_HOME=/oracle/app/oracle/product/10gdb

ORACLE_HOME=/oracle/app/oracle/product/10gdb: is not an identifier
Re: Error 6 initializing SQL*Plus [message #285531 is a reply to message #284989] Wed, 05 December 2007 00:09 Go to previous messageGo to next message
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?
Re: Error 6 initializing SQL*Plus [message #285549 is a reply to message #285531] Wed, 05 December 2007 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
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
Re: Error 6 initializing SQL*Plus [message #285551 is a reply to message #285531] Wed, 05 December 2007 00:41 Go to previous messageGo to next message
dirish
Messages: 205
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
Re: Error 6 initializing SQL*Plus [message #285573 is a reply to message #285551] Wed, 05 December 2007 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
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
Re: Error 6 initializing SQL*Plus [message #285577 is a reply to message #285573] Wed, 05 December 2007 01:27 Go to previous messageGo to next message
dirish
Messages: 205
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.

Re: Error 6 initializing SQL*Plus [message #285578 is a reply to message #285577] Wed, 05 December 2007 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can release by breath. Surprised

Regards
Michel
Re: Error 6 initializing SQL*Plus [message #285639 is a reply to message #285549] Wed, 05 December 2007 03:25 Go to previous messageGo to next message
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.
Re: Error 6 initializing SQL*Plus [message #285643 is a reply to message #285639] Wed, 05 December 2007 03:47 Go to previous message
Michel Cadot
Messages: 64120
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
Previous Topic: sql developer
Next Topic: Compare Data Using Toad ToolBar, Tools --> Compare Data
Goto Forum:
  


Current Time: Tue Dec 06 14:13:26 CST 2016

Total time taken to generate the page: 0.05929 seconds