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

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3771

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1004

How do you trace the traffic hitting a sql server? : sql server DBA

1583

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2523

Why would you use sql agent? : sql server DBA

1096

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1986

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2563

what is ora 24313?what is the procedure to exclude that error?

2578

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

2727

what is the diffrence between core dba and apps dba?

2581

How would you extract DDL of a table without using a GUI tool?

2496

what is asm?

1063

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1915

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?

1990

What the different topologies in which replication can be configured? : sql server DBA

1277