RE: slightly OT, appears to be Sun OS issue

From: Matthew Zito <mzito_at_gridapp.com>
Date: Tue, 12 Oct 2010 09:53:50 -0400
Message-ID: <C0A5E31718FC064A91E9FD7BE2F081B10303E3FF_at_exchange.gridapp.com>

I’ve seen that happen before – if you shut it down with the //, and then start it back up with the /, all should be well, iirc.  

The issue is that with the extra // it still knows how to find the spfile/pfile on startup, whatnot, but when sqlplus tries to start it doesn’t match the ORACLE_HOME correctly.  

Matt  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber Sent: Tuesday, October 12, 2010 9:47 AM To: ORACLE-L
Subject: slightly OT, appears to be Sun OS issue  

I am running into something really strange in one of our Solaris zones. I expect that the problem stems from someone not entering the Oracle home path correctly on installation, since it appears to have an extra '/' in the Oracle home name, but I have never seen this elsewhere, and cannot figure out how to fix it. Its probably easier for you to look at my steps below than try to explain it further. For some reason, I have to have a '//' in the Oracle home name to connect to the ASM instance:

kerbera_at_dwprdap01-> sudo su - oracle Sun Microsystems Inc. SunOS 5.10 Generic January 2005 You have mail.

oracle_at_dwprdap01-> ORACLE_HOME=/oracle/product/asm
oracle_at_dwprdap01-> export ORACLE_HOME
oracle_at_dwprdap01-> PATH=$ORACLE_HOME/bin:$PATH
oracle_at_dwprdap01-> export PATH
oracle_at_dwprdap01-> ORACLE_SID=+ASM
oracle_at_dwprdap01-> export ORACLE_SID
oracle_at_dwprdap01-> echo $ORACLE_HOME

/oracle/product/asm

oracle_at_dwprdap01-> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Oct 11 07:16:32 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> exit
Disconnected
oracle_at_dwprdap01-> echo $ORACLE_HOME
/oracle/product/asm

oracle_at_dwprdap01-> exit
kerbera_at_dwprdap01-> sudo su - oracle Sun Microsystems Inc. SunOS 5.10 Generic January 2005 You have mail.

oracle_at_orap01-> echo $ORACLE_HOME
/oracle/product/db

oracle_at_orap01-> ORACLE_HOME=/oracle/product//asm
oracle_at_orap01-> export ORACLE_HOME
oracle_at_orap01-> PATH=$ORACLE_HOME/bin:$PATH
oracle_at_orap01-> export PATH
oracle_at_orap01-> ORACLE_SID=+ASM
oracle_at_orap01-> export ORACLE_SID
oracle_at_orap01-> echo $ORACLE_HOME

/oracle/product//asm

oracle_at_orap01-> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Oct 11 07:19:05 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select instance_name from v$instance;

INSTANCE_NAME

---

+ASM SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options oracle_at_orap01-> echo $ORACLE_HOME
/oracle/product//asm

oracle_at_orap01->

--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Received on Tue Oct 12 2010 - 08:53:50 CDT