Error 6 initializing SQL*Plus [message #284989] |
Mon, 03 December 2007 01:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|
|
|
|
|
|
Re: Error 6 initializing SQL*Plus [message #285030 is a reply to message #285024] |
Mon, 03 December 2007 02:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|
|
|
|
Re: Error 6 initializing SQL*Plus [message #285047 is a reply to message #284989] |
Mon, 03 December 2007 03:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|
|
Re: Error 6 initializing SQL*Plus [message #285551 is a reply to message #285531] |
Wed, 05 December 2007 00:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|
|
Re: Error 6 initializing SQL*Plus [message #285643 is a reply to message #285639] |
Wed, 05 December 2007 03:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|