Sign in to follow this  
Followers 0
NetRanger

False pushes with Oracle Universal Installer

6 posts in this topic

Hi all! I'm trying to make unattended installation of Oracle Client with Oracle Universal Installer, but oftenly got false pushes of buttons. I mean, if the code is {TAB 3}{RIGHT 3}{TAB 4}{ENTER}, then one of the block oftenly working like +1, like {TAB 4}{RIGHT 3}{TAB 4}{ENTER}, what's I don't want to. How to avoid such behavior of AutoIt and does AutoIt have a problems with Java apps (due different windows style)? A script designed for x32 systems and it's ran on x32 systems. OS: Windows 7 (x32), 1 Gb RAM

Run("D:\temp\setup.exe")
;welcome
Sleep (8000)
WinWait("Oracle Universal Installer")
WinActivate("Oracle Universal Installer")
WinWaitActive ("Oracle Universal Installer")
Send ("{ENTER}")
;select installation type
Sleep (7000)
WinWait("Oracle Universal Installer")
WinActivate("Oracle Universal Installer")
WinWaitActive ("Oracle Universal Installer")
Send ("{TAB 3}{RIGHT 3}{TAB 4}{ENTER}")
;specify home details
Sleep (7000)
WinWait("Oracle Universal Installer")
WinActivate("Oracle Universal Installer")
WinWaitActive ("Oracle Universal Installer")
Send ("{TAB 3}")
Send ("C:\Oracle")
Send ("{TAB 5}{ENTER}")
;avaible product components
Sleep (7000)
WinWait("Oracle Universal Installer")
WinActivate("Oracle Universal Installer")
WinWaitActive ("Oracle Universal Installer")
Send ("{TAB 2}{DOWN 21}{SPACE}{TAB 6}{ENTER}")
;product specific checks
Sleep (5000)
Switch @OSVersion
   Case "Win_XP"
   Send ("{ENTER}")
   Case "Win_Vista"
   Send ("{ENTER}")
   Case Else
   Send ("{TAB 2}{RIGHT 2}{SPACE 2}{TAB 3}")
   Send ("^{TAB}{TAB 3}{ENTER}")
EndSwitch
;summary
Sleep (5000)
WinWait("Oracle Universal Installer")
WinActivate("Oracle Universal Installer")
WinWaitActive ("Oracle Universal Installer")
Send ("{ENTER}")
;Oracle Net Configuration Assistant: Welcome
Sleep (50000)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{ENTER}")
;naming methods configuration
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{TAB}{DOWN 4}{ENTER}{TAB 7}{ENTER}")
;net service name configuration
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("main")
Send ("{TAB 4}{ENTER}")
;net service name, select protocol
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{ENTER}")
;net service name, tcp/ip protocol
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("10.7.200.107")
Send ("{TAB 6}{ENTER}")
;net service name, test
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{ENTER}")
;net service name
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{ENTER}")
;another net service name?
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{ENTER}")
;net service name done
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{ENTER}")
;easy connect naming
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{ENTER}")
;naming methods config done
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{ENTER}")
;done
Sleep (500)
WinWait("Oracle Net Configuration Assistant")
WinActivate("Oracle Net Configuration Assistant")
WinWaitActive ("Oracle Net Configuration Assistant")
Send ("{ENTER}")
;end of installation
Sleep (1500)
WinWait("Oracle Universal Installer")
WinActivate("Oracle Universal Installer")
WinWaitActive ("Oracle Universal Installer")
Send ("{ENTER 2}")
Send ("{ENTER}")

 

Share this post


Link to post
Share on other sites



I found instead of using "Enter" to assume default "ok/next" buttons that I had much better luck with using the specific key combination.  I also needed to slow down the send speed for some computers.  Here is just an example that I used recently.

#RequireAdmin
#Include <FileConstants.au3>

;If Firewall is enabled this closes the firewall exception popup.
AdLibRegister("NagWindows", 3000)

;Slow down Window Wait and Send
Opt("SendKeyDelay", 25);Default 5ms
Opt("WinWaitDelay", 1000);Default 250ms

;Install Oracle 11G Client Step 1-10
ShellExecute(@ScriptDir & "\1 Oracle 11gR2x86\client\setup.exe")
WinWait("Oracle Client Installer - Setting up Client - Step 1 of 6", "")
WinActivate("Oracle Client Installer - Setting up Client - Step 1 of 6", "")
Send("{Tab}{Tab}{Tab}{Space}!n")
WinWait("Oracle Client Installer - Setting up Client - Step 2 of 7", "")
WinActivate("Oracle Client Installer - Setting up Client - Step 2 of 7", "")
Send("!n")
WinWait("Oracle Client Installer - Setting up Client - Step 3 of 7", "")
WinActivate("Oracle Client Installer - Setting up Client - Step 3 of 7", "")
Send("{Tab}{Tab}{Tab}C:\Oracle{Tab}{Tab}C:\Oracle\Ora11!n")
WinWait("Oracle Client Installer - Setting up Client - Step 5 of 7", "")
WinActivate("Oracle Client Installer - Setting up Client - Step 5 of 7", "")
Send("!f")
WinWait("Oracle Client Installer - Setting up Client - Step 7 of 7", "")
WinActivate("Oracle Client Installer - Setting up Client - Step 7 of 7", "")
Send("!c")

;*************************
;***Functions Below*****
;************************
Func NagWindows()
    If WinExists("Windows Security Alert", "Java(TM) 2 Platform Standard Edition binary") Then
        WinActivate("Windows Security Alert", "Java(TM) 2 Platform Standard Edition binary")
        ControlClick("Windows Security Alert", "Java(TM) 2 Platform Standard Edition binary", 1607)
    EndIf
EndFunc

 

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

Why are you not following Oracle's own best practices by creating a response file and then doing a silent install, rather than going through all the headache of trying to automate the GUI?

https://docs.oracle.com/middleware/1212/core/OUIRF/silent.htm#OUIRF326

 

I have tried, but response file don't make full installation, only till "Summary" windows. Also I have suspicions, that's didn't work properly with OS early, than Windows 7.

Edited by NetRanger

Share this post


Link to post
Share on other sites

Well, I have used the response file numerous times, and it does a silent install (you don't even see "Summary" windows). Good luck on your project..


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

I can say, that's a response file really can facilitate an install, but the additional installing (like Net Configuration Assistant) is beyond .rsp file opportunities. But it's no matter now, cuz I have managed to make full install of Oracle Client.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • jaeger52
      By jaeger52
      Hello all! I've been scouring the interwebs for a whiff of anybody else who's had this problem and come up empty. Here's the deal: I wrote a simple little script that I've used for months now quite successfully, but I'm also experiencing an error where the ODBC login window will pop up, garbage text will automatically dump into the username, password, and sometimes the source fields, and then it will automatically try to log in and cause it to fail. It's intermittent, and I have no idea what's causing it. It happens in databases that I've never automated, but it does exactly what the script I wrote should do except that it's garbage text being entered. I've attached the script I mentioned. I'd appreciate anything anybody can suggest or recommend. Thanks!
      Send ( "{LWin}" ) Sleep ( 2000 ) Send ("Drive:\Folder\Database.accdb /x Macro") Send ( "{ENTER}" ) WinWaitActive ( "Oracle ODBC Driver Connect" ) Send ( "Username" ) Send ( "{TAB}" ) Send ( "Password" ) ControlClick ( "Oracle ODBC Driver Connect", "OK", 1 )  
    • SorryButImaNewbie
      By SorryButImaNewbie
      Hi! anyone with some oracle SQL experience?
       
      I want to join 2 tables, where the only possible join is by two different columns. Column A is a twelve character long number, while the other (  B  ) is a two character long number. They can ba joined, because A is like .BB......... , So the 2. and 3. char is taken from B (and in no other cases this is possible).
       
      I think I should be able to use REGEXP_LIKE but how do I use column data in this function? '.column_name.........' isn't working naturaly. I tried to look around but I'm stuck now. The best would be if I can use the column name in the regex. I thought about manually entering the possible number combinations, but that wold require updates, and I can't allow that.
       
      Thank you for your time!
    • Colyn1337
      By Colyn1337
      I wanted to see who else is using OATS 12?