Re: Designer/2000 2.1 and Personal Oracle7 conflict?

In article <3278C29C.35A0_at_xnet.com>, Indu Adige <adige_at_xnet.com> writes
>I would appreciate any comments:
>
>I need to find out if the Designer/2000 2.1 repository for Windows
>(which installs in Windows95 into the 'ORAWIN' directory), is compatible
>with Personal Oracle7 (which installs in Windows95 into the 'ORAWIN95'
>directory).
>
>I have "Installing the Oracle Designer/2000 repository A Practical
>Guide" by Doug Lhotka, and "Designer/2000 Repository Administration
>6.0.8" by Oracle Corporation, and have used these as guides to coming up
>with an installation procedure. The steps include running CATPROC.SQL,
>creating a separate tablespace for tables and indexes, creating a
>repository owner (by running CKROROLE.SQL), updating the INIT.ORA and
>ORACLE.INI (THIS LAST STEP CONFUSES ME), and then running the install.
>
>What confuses me is this:
>
>1. Can Designer/2000 2.1 even be installed in such a test setup on a
>Windows 95 machine, working against Personal Oracle7?

Yes
>2. If so, should I be installing it into the ORAWIN95 dir and not the
>ORAWIN dir.

No. They use different versions of various core files. In order to use 16-bit Oracle tools against a 32-bit database you need to install an updated set of Required Support Files. These are supplied with PO7WIN95 (in a directory called ORA16UPD I think) and need to be copied into \orawin\bin.

>3. Also, if into the ORAWIN95 directory, what about all those changes
>to the ORACLE.INI and INIT.ORA files (is there an alternative)?
>

These two files are completely different.

INIT.ORA is the generic name for the *database* configuration file. For PO7WIN95 it is in c:\orawin95\database and is called initorcl.ora.

ORACLE.INI is the client configuration file for Windows 3.1 tools. It can be anywhere you liek but is usually in c:\windows or sometimes c:\orawin. This will have been updated by the Des2k installation.

>Please do help, and thanks in advance,
>Vik.
 

-- 
Jim Smith