Re: linux environment question

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Thu, 20 Dec 2007 17:46:09 +0100
Message-ID: <476A9C51.2040805@gmail.com>

As already mentioned,
on *nix $ORACLE_SID/$ORACLE_HOME pair should match exactly:

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

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

*Connected to an idle instance.*

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

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

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_at_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_at_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_at_gmail.com>
> To: oracle-l <oracle-l_at_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
>

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

Received on Thu Dec 20 2007 - 10:46:09 CST