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

Explain about your sql server dba experience? : sql server DBA

1024

What is the default port no on which sql server listens? : sql server DBA

1089

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2516

how can you process messages in order asynchronously?

930

which background process invoke at the time of upgradation tell me???

2663

Explain materialized views and how they are used.

2384

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1032

What is replication? : sql server DBA

1102

What is transparent data encryption? : sql server DBA

1118

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1945

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2136

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1916

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

1041

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

1109

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

949