Software Deployment

I just repackaged the Oracle client. I know that does not help but I will warn you that I have a personal hatred towards the Oracle Universal installer. I found when applying ODBC patches it failed quite a bit on XP.

I repackaged the whole thing in a MSI to save me some field trouble. Then when it was time to patch I would setup capture my original MSI then apply the patch and take the setup capture and run it through Upgrade Sync (in Wise) and create a MSP. Now what I have said here will raise some eyebrows as it violates some repackaging rules but I thought I would throw that out there. Preferably you would install the MSI then setup capture the patch and import the changes into the new MSI you would use to generate your MSP. Also note that you can probably skip building the MSP as it depends on your requirements if you want to use MSPs or not.

Once you have recorded your response file you will have to go into the file and edit it.
Look at the example files supplied by oracle to see how they have it set up.
Most entries after each "=" have to be in quotes, besides the "true" and "false" entries. If there were more than one I put quotes around each individual entry.
I have also had issues with the recorder adding more the the dependency list than is needed. (Actually it added them all)
Again reference the oracle examples to reference what dependency referes to what option.
I also had to parse out the application and version:

Example:
#Parameter: DEPENDENCY_LIST
#Type: String
#Description: List of Dependees that needs to be installed along with this product.
DEPENDENCY_LIST={"oracle.install.instcommon", "9.2.0.1.0","oracle.rdbms.sqlplus", "9.2.0.1.0","oracle.winprod", "9.2.0.1.0", "oracle.rdbms.ocitop", "9.2.0.1.0", "oracle.p2k", "9.2.0.1.0", "oracle.p2k.xmldevkit", "9.2.0.1.0","oracle.swd.oui", "2.2.0.12.0"}

Hope this helps

frisbiej, thanks for the info. Yes I noticed in their sample files that they used quotes while there are no quotes in the response file when created. Odd thing is, when I use the response file as it is (no quotes), it works for deinstall, just not for install. I have a TAR with Oracle about this, and as usual they're having trouble understanding this issue.

This one is a bear....

I wonder if you could give some repackaging tips for this app, if it's not too much trouble. I tried both ways - repackaging and silent setup.

Repackaging got me a lot of garbage, and SDK incosistencies in the package (although I was able to at least tnsping, so at least basic Oracle networking was there).

The universal installer silent method has all of the problems outlined here and in the packages page, but seemingly with a cleaner installation.

Finally, the Oracle Universal installer does not put the Oracle Client in control panel add/remove programs, so the only way to remove it is through Oracle Universal installer!

I am suprised to see that you are having repackaging issues with it. I used Wise 4.62 and had it repackaged no problem. Ok, it was not that simple. I had to remove all the ODBC driver and datasource information from the package as it has to be done via registry edits and not MSI advertising tables.

What are you using to do the repackage?

Using Wise Package Studio 5.1

Main issues: Garbage paths, like directories in the root of c: that aren't supposed to be there. Strange shortcuts. But we have to have everything under program files\ not c:\ora92 as Oracle wants it - perhaps that made a difference ( had to give it c:\progra~1\ora92, not "program files". Another thing is Oracle really doesn't like path names with spaces. Other than that: SDK inconsistencies in the "consistency checker" - was able to remove most of these, and the package actually "worked" - that is, installed without errors, and connected to the Oracle instance. I used setup capture with "smart monitor" (new in 5.1 i think?) Maybe I should try a snapshot without smart monitor.

Would I trust it? Dunno, not without a lot more testing with the actual user apps. I'd rather trust Oracle silent install than my repackage.....but maybe not [:@]

ORIGINAL: kkaminsk

I am suprised to see that you are having repackaging issues with it. I used Wise 4.62 and had it repackaged no problem. Ok, it was not that simple. I had to remove all the ODBC driver and datasource information from the package as it has to be done via registry edits and not MSI advertising tables.

What are you using to do the repackage?

Yeah the install path might be the issue as I hate Oracle Universal Installer with a passion. But you would think that installing under program files would not be a big deal. I would install it under program files and see if it works without repackaging. Then at least you know if it is the setup capture or not.

When I last repackaged it my path was c:\Oracle\920 or something close to that. If it does work without a setup capture try using Wise without Smart Monitor. I have not used 5.1 but in the 4.x days Smart Monitor did cause some undesireable effects and we had a Wise developer suggest turning it off as a best practice. They may have fixed it in 5.1 but that is something I do not know.

Thanks for your input. Default is c:\Oracle\ora920

3 more things I hate about the silent install, if anybody has come across a solution to these:

1) If you launch it from a vbscript, you can't do any post install config because the "wait" flag doesn't work. This because "setup.exe" isn't active for long. Apparently it passes the majority of the work to other files (it's all java, I think).

2) in the .rsp file even if you put in SHOW_INSTALL_PROGRESS_PAGE=true the installation is completely silent, and I mean completely. The only way to tell it's done is to look at the log, verify that the servies and files are there.

3) Shortcuts -whats up with all the damn shortcuts and why can't you get rid of them in the response file!

Yup, setup capture is looking better and better! [8|]


ORIGINAL: kkaminsk

Yeah the install path might be the issue as I hate Oracle Universal Installer with a passion. But you would think that installing under program files would not be a big deal. I would install it under program files and see if it works without repackaging. Then at least you know if it is the setup capture or not.

When I last repackaged it my path was c:\Oracle\920 or something close to that. If it does work without a setup capture try using Wise without Smart Monitor. I have not used 5.1 but in the 4.x days Smart Monitor did cause some undesireable effects and we had a Wise developer suggest turning it off as a best practice. They may have fixed it in 5.1 but that is something I do not know.

Has anyone had trouble packaging the Administrator install using WPS 5.1? Seems to bomb out before it completes (Setup capture disappears if you perform a reboot during the capture)

What do you mean by bomb? It can take a while for Wise to do the initial WSI. If you check the WFWI process and see that it is pinning the CPU but slowly eating more memory, I'd leave it sit.

I am also trying to create a response file to install only the following:
- Oracle Network Utilities 9.2.0.1.0
- SQL Plus 9.2.0.1.0
- Oracle Windows Interfaces 9.2.0.1.0
- Oracle Universal Installer 2.2.0.12.0
In addition, we want to stop the Net8 Configuration Utility and then remove Oracle Service for Microsoft Transaction Server 9.2.0.1.0

We originally built our desktop images with the 8i client. I have been able to successfully script the uninstall of 8i and now need to build an automated install procedure for our 9i client. When I run the OUI setup and select only the above items, the resulting response file, when used later, will install ALL items (noted by frisbiej above). Is there any documentation out there that will show me what exactly I need to have in the response file to achieve the above effect?

I have had a few people ask me what the entries mean in the DEPENDENCY_LIST
If you look in one of the example *.rsp files it has explanations for each value.
I used the Developer.rsp to get the following information.


#-----------------------------------------------------------------------------
# Name : DEPENDENCY_LIST (oracle.client)
# Datatype : {ServerName}/TahitiList
# Description : List of optional products to be installed along with
# this one. The following choices are available. The
# value can contain any combination of these choices.
# Note : The products listed are optional dependencies. Any
# required dependencies will automatically be installed.
# Valid values :
# oracle.emcltprod, 9.2.0.1.0 : Oracle Enterprise Manager Products 9.2.0.1.0
# oracle.networking.netcltprod, 9.2.0.1.0 : Oracle Network Utilities 9.2.0.1.0
# oracle.utilities.util, 9.2.0.1.0 : Oracle Database Utilities 9.2.0.1.0
# oracle.java, 9.2.0.1.0 : Oracle Java Utilities 9.2.0.1.0
# oracle.rdbms.sqlplus, 9.2.0.1.0 : SQL*Plus 9.2.0.1.0
# oracle.apache.isqlplus.ise, 9.2.0.1.0 : iSQL*Plus Extension for Windows 9.2.0.1.0
# oracle.java.jdbc, 9.2.0.1.0 : Oracle JDBC/OCI Interfaces 9.2.0.1.0
# oracle.java.jdbc.thin, 9.2.0.1.0 : Oracle JDBC/THIN Interfaces 9.2.0.1.0
# oracle.oid.client, 9.2.0.1.0 : Oracle Internet Directory Client 9.2.0.1.0
# oracle.winprod, 9.2.0.1.0 : Oracle Windows Interfaces 9.2.0.1.0
# oracle.rdbms.ocitop, 9.2.0.1.0 : Oracle Call Interfaces 9.2.0.1.0
# oracle.p2k, 9.2.0.1.0 : Oracle Programmer 9.2.0.1.0
# oracle.p2k.xmldevkit, 9.2.0.1.0 : Oracle XML Developer's Kit 9.2.0.1.0
# oracle.doc.windoc, 9.2.0.1.0 : Oracle9i Windows Documentation 9.2.0.1.0
# oracle.swd.oui, 2.0.0.8.0 : Oracle Universal Installer 2.2.0.8.0
# oracle.options.ano, 9.2.0.1.0 : Oracle Advanced Security 9.2.0.1.0
# oracle.java.sqlj.sqljruntime, 9.2.0.1.0 : SQLJ Runtime 9.2.0.1.0
# oracle.options.intermedia.imclient, 9.2.0.1.0 : Oracle interMedia Client Option 9.2.0.1.0
# oracle.options.olap.api, 9.2.0.1.0 : Oracle OLAP API 9.2.0.1.0
#Example : DEPENDENCY_LIST = {"oracle.emcltprod","9.2.0.1.0"}

When I repackaged it I used [ROOTDRIVE]Progra~1\Oracle\ora92 for ALL of my paths and it worked fine.

Is there a comand line uninstall that mimics the uninstall performed by the Uninversal installer?