RE: linux environment question
- From: "Ted Coyle" <oracle-l@xxxxxxxxxxxx>
- To: <dannorris@xxxxxxxxxxxxx>, <niall.litchfield@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Dec 2007 12:06:36 -0500
Dan,
I believe you are correct with the path set to start the system.
The "initialization or shutdown" issue is probably related to starting an
instance with an incorrectly cased SID.
All my SIDs are lowercase. If I were to export ORACLE_SID=ORCL and the
config files are initorcl.ora, Oracle would attempt to start an ORCL
instance that doesn't exist and I'd get the same message.
Ps -ef |grep orcl or ps -ef |grep pmon should show this.
Ted
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Dan Norris
Sent: Thursday, December 20, 2007 10:18 AM
To: niall.litchfield@xxxxxxxxx; oracle-l
Subject: Re: linux environment question
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@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
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
Other related posts: