Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am insta

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???

Question Posted / mahendraswain

1 Answers
9700 Views
I also Faced
E-Mail Answers

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Exp..

Answer / 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

More DB Administration Interview Questions

What is the importance of a recovery model? : sql server DBA

0 Answers

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers TCS,

what is the use of ocr?

0 Answers Oracle,

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

who owns the operating system files created by the utl_file package?

0 Answers Oracle,

how can you process messages in order asynchronously?

0 Answers Oracle,

how can you schedule a job in database?

0 Answers Oracle,

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers

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.

0 Answers Infosys,

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers

For more DB Administration Interview Questions Click Here