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

1 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

what is incremental checkpoint?

1 Answers   CTS,

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

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

3 Answers   TCS,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

what is grd?

0 Answers   Oracle,

---

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

4 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---