I need tips and trix about repacking Oracle 92i with Wise Package Studio. Anyone done this operation??

Thanks...
/Robban
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Did you ever successfully package 9i into an MSI? We're attempting to do so after successfully packaging 8.1.7 and 8.0.6. We keeping getting an "Internal Error 2705. Directory" error.

Has anyone seen this issue?
Answered 03/09/2004 by: mcquitp
Senior Yellow Belt

Please log in to comment
0
No, i didn't, i've the same error you got.... Let me know if you find a solution to this issue...
Answered 03/10/2004 by: Robban
Yellow Belt

Please log in to comment
0
I have packaged Oracle 9i (9.2.0.10) successfully.

Most likey the error you're getting is from the MSI's attempt to create the Oracle ODBC Driver entry.

Since the 2 Oracle dlls necessary for the driver are NOT in the system path (I think they're in c:\Orant\Oracle\Bin), the MSI can't find them to install.

If you try to update the path INSIDE that .MSI, no joy... it seems as if the .MSI takes an initial look at the path, and never looks at it again to see if it's ben updated.

My admittedly klugey workaround is to use a small MSI which first updates the path environment variable and then kicks off the install I made.

By the way, I am also working on some WiseScript custom actions to handle editting the TNSNAmes.ORA and SQLNet.ORA files... my current client's method for updating these files is to REPLACE them - not the most robust solution.

Lemme know if you wanna work on these together.

Kind regards,

- Sean Roberts
Answered 03/18/2004 by: sean_c_roberts
Senior Purple Belt

Please log in to comment
0
The best tip I can give you is to split out the tnsnames.ora file as a seperate package totally.

If you need to make the slightest change to that file you will have to fully uninstall Oracle each time it changes if its included in your Oracle package.

If you make a small msi with the tnsnames.ora file in it you will only ever need to unistall that one file in order to change it and reinstall.

Also I have seen an article about adding the environment variable PATH correctly so that it unistalls without ruining the system path.
Answered 03/19/2004 by: MSIMaker
Second Degree Black Belt

Please log in to comment
0
Damn...

That's a great point - I never thought about changes to the TNSNames.ora file triggering self-repair.

I'll take your advice, thanks.
Answered 03/19/2004 by: sean_c_roberts
Senior Purple Belt

Please log in to comment
0
I'm having trouble with this one... Oracle 9i Personal Edition... 2.8GB in all..

Are there any tips on using a particular SetupCapture config?
I get past the Inclusions/exclusions lists, fill in the final page details, but during the final phase (WSI creation) it ends and I have nothing in my share point, it returns to the Projects/Tools screen with no errors. (I'm not creating a setupcapture report as it would be a bit big)

Any advice would be gratefully received.

Thanks, Steve.
Answered 03/27/2004 by: SteveBA
Senior Yellow Belt

Please log in to comment
0
Have a look in the Wise newsgroups because this is a known issue in WPS 4.x
Answered 03/29/2004 by: MSIMaker
Second Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity