Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 9367 invoked from network); 20 Dec 2007 10:48:43 -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 10:48:32 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AC7697DD304; Thu, 20 Dec 2007 11:48:25 -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 22241-10; Thu, 20 Dec 2007 11:48:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 271857DD301; Thu, 20 Dec 2007 11:48:25 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 20 Dec 2007 11:46:15 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6F1807DB535 for ; Thu, 20 Dec 2007 11:46:15 -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 21721-10 for ; Thu, 20 Dec 2007 11:46:15 -0500 (EST) Received: from slim-2a.inet.it (slim-2a.inet.it [213.92.5.122]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A1EE47DB13F for ; Thu, 20 Dec 2007 11:46:13 -0500 (EST) Received: from natmi.etnoteam.it ([::ffff:194.185.248.130]) by slim-2a.inet.it via I-SMTP-5.4.4-547 id ::ffff:194.185.248.130+uHiMmoYRm; Thu, 20 Dec 2007 17:46:11 +0100 Message-ID: <476A9C51.2040805@gmail.com> Date: Thu, 20 Dec 2007 17:46:09 +0100 From: "Radoulov, Dimitre" User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: oracle-l Subject: Re: linux environment question References: <500108.81558.qm@web35414.mail.mud.yahoo.com> In-Reply-To: <500108.81558.qm@web35414.mail.mud.yahoo.com> Content-Type: multipart/alternative; boundary="------------000309080604050900010606" X-archive-position: 4041 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: cichomitiko@gmail.com Precedence: normal Reply-to: cichomitiko@gmail.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 --------------000309080604050900010606 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit As already mentioned, on *nix $ORACLE_SID/$ORACLE_HOME pair should match exactly: oracle@xubuntu:~$ *export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1* oracle@xubuntu:~$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 20 17:42:16 2007 Copyright (c) 1982, 2007, Oracle. All rights reserved. *Connected to an idle instance.* SQL> Disconnected oracle@xubuntu:~$ *export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1/* oracle@xubuntu:~$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 20 17:42:20 2007 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options oracle@xubuntu:~$ *ps xe|grep -Fm1 ORACLE_HOME* 11669 ? Ss 0:00 *ora_pmon_ora11g* SHELL=/bin/bash TERM=xterm USER=oracle LD_LIBRARY_PATH=/u01/app/oracle/product/11.1.0/db_1/lib ORACLE_SID=ora11g ORACLE_BASE=/u01/app/oracle MAIL=/var/mail/oracle PATH= PWD=/home/oracle LANG=en_US.UTF-8 SHLVL=1 HOME=/home/oracle LOGNAME=oracle *ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1/* _=/u01/app/oracle/product/11.1.0/db_1/bin/sqlplus ORA_NET2_DESC=9,12 ORACLE_SPAWNED_PROCESS=1 SKGP_HIDDEN_ARGS= 0 oracle@xubuntu:~$ Regards Dimitre Dan Norris wrote: > 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 > --------------000309080604050900010606 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit As already mentioned,
on *nix $ORACLE_SID/$ORACLE_HOME pair should match exactly:

oracle@xubuntu:~$ export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
oracle@xubuntu:~$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 20 17:42:16 2007

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> Disconnected
oracle@xubuntu:~$ export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1/
oracle@xubuntu:~$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 20 17:42:20 2007

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
oracle@xubuntu:~$ ps xe|grep -Fm1 ORACLE_HOME
11669 ?        Ss     0:00 ora_pmon_ora11g SHELL=/bin/bash TERM=xterm USER=oracle LD_LIBRARY_PATH=/u01/app/oracle/product/11.1.0/db_1/lib ORACLE_SID=ora11g ORACLE_BASE=/u01/app/oracle MAIL=/var/mail/oracle PATH= PWD=/home/oracle LANG=en_US.UTF-8 SHLVL=1 HOME=/home/oracle LOGNAME=oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1/ _=/u01/app/oracle/product/11.1.0/db_1/bin/sqlplus ORA_NET2_DESC=9,12 ORACLE_SPAWNED_PROCESS=1 SKGP_HIDDEN_ARGS=<FATAL/S/PMON/x0/x1/x0/x161B0D4/11656/11656/x0/x2/x1/x161B1BA> 0
oracle@xubuntu:~$



Regards
Dimitre

Dan Norris wrote:
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


--------------000309080604050900010606-- -- http://www.freelists.org/webpage/oracle-l