|
|
Running Multiple Banner Environments
Here is a technique that you can use to run multiple Banner environments.
Oracle stores environmental settings in the Windows registry.
When an oracle app starts, it looks here for values such as FORMS60_PATH,
UI60_ICO, etc
.
What Oracle does not mention too often is that PRIOR to checking the
SYSTEM registry for a value,
it CHECKS THE LOCAL ENVIRONMENT FOR THESE
VALUES FIRST
.
Therefore you can put these values in a batch file, run the batch, and
these values will override the values stored in the registry.
For example, let say the value for FORMS60_PATH in the registry is D:\fmx\
when you run the following command,
IFRUN60.EXE GUAINIT
oracle will look for forms under d:\fmx
now let's say you create the following batch file:
REM START BAT
SET FORMS60_PATH=e:\new_forms\
IFRUN60.EXE GUAINIT
REM END BAT
|
Running this batch file will cause oracle TO IGNORE THE VALUE SET IN THE
REGISTRY AND LOOK FOR FORMS IN E:\new_forms\
This is a common technique for people that want to run Banner in a test
and prod env at the same time. I have one icon that links to normal
banner, and another that links to a batch file which has FORMS60_PATH set
to a different value.
In the case where you want to run two versions of Banner on two versions
of Oracle developer, you'll need one where the batch files contains ALL
keyword values found in the registry. Running the batch file will override
any value set in the reg.
Here is an example of a banner run entire from a batch file with nothing
set in the registry. In the example below SCTBAN holds the location of the
forms, and SCTORA hold the location of the ORACLE_HOME.
REM BEGIN
###########################
# BANNER TEST ENVIRONMENT #
###########################
set SCTBAN=b:\banner\prod_old
set customform=b:\banner\customform
set SCTORA=b:\ORANT
set LOCAL=TEST
set COMPANY_NAME=My University
REM ######################
REM # set up environment #
REM ######################
echo Setting environment variables ...
set PATH=%SCTORA%\bin;%SCTBAN%\fmx;%SCTBAN%\acrobat40\reader;%PATH%
rem IF generating forms -- set PATH=%SCTBAN%\formsource;%PATH%
set tns_admin=%SCTBAN%\fmx
set API=%SCTORA%\DBS
set BROWSER60=%SCTORA%\BROWSE60
set CA_GPREFS=%SCTORA%
set CA_UPREFS=%SCTORA%
set CORE40=%SCTORA%\CORE40
set D2TX60=%SCTORA%\TOOLS\OPEN60\TUXEDO
set DE60=%SCTORA%\TOOLS\COMMON60
set DEV2000_PROJECT=NONE
set DEV2000_SCCONVERT=FALSE
set DEV2000_SCVIEWER=NOTEPAD.EXE
set DEV2000_SOURCECONTROL=PVCS
set DOC60=%SCTORA%\TOOLS\DOC60
set doc60_nts=%SCTORA%\TOOLS\DOC60\US
set EXECUTE_SQL=PLUS80
set FORMS60=%SCTORA%\FORMS60
set FORMS60_PATH=%customform%;%NewDIR%;%SCTBAN%\local;%SCTBAN%\fmx
set GRAPHICBMP60=%SCTORA%\TOOLS\DBTAB60\GRAPH60\GWIZ_BMP
set GRAPHIC_WEB_DIR=%SCTORA%\TOOLS\DBTAB60\GRAPH60\WEB_OGD
set GRAPHICS60=%SCTORA%\TOOLS\DBTAB60\GRAPH60
set GRAPHICOGD60=%SCTORA%\TOOLS\DBTAB60\GRAPH60\GWIZ_OGD
set GSCONNECTDIR=%SCTORA%\olap\ecf620
set GSINSTALLDIR=%SCTORA%\olap\ece620
set GWIZARD60=%SCTORA%\TOOLS\DBTAB60\GRAPH60
REM inst_loc ** not currently entered
set MM60=%SCTORA%\TOOLS\COMMON60
set NET80=%SCTORA%\NET80
set NLSRTL33=%SCTORA%\NLSRTL33
set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
set OCL60=%SCTORA%\TOOLS\DBTAB60\GRAPH60
set OI_NLS32=%SCTORA%\orainst\NLB
set OIN=%SCTORA%\OIN
set OIN60=%SCTORA%\OIN60
rem *** set OLEDB=%SCTORA%\oledb\mesg
rem *** set OO4O=%SCTORA%\oo4o\mesg
set OPEN60=%SCTORA%\TOOLS\OPEN60
set OPEN60_PLSQL=%SCTORA%\TOOLS\OPEN60\PLSQLLIB
set ORA_NLS33=%SCTORA%\NLSRTL33\DATA
set ORACLE_GROUP_NAME=Oracle for Windows NT
set ORACLE_HOME=%SCTORA%
set ORACLE_HOME_NAME=DEFAULT_HOME
set ORACLE_JDK=%SCTORA%\JDK\
set ORAINFONAV_DOCPATH=%SCTORA%\OIN
set ORAWEB_HOME=%SCTORA%\OWS\4.0
set OTM60=%SCTORA%\OTM60
set OTRACE=%SCTORA%\OTRACE80
set OWS_IMG_DIR=%SCTORA%\OWS\4.0\IMG
set PJ60=%SCTORA%\PJ60
set PLSQL80=%SCTORA%\PLSQL80
set PLUS_DFLT=PLUS80
set PLUS80=%SCTORA%\PLUS80
set PRO80=%SCTORA%\PRO80
set QT_PLAYER=OMO
set RDBMS80=%SCTORA%\RDBMS80
set REPORTS_BUILDER=rwbld60.exe
set REPORTS_RUNTIME=rwrun60.exe
set REPORTS60_CLASSPATH=%SCTORA%\jdk\lib\classes.zip
set REPORTS60_DB_AUTH=dbauth.htm
set REPORTS60_DEV2K=FALSE
set REPORTS60_EXPRESS_UI=%SCTORA%\bin
rem *** set REPORTS60_JNI_DLL=%SCTORA%\bin\javai.dll
set REPORTS60_JNI_LIB=%SCTORA%\bin\javai.dll
set REPORTS60_PATH=%SCTBAN%\reports;%SCTORA%\REPORT60\ADMIN\TEMPLATE\US
set REPORTS60_SPLASH=TRUE
set REPORTS60_SYS_AUTH=sysauth.htm
set REPORTS60_TMP=c:\temp
set RW60=%SCTORA%\REPORT60
set SHARED_ORACLE_HOME=%SCTORA%
set SQLPATH=%SCTORA%\dbs;%SCTORA%\bin;%SCTORA%\report60\server\security
set TK60=%SCTORA%\TOOLS\COMMON60
set UI60=%SCTORA%\TOOLS\COMMON60
set VGS60=%SCTORA%\TOOLS\COMMON60
set UI_ICON=%SCTBAN%\fmx
start ifrun60 guainit
|
|
|
|
