Home » Infrastructure » Linux » can not start sqlplus from the shell (ORACLE 11gR1 , RedHat 5.0)
icon9.gif  can not start sqlplus from the shell [message #425911] Tue, 13 October 2009 01:09 Go to next message
tianhaoxi
Messages: 4
Registered: October 2009
Junior Member
hi all:

i am newer to the oracle 11g R1

i have installed the database according to the document from the oracle on the redhat5


everything is ok

when i finished the installation, then i login in as the oracle user and open the terminal and input the "sqlplus"

i get the error the the command doesn't exist.

i descide to start the scripts from the absolute path. then i get the error below

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

i check the .bash_profile below.
i do set the path including the oracle bin path here.

now i still can not excute the oracle command from the shell directly.

can anyone give me any suggestion? thanks a lot

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oralce/product/11.1.0/db_1
LD_LIBRARY_PATH=$ORACLE_HOME/lib



PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
TMP=/tmp
TMPDIR=/tmp
#ORACLE_BASE=/u01/app/oracle
#ORACLE_HOME=/u01/app/oralce/product/11.1.0/db_1

export ORACLE_BASE ORACLE_HOME LD_LIBRARY_PATH PATH TMP TMPDIR
Re: can not start sqlplus from the shell [message #425914 is a reply to message #425911] Tue, 13 October 2009 01:25 Go to previous messageGo to next message
ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON
Member

Hi,

Are you trying to run sqlplus under oracle user?

Try to edit your ~oracle/.bash_profile:

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/usr/local/bin

export PATH

ORAENV_ASK=NO;
export ORACLE_SID=<SID>
. /usr/local/bin/oraenv >/dev/null
unset ORAENV_ASK
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_HOME/OPatch; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

[Updated on: Tue, 13 October 2009 01:28]

Report message to a moderator

Re: can not start sqlplus from the shell [message #425919 is a reply to message #425911] Tue, 13 October 2009 02:13 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Oracle is mis-spelled as "oralce" in your profile a couple of times.
Re: can not start sqlplus from the shell [message #425920 is a reply to message #425919] Tue, 13 October 2009 02:17 Go to previous messageGo to next message
ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON
Member

ThomasG wrote on Tue, 13 October 2009 11:13
Oracle is mis-spelled as "oralce" in your profile a couple of times.


Correct Laughing

"ORACLE_HOME=/u01/app/<oralce>/product/11.1.0/db_1"
icon7.gif  Re: can not start sqlplus from the shell [message #425926 is a reply to message #425911] Tue, 13 October 2009 02:57 Go to previous message
tianhaoxi
Messages: 4
Registered: October 2009
Junior Member
thanks u sir

i have fixed it.

thank u for paste u profile file here

i just find the the installation guid of oracle on the oracle offical website does not tell me how to set the envrionment variable for oracle correctly

for ORACLE_HOME and so on.

Previous Topic: I didn't find any 64 bit packages in Oracle VM 2.1.5 (x86_64)
Next Topic: I\O improvment
Goto Forum:
  


Current Time: Thu Mar 28 16:51:24 CDT 2024