Home » Infrastructure » Linux » Issue in Sqlplus invoke
Issue in Sqlplus invoke [message #358312] Mon, 10 November 2008 11:39 Go to next message
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 #358343 is a reply to message #358312] Mon, 10 November 2008 15:52 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Double check your environment.

What is the output of:

env | grep ORA
echo $PATH
Re: Issue in Sqlplus invoke [message #358372 is a reply to message #358343] Tue, 11 November 2008 00:31 Go to previous messageGo to next message
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 #359465 is a reply to message #358372] Sun, 16 November 2008 12:56 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
pls create seprate proper enviornment file for your 10g and 11g database and manually load which is required.
Re: Issue in Sqlplus invoke [message #359472 is a reply to message #359465] Sun, 16 November 2008 13:48 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: another oracle instance on linux server
Next Topic: Problem with CRONTAB
Goto Forum:
  


Current Time: Thu Mar 28 16:12:48 CDT 2024