We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

Oracle 10g EX as Custom Action?

Hi,

I want to install Oracle 10g Express as part of our program but have not figured out how to do so.
Basically I need to:
- Install 10gEx server (silent)
- Run SQL script to create database...

I tried to add OracleXE & oracle silent install file to project (as permanent and temporary) and add a custom action in InstallInitialize (or Install) but when I check the log, look like the file was not executed at all. Just 1 note: in order for XE to install silently, it needs to be called with silent file as parameter. I'm not sure how it works on AI....

Can I just copy these files to %WINDIR%\Temp then run them?

Any help is appreciated.

Tks.
gigi
Posts: 2103
Joined: Tue Apr 11, 2006 9:55 am
Contact: Website

Hi,

If you application need other application (to be installed) prior to run then add it as prerequisite. Read more about prerequisites and how to use them here:
http://www.advancedinstaller.com/user-g ... tware.html

Advanced Installer offer support to run SQL scripts during installation, please see following links for more details:
http://www.advancedinstaller.com/user-guide/sql.html
http://www.advancedinstaller.com/user-g ... l-sql.html

Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com
EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

Hi Gigi,

Thanks for your help. I do set it up as prerequisite and look like it does run. However, after it finish installing Oracle, AI goes back and ask for install it again. Look like I need to set a flag or point to a registry so that AI knows about the existing of 10g EX.
What do I have to do in prerequisite so after program is installed, AI will not ask to install the program again?

Eric
EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

Look like I'm having the same problem as Abel here: http://www.advancedinstaller.com/forums ... php?t=1580

Tried everything but still could not install 10g.
FYI, this is my command line:
/s /f1"OracleXE-install.iss" /f2"10gexsetup.log"

I ran some tests with the command line and I see that it only works if you put in absolute path for the ISS file but look like we can not put absolute path in command line of AI???
gigi
Posts: 2103
Joined: Tue Apr 11, 2006 9:55 am
Contact: Website

Hi,
What do I have to do in prerequisite so after program is installed, AI will not ask to install the program again?
You get this behavior because you don't use a proper install condition for the prerequisite. That condition is checked first to see if the prerequisite is already installed and after the prerequisite installation to see if the prerequisite was installed properly. You can use the version of a file that is installed with Oracle or a registry value.

Regarding the silent installation of Oracle 10g I don't understand why is requiring an absolute path since it should get the "OracleXE-install.iss" file from the current directory.

Here are instructions from Oracle website:
http://download-uk.oracle.com/docs/cd/B ... m#BABBCGHA

Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com
EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

Gigi,

As you can see in the instructions at Oracle web site, they are using absolute path:
For example, if you downloaded the OracleXE.exe executable and its response files to a directory called xe_temp, you would enter the following command:

c:\xe_temp> OracleXE.exe /s /f1"c:\xe_temp\response\OracleXE-Install.iss" /f2"c:\xe_temp\setup.log"
I don't know why but obviously it does not work with anything else. So I figure: using a batch file, and populate the asolute path there.... AI will run the batch file as prerequisite. And it works like a charm... :D
FYI, this is my file:

Code: Select all

REM @echo off
set OLDDIR=%CD%
OracleXE.exe /s /f1"%OLDDIR%\OracleXE-install.iss" /f2"%USERPROFILE%\Local Settings\Temp\10gexsetup.log"
About prerequisite checking, I'm now checking for a registry value of 10g and things are running great.

Thanks a lot for your help,

Return to “Common Problems”