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

Why would you use sql agent? : sql server DBA

1087

What are the operating modes in which database mirroring runs? : sql server DBA

1188

how can you implement fine-grained auditing?

1136

internal architecture

2198

What are the steps you will take to improve performance of a poor performing query?

2849

Explain materialized views and how they are used.

2443

how can you schedule a job in database?

1125

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

1908

what is the use of recording information about current session?

1054

How do you open a cluster administrator? : sql server DBA

1104

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1112

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

1112

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

2720

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

1977

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2109