export $ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/serv er

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

1 Answers
9653 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

967

what are the benefits of flashback feature?

1004

Explain materialized views and how they are used.

2424

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

1045

What is dbcc? : sql server DBA

1260

what is the role of dip user in our database?

2402

What are the different sql server versions you have worked on? : sql server DBA

999

What is the default port no on which sql server listens? : sql server DBA

1127

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1952

What happens on checkpoint? : sql server DBA

1070

Where do you find the default index fill factor and how to change it? : sql server DBA

1059

how can you record information about current session?

1031

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1739

What is the difference between dropping a database and taking a database offline? : sql server DBA

1046

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1062