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
9747 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 are the ways tablespaces can be managed and how do they differ?

2 Answers IBM,

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers

what is the differnce between process and thread ?

1 Answers IBM,

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers STC,

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers Cognizant,

How do you resize a data file?

2 Answers

How can we know the exact updation date of a particular database?

2 Answers Satyam,

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers

For more DB Administration Interview Questions Click Here