Re: Runtime installation of Oracle

In article <34265391.5249EB55_at_creo.com>, Eric Drapeau <edrapeau_at_creo.com> wrote:
>The product we are currently developing uses Oracle 7.3 for Windows NT.
>When our customers will receive our product shrink-wrap on a CD-ROM, the
>installation procedure will install our files plus a runtime version of
>Oracle 7.3, configured for our product.
>
>
>- coping the appropriate files over for a Runtime version of Oracle
>(Oracle Server, SQL*Plus, Oracle Utilities)
>- setting up the Registry
>- setting up some environment variables
>- starting up some services
>- creating the database by passing a script to srvmgr23.
>

I'm just getting into such an adventure myself. I got a copy of "Oracle Installer Programmer's Reference" from Oracle. Part numbr A-47444. With luck, this will tell me what I need to, for instance, have the installer build the database our application needs, instead of the starter ORCL database. It looks like the capability is there, so I'm going forward with that plan.

Alternatively, you can try the "pkzip" and registry idea, which I've also had some success with. For Personal Oracle 7.3 for Win95, I developed a method for using PKUNZIP to unpack the oracle software. A second ZIP file unpacks the DBF files, etc.. for the actual database, and a .reg script I saved restores the registry settings onto a new laptop/desktop. Yet another pkzip file can be used to actually put icons and menu-entries onto your desktop, but I'm still a bit leary of that one. Add the %ORACLE_HOME%\bin directory to your path, and, it *just* works. You can startup, shutdown, and connect.

If you'd like to swap other ideas about the installer, I'd welcome it. I had to wrench this book out of the Oracle's grip, and there's not much else out there as a resource.

Good luck,
Kevin Fries
kpf_at_landacorp.com
Oracle DBA, and former Powerbuilder Certified Developer

-- 
-------------------------------------------------------------
Kevin Fries                         kelfink_at_ecst.csuchico.edu
CPD/PB, C Developer/DBA  http://www.ecst.csuchico.edu/~kelfink