Re: (setting & checking) global ORACLE_SID in UNIX and concurrent oracle

Patrice,

Sounds like you were doing the right thing, but maybe the ORACLE_HOME is different in the two environments?
Don't think that would affect what happened... glad you recovered well.

Are you using a parfile that has the alias in the USERID string as username/passwd_at_alias?
(Just tossing out ideas)

At any rate...
Depending on the shell environment you were working in it may not have been exported.
Two ways to set the sid

1. echo $SHELL to tell the shell you are working in env | grep -i ora to find out what is already set and what is in your path. Then in sh or ksh type export ORACLE_SID=sidname in csh or tcsh setenv ORACLE_SID sidname
2. if /usr/local/bin;/oraenv works properly (it has issues with ulimit on some machines) It sets the ORACLE_HOME based on the SID by looking in the oratab file

          . oraenv
          (means that /usr/local/bin has to be in your path; type which
oraenv to see where oraenv is located)
     Then type in the ORACLE_SID you are looking for when prompted.

To test whether or not your SID is set type

echo $ORACLE_SID

If it comes back as the wrong SID then you have an issue with which to deal.

HTH Heidi

*parts of text removed*

>>I open one terminal window.
>>I set ORACLE_SID=instance1; export ORACLE_SID, then start an import into
one
>>database, and let it run.

>>I open a second terminal window because I want to work on the second
>>instance.
>>I set ORACLE_SID=instance2, export ORACLE_SID.

>>Does the import in the first session still point to instance1, or is it
now
>>trying to import data into the second instance because the value of the
>>global variable has changed?

*parts of text removed*
>>--
>>Author: Boivin, Patrice J
Received on Tue Sep 05 2000 - 08:27:25 CDT