| Issue in Sqlplus invoke [message #358312] |
Mon, 10 November 2008 11:39  |
OracleDBA1
Messages: 7
Registered: November 2008
|
Junior Member |
|
|
Hi,
My Task:- I want to create a 10g database manually.
I have oracle 11g(11.1.0 version) and 10g (10.2.0)in the same server.
If I try to access/create the 11g database, I can easily do.But even I export ORACLE_HOME and ORACLE_SID for the 10g database, defautly the 11g sqlplus client gets invoked. I tried to invoke the sqlplus from $ORACLE_HOME/bin Then error states sqlplus not found.
I have set ORACLE_BASE,ORACLE_HOME ,PATH and ORACLE_SID.
Am I missing anything?
Thanks a Lot in Advance,
|
|
|
|
|
|
| Re: Issue in Sqlplus invoke [message #358372 is a reply to message #358343] |
Tue, 11 November 2008 00:31  |
OracleDBA1
Messages: 7
Registered: November 2008
|
Junior Member |
|
|
I have executed the following first:
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1
export ORACLE_SID=testdb
export TNS_ADMIN=/oracle/app/oracle/product/10.2.0/db_1/network/admi
LIBPATH=$ORACLE_HOME/lib;
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib; export LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin:$PATH
export PATH
oracle>env | grep ORA
ORACLE_BASE=/oracle/app/oracle
ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1
ORACLE_SID=testdb
oracle>echo $PATH
/oracle/app/oracle/product/10.2.0/db_1/bin:/oracle/app/oracle/product/11.1.0/db_1/bin:/lib:/oracle/app/oracle/product/11.1.0/db_1/OPa tch:/oracle/app/oracle/product/11.1.0/db_1/jdk/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:
|
|
|
|
|
|
| Re: Issue in Sqlplus invoke [message #359472 is a reply to message #359465] |
Sun, 16 November 2008 13:48 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
"U" did not post in this topic why are YOU talking to him, more it is not a member of this site.
Don't use IM speak.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
