Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 31518 invoked from network); 20 Dec 2007 11:53:40 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 20 Dec 2007 11:53:40 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 843157DD3F5; Thu, 20 Dec 2007 12:53:40 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03719-08; Thu, 20 Dec 2007 12:53:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E3DAB7DCDBD; Thu, 20 Dec 2007 12:53:39 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 20 Dec 2007 12:06:16 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 500577DD960 for ; Thu, 20 Dec 2007 12:06:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25801-08 for ; Thu, 20 Dec 2007 12:06:16 -0500 (EST) Received: from email10.mywebmailserver.com (email10.mywebmailserver.com [199.231.136.140]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E05F17DD95E for ; Thu, 20 Dec 2007 12:06:15 -0500 (EST) Received: from 600d620tcoyle ([72.165.244.50]) by email10.mywebmailserver.com (IntelliMail) with ASMTP id CRY74585; Thu, 20 Dec 2007 12:06:14 -0500 From: "Ted Coyle" To: , , "'oracle-l'" References: <500108.81558.qm@web35414.mail.mud.yahoo.com> Subject: RE: linux environment question Date: Thu, 20 Dec 2007 12:06:36 -0500 Message-ID: <001d01c8432a$ae104b50$3921a8c0@medecision.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001E_01C84300.C53A4350" In-Reply-To: <500108.81558.qm@web35414.mail.mud.yahoo.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-archive-position: 4043 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: oracle-l@webthere.com Precedence: normal Reply-to: oracle-l@webthere.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_NextPart_000_001E_01C84300.C53A4350 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Dan Norris Sent: Thursday, December 20, 2007 10:18 AM To: niall.litchfield@gmail.com; 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 To: oracle-l 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 ------=_NextPart_000_001E_01C84300.C53A4350 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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=3DORCL 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Dan Norris
Sent: Thursday, December = 20, 2007 10:18 AM
To: = niall.litchfield@gmail.com; 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@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 =

 

------=_NextPart_000_001E_01C84300.C53A4350-- -- http://www.freelists.org/webpage/oracle-l