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
9749 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 is the default port no on which sql server listens? : sql server DBA

1222

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

3809

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2350

how can you get actual data change values from previous transactions in oracle?

1141

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

2535

what is grd?

1157

how can a session indicate its interest in receiving alerts?

1095

What the different types of replication and why are they used? : sql server DBA

1228

Explain materialized views and how they are used.

2498

what is the use of recording information about current session?

1110

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1160

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1048

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

2614

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2255

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1166