在一台服务器上运行两个版本的oracle和不同版本的arcsde

<TABLE>

<TR>
<TH vAlign=top>Software:</TH>
<TD vAlign=top> <B>ArcSDE</B> 3.0.1, 3.0.2, 3.0.2.1, 3.0.2.2, 8.0.1, 8.0.2, 8.1</TD></TR>
<TR>
<TH vAlign=top>Platforms:</TH>
<TD vAlign=top>N/A</TD></TR></TABLE>
<H4>Summary</H4>
<DIV>UNIX allows multiple versions of Oracle and multiple versions of ArcSDE to run on the same server. Windows NT allows only a single version of Oracle, but multiple instances of one version of Oracle can support different versions of ArcSDE on the same server.</DIV>

<H4>Procedure</H4>
<DIV>
<UL>
<LI>On UNIX:

After installing both versions of Oracle, you need to set up the environment in the SDE user's .cshrc file. You can define an variable to switch between environments. The following example defines the variable DBMS to switch between Oracle 8.0.4 and Oracle 8.1.5:


<DIV ><PRE >if ($?DBMS == 0) then

  setenv DBMS arcsde80_804

endif



switch ($DBMS)

  case "arcsde80_804"

    setenv SDEHOME /luke1/oraexe/sdeexe80

    setenv ORACLE_HOME /luke1/oracle/app/oracle/product/8.0.4

    setenv ORACLE_SID sde80

    setenv ESRI_LICENSE_FILE 27005@luke

  breaksw



  case "sde3022_815"

    setenv SDEHOME /luke1/oraexe/sdeora815

    setenv ORACLE_HOME /luke1/ora815/app/oracle/product/8.1.5

    setenv ORACLE_SID luke815

    setenv SDEINSTANCE sde3022_ora8i

    setenv ESRI_LICENSE_FILE 27005@luke

  breaksw



endsw

</PRE></DIV>
In this example, you would switch from the default Oracle 8.0.4 / ArcSDE 8.x to Oracle 8.1.5 / SDE 3.0.2.2 by typing the following at the UNIX prompt:


<DIV ><PRE >setenv DBMS sde3022_815

source .cshrc

</PRE></DIV>
You could also set up aliases in your .cshrc file to simplify this switching process:


<DIV ><PRE >alias o815 'setenv DBMS sde3022_815;source .cshrc'

alias o804 'setenv DBMS arcsde80_804;source .cshrc'

</PRE></DIV>
After installing either ArcSDE 8.x or SDE 3.x, make sure the license.dat file in $SDEHOME/sysgen contains keycodes for both versions. Use the same license.dat file when installing the license manager for the second version.


<LI>On Windows NT:

The ArcSDE 8.0.2 for Oracle 8i installation on Windows NT sets the ORACLE_SID value in the dbinit.sde file. Check the dbinit.sde file located in %SDEHOME%\etc to see if ORACLE_SID is set. If you have two ArcSDE instances don't forget to check both dbinit.sde files. If ORACLE_SID is not set, add the following to the dbinit.sde file:


<DIV ><PRE >set ORACLE_SID=<Your_Oracle_SID>

</PRE></DIV>
See the ArcSDE Administrator's guide for more details on setting variables in the dbinit.sde file. </LI></UL></DIV>

<img src="images/post/smile/dvbbs/em02.gif" /><img src="images/post/smile/dvbbs/em08.gif" /><img src="images/post/smile/dvbbs/em05.gif" />