asked on
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..
[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 DevelopmentOracle Database
Last Comment
walkerdba
ASKER
how It can be achieved>
ASKER CERTIFIED SOLUTION
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.
Pls. show contents of your PATH variable, seems that sqlplus is already in your PATH:
echo $PATH
echo $PATH
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.
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.
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 ...