How to Automatically Start Oracle APEX and Other Services with a PowerShell Script

Managing critical software services like Apache, Oracle Listener, Tomcat, and Thunderbird can become repetitive. Automating their startup using a PowerShell script can save time and ensure a seamless experience. This guide provides a step-by-step walkthrough to create and schedule a PowerShell script that automates these tasks.

Step 1: Enable PowerShell Scripts

Before running PowerShell scripts, ensure they are allowed on your system:

• Open PowerShell as an administrator.
• Check the current execution policy:
• Get-ExecutionPolicy
• Set the execution policy to allow remote scripts:
• Set-ExecutionPolicy RemoteSigned
• Type A and press Enter to confirm.

Step 2: Create the PowerShell Script

• Open a text editor (e.g., Notepad) and paste the script provided below.
• Save the file as auto_run_software.ps1.
• Adjust the file paths, retry delays, and email settings to match your setup.

PowerShell Script to Start Services

The following script checks and starts services like Apache, Oracle Listener, Tomcat, and Thunderbird, and sends an email report.

 

PowerShell

xxxxxxxxxx

85

 

1

powershell

2

Code kopieren

3

# Retry settings

4

$retryDelay_httpd_httpd = 5

5

$retryDelay_tnslsnr = 60

6

$retryDelay_tomcat = 5

7

$retryDelay_thunderbird = 60

8

$retryDelay = 30

9

# Service statuses

10

$apacheStarted = $false

11

$oracleListenerStarted = $false

12

$tomcatStarted = $false

13

$thunderbirdStarted = $false

14

# Start Apache

15

for ($i = 1; $i -le $retryDelay_httpd_httpd; $i++) {

16

    $runningProcess = Get-Process | Where-Object { $_.ProcessName -like "*httpd*" }

17

    if ($runningProcess.Count -eq 0) {

18

        Write-Host "Starting Apache (Attempt $i of $retryDelay_httpd_httpd)..."

19

        Start-Process -FilePath "C:\xampp\apache\bin\httpd.exe"

20

    } else {

21

        Write-Host "Apache is already running."

22

        $apacheStarted = $true

23

        break

24

    }

25

    Start-Sleep -Seconds $retryDelay

26

}

27

# Start Oracle Listener

28

for ($i = 1; $i -le $retryDelay_tnslsnr; $i++) {

29

    $runningProcess = Get-Process | Where-Object { $_.ProcessName -like "*tnslsnr*" }

30

    if ($runningProcess.Count -eq 0) {

31

        Write-Host "Starting Oracle Listener (Attempt $i of $retryDelay_tnslsnr)..."

32

        Start-Process -FilePath "C:\db\db_home\bin\tnslsnr.exe"

33

    } else {

34

        Write-Host "Oracle Listener is already running."

35

        $oracleListenerStarted = $true

36

        break

37

    }

38

    Start-Sleep -Seconds $retryDelay_tnslsnr

39

}

40

# Start Tomcat

41

Write-Host "Pausing for 5 minutes before starting Tomcat..."

42

Start-Sleep -Seconds 300

43

for ($i = 1; $i -le $retryDelay_tomcat; $i++) {

44

    $runningProcess = Get-Process | Where-Object { $_.ProcessName -like "*java*" }

45

    if ($runningProcess.Count -eq 0) {

46

        Write-Host "Starting Tomcat (Attempt $i of $retryDelay_tomcat)..."

47

        $env:CATALINA_HOME = "C:\xampp\Tomcat"

48

        Start-Process -FilePath "C:\xampp\Tomcat\bin\startup.bat"

49

    } else {

50

        Write-Host "Tomcat is already running."

51

        $tomcatStarted = $true

52

        break

53

    }

54

    Start-Sleep -Seconds $retryDelay

55

}

56

# Start Thunderbird

57

for ($i = 1; $i -le $retryDelay_thunderbird; $i++) {

58

    $thunderbirdProcess = Get-Process | Where-Object { $_.ProcessName -eq "thunderbird" }

59

    if ($thunderbirdProcess.Count -eq 0) {

60

        Write-Host "Starting Thunderbird..."

61

        Start-Process -FilePath "C:\Program Files\Mozilla Thunderbird\thunderbird.exe"

62

        $thunderbirdStarted = $true

63

        break

64

    } else {

65

        Write-Host "Thunderbird is already running."

66

    }

67

    Start-Sleep -Seconds $retryDelay

68

}

69

# Email Report

70

$smtpServer = "smtp.web.de"

71

$smtpPort = 587

72

$smtpUsername = "online_application_check@web.de"

73

$smtpPassword = "Password"

74

$mailMessage = New-Object System.Net.Mail.MailMessage

75

$mailMessage.From = "online_application_check@web.de"

76

$mailMessage.To.Add("online_application_check@web.de")

77

$mailMessage.Subject = "Service Monitoring Report"

78

$mailMessage.Body = "Apache: $apacheStarted, Oracle Listener: $oracleListenerStarted, Tomcat: $tomcatStarted, Thunderbird: $thunderbirdStarted"

79

$smtpClient = New-Object System.Net.Mail.SmtpClient

80

$smtpClient.Host = $smtpServer

81

$smtpClient.Port = $smtpPort

82

$smtpClient.EnableSsl = $true

83

$smtpClient.Credentials = New-Object System.Net.NetworkCredential($smtpUsername, $smtpPassword)

84

$smtpClient.Send($mailMessage)

85

Write-Host "Report email sent successfully."

Step 3: Run and Test the Script

• Run the script in PowerShell to ensure it works:
• powershell -ExecutionPolicy Bypass -File "C:\Users\APEX\Documents\auto_run_software.ps1"
• Verify that services start and an email is sent.

Step 4: Automate with Task Scheduler

• Open Task Scheduler and create a new task.
• Name the task, e.g., "Check & Start Software."
• Set the trigger to At startup and optionally add a trigger to run every hour.
• For the action, choose Start a program and set:
• Program/script:
• C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
• Add arguments:
• -ExecutionPolicy Bypass -File "C:\Users\APEX\Documents\auto_run_software.ps1"
• Save and enable the task.

Optional: Configure Environment Variables

If required, set environment variables for dependencies like Java.

• Go to System Properties > Environment Variables.
• Add a new variable:
• Name: JAVA_HOME
• Path: C:\Program Files\Java\jdk1.8.0_301

Conclusion

With this PowerShell script, you can automate the startup of critical services and ensure smooth operation of your Oracle APEX environment. By scheduling the script with Task Scheduler, your system will automatically monitor and restart services as needed. This setup enhances efficiency and reduces manual intervention.

 {fullWidth}