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

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

Which autogrowth database setting is good? : sql server DBA

0 Answers  

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

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

0 Answers  

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

How would you determine who has added a row to a table?

4 Answers  

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

0 Answers  

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

What is transparent data encryption? : sql server DBA

0 Answers  

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

For more DB Administration Interview Questions Click Here
Categories