Q. How to set ORACLE_HOME to my oracle software directory.
Hi Friend I am installing oracle 10g Express Edition on
Linux Fedora Core 6. Installation is success but when i run
#sqlplus I getting command not found error. Then I have
search sqlplus .i.e # find / -name sqlplus
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus
These above output from find i have doubt which is correct
path of sqlplus. So doubtfully i have set path 1st one.i.e #
PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
Then I have run #sqlplus but still i have problem following
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
How overcome this please answer m???
Answer Posted / kittu
export
$ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/serv
er
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to start SQL Server in minimal configuration mode?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what functionality does oracle provide to secure sensitive information?
What types of replication are supported in sql server? : sql server DBA
Where would you look for errors from the database engine?
how can you schedule a job in database?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is a crs resource?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the commands you'd issue to show the explain plan for "select * from dual"?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the difference between clustered and non-clustered index? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.