Re: linux environment question
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Dec 2007 17:46:09 +0100
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@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:
