Oracle Patch Collector

A Python script that connects to multiple Oracle servers via SSH, retrieves patch information using OPatch commands from all Oracle homes, and exports the results to an Excel file. Features Multi-server support: Connect to multiple Oracle servers simultaneously Automatic Oracle home detection: Finds all Oracle installations using multiple detection methods Comprehensive patch information: Collects database, OJVM, and OCW patch releases Excel export: Results exported to timestamped Excel files Retry mechanism: Built-in connection retry with fallback credential options Error handling: Robust error handling for network and authentication issues

oraclepythonautomationv1.0.0
0 stars1 downloads111 views0 comments
By ahmedalhedewy • Created

Files

(3 files)
Files
Explorer
Select a file to view its contents

Usage Instructions

Run the script and follow the prompts:

python oracle_patch_collector.py
Input Methods
Option 1: Direct input

Enter IP addresses/hostnames (comma-separated or from a file path): 192.168.1.10,192.168.1.11,oracledb01.company.com
Option 2: From file Create a text file with one server per line:

servers.txt:
192.168.1.10
192.168.1.11
oracledb01.company.com
Then specify the file path:

Enter IP addresses/hostnames (comma-separated or from a file path): servers.txt
Authentication
The script will first attempt to connect using the default oracle username. If authentication fails, you'll be prompted to enter alternative credentials for each server.

General Comments(0)

Tip: Click on a line number in the code to add a line-specific comment

No general comments yet. Be the first to comment!