Date: Thu, 20 Dec 2007 07:17:52 -0800 (PST)
From: Dan Norris <dannorris@dannorris.com>
Subject: Re: linux environment question
To: niall.litchfield@gmail.com, oracle-l <oracle-l@freelists.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-368127417-1198163872=:81558"
Message-ID: <500108.81558.qm@web35414.mail.mud.yahoo.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: dannorris@dannorris.com
--0-368127417-1198163872=:81558
Content-Type: text/plain; charset=us-ascii

I've experienced that before. While I didn't conduct very careful experiments to determine the reason, my theory is that the ORACLE_HOME at the time the database was started was set to /path/to/oracle/home/ (with the trailing slash). Since it was started that way, it seemed that Oracle was doing a comparison between the environment of the calling program (sqlplus) and the environment stored in the running program's state (the DB instance) and that's why you had to match it exactly--not logically match. This is just a theory--not a proof.

Not sure why you got the "initialisation or shutdown in progress" message though--that would require some more testing that I haven't yet done (or needed to do). 

If anyone finds the real reason or can confirm my theory, I'd love to hear it as well.

Dan

----- Original Message ----
From: Niall Litchfield <niall.litchfield@gmail.com>
To: oracle-l <oracle-l@freelists.org>
Sent: Thursday, December 20, 2007 8:37:20 AM
Subject: linux environment question


all

 
I'm betraying my ignorance here so be gentle. We configured an oracle account with an ORACLE_HOME environment variable ( in .bash_profile) of

 
/path/to/oracle/home

 
and also set the PATH as $ORACLE_HOME/bin:$PATH $ORACLE_SID was also set correctly. 

 
connecting to the running database gave 'initialisation or shutdown in progress'. If however we ran oraenv we were able to connect. On comparison we discovered that if we set ORACLE_HOME as 

 
/path/to/oracle/home/  (trailing /) 

 
then we could connect just fine. My question is why is the trailing slash apparently necessary? 


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info 


--0-368127417-1198163872=:81558
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">I've experienced that before. While I didn't conduct very careful experiments to determine the reason, my theory is that the ORACLE_HOME at the time the database was started was set to /path/to/oracle/home/ (with the trailing slash). Since it was started that way, it seemed that Oracle was doing a comparison between the environment of the calling program (sqlplus) and the environment stored in the running program's state (the DB instance) and that's why you had to match it exactly--not logically match. This is just a theory--not a proof.<br><br>Not sure why you got the "initialisation or shutdown in progress" message though--that would require some more testing that I haven't yet done (or needed to do). <br><br>If anyone finds the real
 reason or can confirm my theory, I'd love to hear it as well.<br><br>Dan<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Niall Litchfield &lt;niall.litchfield@gmail.com&gt;<br>To: oracle-l &lt;oracle-l@freelists.org&gt;<br>Sent: Thursday, December 20, 2007 8:37:20 AM<br>Subject: linux environment question<br><br>
<div>all</div>
<div>&nbsp;</div>
<div>I'm betraying my ignorance here so be gentle. We configured an oracle account with an ORACLE_HOME environment variable ( in .bash_profile) of</div>
<div>&nbsp;</div>
<div>/path/to/oracle/home</div>
<div>&nbsp;</div>
<div>and also set the PATH as $ORACLE_HOME/bin:$PATH $ORACLE_SID was also set correctly. </div>
<div>&nbsp;</div>
<div>connecting to the running database gave 'initialisation or shutdown in progress'. If however we ran oraenv we were able to connect. On comparison we discovered that if we set ORACLE_HOME as </div>
<div>&nbsp;</div>
<div>/path/to/oracle/home/&nbsp; (trailing /) </div>
<div>&nbsp;</div>
<div>then we could connect just fine. My question is why is the trailing slash apparently necessary? </div>
<div><br>-- <br>Niall Litchfield<br>Oracle DBA<br><a rel="nofollow" target="_blank" href="http://www.orawin.info">http://www.orawin.info</a> </div>
</div><br></div></div></body></html>
--0-368127417-1198163872=:81558--
--
http://www.freelists.org/webpage/oracle-l