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

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

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

4 Answers   Wipro,

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  




SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

how can you process messages in order asynchronously?

0 Answers   Oracle,

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

What is the importance of a recovery model? : sql server DBA

0 Answers  

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

0 Answers  

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories