Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9607 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
What is a system database and what is a user database? : sql server DBA
how to restore files with rman?
internal architecture
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
which background process invoke at the time of upgradation tell me???
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the commands used in dcl? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the different types of indexes available in sql server? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is a correlated sub-query? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
