Can not run sqlplus.exe from SFU

	Free Downloads, Community Forum, FAQs and Developer Resources

Make /Tools Your Home | Link to us

Today's posts | Posts since last visit | Most Active Topics

All Forums	Register	Login	Search	Subscriptions	My Profile	Inbox
Tool Warehouse	FAQs	Resources	Help	Member List	Address Book	Logout

Can not run sqlplus.exe from SFU

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [SFU / Interix / SUA Technology] >> Interix Advanced Forum >> Can not run sqlplus.exe from SFU

Page: [1]

Message

<< Older Topic Newer Topic >>

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

raszaf

Posts: 1
Status: offline

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:.

Post #: 1

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

markfunk

Posts: 669
Joined: Mar. 31, '03,
Status: offline

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.

(in reply to raszaf)

Post #: 2