Can not run sqlplus.exe from SFU (Full Version)

All Forums >> [SFU / Interix / SUA Technology] >> Interix Advanced Forum



Message

raszaf -> Can not run sqlplus.exe from SFU (Sep. 25, '06, 6:04:31 AM)

I have installed SFU 3.5 on XP on a PC. My Pc is also part of a network domain. I have oracle 10g running on it. When I try to run sqlplus.exe from $ prompt, I am getting the following error:
$ sqlplus.exe
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
$

Here is what I have set already for the env.
export ORACLE_SID=ALPHAM
export ORACLE_BASE=/dev/fs/C/oracle/product/10.1.0
export ORACLE_HOME=/dev/fs/C/oracle/product/10.1.0/db_1
export TNS_ADMIN=$ORACLE_HOME/NETWORK/ADMIN
export LD_LIBRARY_PATH=$ORACLE_HOME/LIB:/usr/lib:/usr/X11R6/lib
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export ORA_NLS33=$ORACLE_HOME/nls/data
export ORACLE_DOC=$ORACLE_HOME/doc
export PATH=$PATH:$ORACLE_HOME/BIN:$ORACLE_HOME/sqlplus/mesg:$ORACLE_HOME/opmn:$ORACLE_BASE:$ORACLE_HOME/OPatch:.



markfunk -> RE: Can not run sqlplus.exe from SFU (Sep. 25, '06, 10:14:42 AM)

you are trying to run a win32 program.
As such, the environment variables examined by this program need to be
in windows format, not Interix format.
Change ORACLE_BASE and ORACLE_HOME so the filenames are using Windows syntax.
(e.g c:\oracle\product\10.1.0)
And then you will have to change your PATH definition to not reference $ORACLE_HOME and $ORACLE_BASE.

Or you could set up your windows env. variables in the Windows environment.
(Control Panel -> System -> Advanced -> Environment Variables)
including PATH (where you can reference %ORACLE_BASE%)
Then when you start the Interix shell, all your env. variables will be set properly,
including PATH.



Page: [1]



Forum Software © ASPPlayground.NET Advanced Edition 2.5 ANSI

0.016