OraFAQ Forum: Linux » can not start sqlplus from the shell

Members

Help

Home

Home » Platforms » Linux » can not start sqlplus from the shell (ORACLE 11gR1 , RedHat 5.0)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

can not start sqlplus from the shell [message #425911]

Tue, 13 October 2009 01:09

tianhaoxi
Messages: 3
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

Report message to a moderator

Re: can not start sqlplus from the shell [message #425914 is a reply to message #425911]

Tue, 13 October 2009 01:25

ursusca
Messages: 30
Registered: September 2009

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

ThomasG
Messages: 1940
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Oracle is mis-spelled as "oralce" in your profile a couple of times.

Report message to a moderator

Re: can not start sqlplus from the shell [message #425920 is a reply to message #425919]

Tue, 13 October 2009 02:17

ursusca
Messages: 30
Registered: September 2009

Member

ThomasG wrote on Tue, 13 October 2009 11:13

Oracle is mis-spelled as "oralce" in your profile a couple of times.

Correct

"ORACLE_HOME=/u01/app/<oralce>/product/11.1.0/db_1"

Report message to a moderator

Re: can not start sqlplus from the shell [message #425926 is a reply to message #425911]

Tue, 13 October 2009 02:57

tianhaoxi
Messages: 3
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 30 22:33:51 CST 2009

Total time taken to generate the page: 0.17278 seconds

.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.