About
Pricing
Community
Teams
Start Free Trial
Log in
walkerdba
asked on
12/27/2012
I cannot connect
[oracle@sunu db_1]$ cd dbs
[oracle@sunu dbs]$ kls
bash: kls: command not found
[oracle@sunu dbs]$ ls
hc_bank.dat initmydb.ora~ lkBANK orapwnewdb peshm_newdb_0
hc_brand.dat initnewdb.ora lkBRAND orapworcl peshm_orcl_0
hc_DBUA0.dat initnewdb.ora~ lkMYDB orapwsundb peshm_testdb_0
hc_mydb.dat init.ora lkNEWDB orapwtestdb snapcf_brand.f
hc_newdb.dat initorcl.ora lkORCL peshm_bank_0 snapcf_orcl.f
hc_orcl.dat initorcl.ora~ orapwbank peshm_brand_0 spfilebank.ora
hc_testdb.dat initsundb.ora orapwbrand peshm_DBUA0_0 spfilebrand.ora
initmydb.ora initsundb.ora~ orapwmydb peshm_mydb_0 spfileorcl.ora
[oracle@sunu dbs]$ export ORACLE_SID=orcl
[oracle@sunu dbs]$ sqlplus / as sysdba
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
[oracle@sunu dbs]$
can u please let me know the reason..
Web Development
Oracle Database
6
1
Last Comment
walkerdba
8/22/2022 - Mon
Guy Hengel [angelIII / a3]
12/27/2012
>SP2-0667: Message file sp1<lang>.msb not found
>SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
the second message tells you what is wrong.
ORACLE_HOME variable is not set, so oracle cannot find the message file ...
walkerdba
12/27/2012
ASKER
how It can be achieved>
ASKER CERTIFIED SOLUTION
Tomas Helgi Johannsson
12/27/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Gerwin Jansen
12/27/2012
Pls. show contents of your PATH variable, seems that sqlplus
is
already in your PATH:
echo $PATH
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
slightwv (䄆 Netminder)
12/27/2012
If you have set up /etc/oratab properly then:
export ORACLE_SID=orcl
. oraenv
If you want orcl to be the 'default' then: export ORAENV_ASK=NO
This not only setups up ORACLE_HOME but adds $ORACLE_HOME/bin to your PATH.
walkerdba
1/10/2013
ASKER
yes
>SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
the second message tells you what is wrong.
ORACLE_HOME variable is not set, so oracle cannot find the message file ...