Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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


Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Exp..

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

More DB Administration Interview Questions

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

How can you enable a trace for a session?

1 Answers  

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

What is blocking and how would you troubleshoot it?

1 Answers  

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

4 Answers  

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

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

0 Answers  

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

3 Answers   TCS,

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

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

0 Answers   HP,

For more DB Administration Interview Questions Click Here
Categories