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
9603 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 different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers

which background process will run @ the time of creation of catalog database

1 Answers CSC,

Name a tablespace automatically created when you create a database.

5 Answers

what are the types of connection load-balancing?

0 Answers Oracle,

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers DELL, TCS,

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers

what r the types of backup?

5 Answers CSC,

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

2 Answers Cognizant,

What is a correlated sub-query? : sql server DBA

0 Answers

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers

For more DB Administration Interview Questions Click Here