1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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


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

How do you tell what your machine name is and what is its IP address?

4 Answers  

What purpose does the model database server? : sql server DBA

0 Answers  

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

0 Answers  

Explain an ORA-01555

2 Answers  

one datafile is lost in standy side how can you recover that??

2 Answers  




Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

Which autogrowth database setting is good? : sql server DBA

0 Answers  

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

What is replication? : sql server DBA

0 Answers  

What type of index should you use on a fact table?

1 Answers  

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories