Installing Oracle Products for Windows and DOS

Read this if you are installing your Oracle products for Windows onto

a workstation that already has either DOS products or older Windows products.

Oracle Home Directories

The Oracle Installer places most Oracle products for Windows into a separate

Oracle home directory from Oracle products for DOS. The default Oracle home

directory for Windows is \ORAWIN. The default Oracle home directory for DOS is

either \ORADOS for products designed for the V3 Oracle Installer or \ORACLE6

for products that were designed for the V2 Oracle Installer.

Note: The default DOS Oracle home directory for products installed by the

older V2 Oracle Installer is \ORACLE6. When a V2 directory structure is

migrated to the V3 directory structure, the name of the directory remains the

same. So, if the DOS directory name was \ORACLE6, it remains \ORACLE6.

However, some older Oracle and 3rd party products for Windows are installed in

the Oracle home directory for DOS. These products include, but are not limited

to, the following products:

- Oracle Card for Windows 1.x

- Oracle for Windows (DDE Manager/Toolbook Interface) 1.x

- Run Form for Windows 3.x

- Run Menu for Windows 5.x

- SQL*Plus for Windows 3.0.x

- Oracle Business Manager 1.x

If you use these products, you must follow the guidelines described in the

following paragraphs to maintain compatibility with other Windows and DOS

products.

Configuration Files

Current Windows Oracle products look for configuration parameters in the

ORACLE.INI file in your \WINDOWS directory. DOS Oracle products and older

Windows products look for configuration parameters in the CONFIG.ORA file. The

CONFIG.ORA file is located either in the \XBIN subdirectory of your V3 DOS

Oracle home directory, or in your V2 Oracle home directory. Make sure that the

following parameters in your ORACLE.INI file are duplicates of the parameters

in you CONFIG.ORA file.

- LOCAL

- REMOTE

- SQLNET DBNAME

- INTERRUPT

- TCP_SERVICES_FILE

If a parameter exists in one file and not the other, add the parameter to the

file that does not contain it. If a parameter does not exist in either your

ORACLE.INI file or CONFIG.ORA file, you do not need to add it to either file.

If the parameter exists in both files, make sure they are set to the same

value.

Also make sure that the SET CONFIG or SET CONFIG_FILES command in your

AUTOEXEC.BAT file points to your CONFIG.ORA file, not your ORACLE.INI file.

The Oracle Installer will warn you if your CONFIG environment variable is set

incorrectly. For more information about the CONFIG variable, see your DOS

products documentation.

The DOS Path and Oracle Home for Windows

Since Oracle DLLs are now stored in the \ORAWIN\BIN directory and not the

\ORACLE6\BIN directory, older Windows products and 3rd party products must be

configured to use the DLLs in the new \ORAWIN\BIN directory. To do this, the

Installer will ask you if you want it to modify your AUTOEXEC.BAT file to put

the \ORAWIN\BIN directory on your DOS search path. Answer 'Yes' if you are

using older Windows products that require new Oracle DLLs, or a combination of

old and new Windows products that require the same DLLs. For example, you must

put \ORAWIN\BIN on the DOS path if you are using Oracle Card 1.1 with a recent

version of SQL*Net for Windows.

ORA6WIN.DLL

Older Windows products and many 3rd party products are shipped with an

ORA6WIN.DLL file, which enables these products to operate under Windows. You

must make sure that the most recent version of this file is used by all these

products. To do this, you should put the most recent ORA6WIN.DLL file in your

\ORAWIN\BIN directory and you should delete or rename all other ORA6WIN.DLL

files from your workstation and from other locations available to your

workstation via your network. You should also make sure that the \ORAWIN\BIN

directory is on your DOS path as described in the above paragraph.

If the installer detects obsolete ORA6WIN.DLL files, it will ask you if you

want it to rename them. However, you also should check for this file yourself;

the Installer will not search all possible locations. This is especially

important if you are using products on a network.

Running DOS Products within Windows

You may use Oracle DOS products within Windows provided you run SQLPME before

starting Windows and run Windows in standard mode, not enhanced mode. However,

to let Windows run, you must limit the amount of memory that SQLPME will use.

Otherwise, SQLPME may use all available memory and prevent Windows from

running.

In order to force a ceiling on how much memory SQLPME will use, add the

following line to your CONFIG.ORA file in your DOS Oracle home directory:

DYNAMIC_MEMORY=X

This will force all ORACLE protected mode products for DOS to run in no more

than X kilobytes of extended memory. Windows will then use the memory that is

not used by SQLPME. Make sure you set X low enough to allow enough free memory

for Windows to run and high enough to allow DOS Oracle products to run. Also,

do not set X higher than 16000.

When running DOS Oracle products from within Windows you must use DOS SQL*Net,

not Windows SQL*Net, to connect to a remote database. Windows SQL*Net

products are only supported in Windows enhanced mode not standard mode.

If you are running Windows in enhanced mode, you cannot run DOS Oracle

products within Windows. You must not run SQLPME before running Windows in

enhanced mode.