Re: ORACLE

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Sat, 03 Mar 2007 04:05:06 GMT
Message-Id: <pan.2007.03.03.04.05.05.332013@gmail.com>

On Fri, 02 Mar 2007 10:20:56 -0800, DA Morgan wrote:

> gazzag wrote:
>

>> Frank, I may be wrong but I think that the OP is asking about changing
>> the value of the variable ORACLE_SID, rather than the database
>> identifier.

>
> If that is the question then, very simply, he will break things.
>

Unless the purpose of setting the value of ORACLE_SID is to tell the next Oracle tool to use a different database and database instance - from the same ORACLE_HOME - perhaps to start it.

oracle_at_fuzzy:~> export ORACLE_SID=orcl
oracle_at_fuzzy:~> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 2 21:01:13 2007

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      orcl

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
oracle_at_fuzzy:~> export ORACLE_SID=test
oracle_at_fuzzy:~> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 2 21:01:13 2007

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      test

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
oracle_at_fuzzy:~> export ORACLE_SID=notthere oracle_at_fuzzy:~> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 2 21:04:09 2007

Connected to an idle instance.

SQL> exit
Disconnected
oracle_at_fuzzy:~>

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Fri Mar 02 2007 - 22:05:06 CST

Re: ORACLE_SID