Re: Oracle user group

From: JMecc <jmecc_at_telus.net>
Date: 7 May 2007 10:30:44 -0700
Message-ID: <1178559044.910452.239000@e51g2000hsg.googlegroups.com>

Thanks for the help. The bashrc file now includes:

export CLASSPATH=./:/usr/scratch/jdbc/lib/classes12.zip export ORACLE_BASE=/database
export ORACLE_HOME=$ORACLE_BASE/Oracle10g/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH

but I still get an error trying to run sqlplus:

bash-3.00$ . oraenv
ORACLE_SID = [jrl2] ? btap
bash-3.00$ 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

What should my ORACLE_HOME be? The locations are:

bin: /database/Oracle10g/bin
files: /database/Oracle10g
data: /database/oradata
inventory: /u01/app/oracle/oraInventory

Thanks,
Jonathan Received on Mon May 07 2007 - 12:30:44 CDT