While the IB GBL patching targets were listed in the shared Excel, they were not formally communicated. I have initiated patching for the databases assigned to me and will continue to progress, considering my upcoming leave.

Posted By Nikhil22:09

0

Continue Reading

 #!/bin/bash

# Usage: ./compare_oracle_patches.sh <OLD_ORACLE_HOME> <NEW_ORACLE_HOME>

OLD_HOME=$1

NEW_HOME=$2

if [[ -z "$OLD_HOME" || -z "$NEW_HOME" ]]; then

  echo "Usage: $0 <OLD_ORACLE_HOME> <NEW_ORACLE_HOME>"

  exit 1

fi

echo "🔍 Comparing patches..."

echo "Old Home: $OLD_HOME"

echo "New Home: $NEW_HOME"

echo "----------------------------------------"

# Temp files

OLD_FILE=$(mktemp)

NEW_FILE=$(mktemp)

# Extract patch list

$OLD_HOME/OPatch/opatch lsinventory | grep "Patch" | sort > $OLD_FILE

$NEW_HOME/OPatch/opatch lsinventory | grep "Patch" | sort > $NEW_FILE

echo "📌 Patches ONLY in OLD (Bespoke Home):"

comm -23 $OLD_FILE $NEW_FILE

echo ""

echo "📌 Patches ONLY in NEW (Standard Home):"

comm -13 $OLD_FILE $NEW_FILE

echo ""

echo "📌 Common patches:"

comm -12 $OLD_FILE $NEW_FILE

# Cleanup

rm -f $OLD_FILE $NEW_FILE

echo "----------------------------------------"

echo "✅ Comparison complete"

Posted By Nikhil18:14

0

Continue Reading

 /dbs/2025_Q2_F1/OPatch/opatch lsinventory | grep "Patch" | sort > old.txt

/dbs/2026_Q1_V1/OPatch/opatch lsinventory | grep "Patch" | sort > new.txt

diff old.txt new.txt

comm -3 \

<( /dbs/2025_Q2_F1/OPatch/opatch lsinventory | grep "Patch" | sort ) \

<( /dbs/2026_Q1_V1/OPatch/opatch lsinventory | grep "Patch" | sort )

Posted By Nikhil18:10

0

Continue Reading

 SELECT 'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || ''' IMMEDIATE;'

FROM v$session

WHERE <your_condition>;

Posted By Nikhil22:33

0

Continue Reading

Hi all, I’ve proposed an idea to reduce delays in TPAC/TPAI approval using automated notifications.

Do check it out and drop a vote if you like it 👍

Posted By Nikhil18:16

0

Continue Reading

Smart Approval Agent for TPAC / TPAI Requests via Microsoft Teams

 Currently, TPAC/TPAI access requests require manual follow-ups with approvers on Microsoft Teams, causing delays when members are busy or unavailable. Requesters often check availability and ping multiple people, leading to time loss and chat clutter. The proposed solution is an automated agent that notifies all eligible approvers in real time via Teams. Available members can quickly review and approve the request directly. Once approved, the request is removed from the queue to avoid duplication. This will reduce unnecessary communication and significantly improve approval turnaround time.

Posted By Nikhil18:11

0

Continue Reading

 Hi Shridhar/Radha,

Thank you for the details.

We have internally completed the assignment of  databases for the patching activity and is progressing as planned without major issues.

Please find the progress update below:

• Total systems identified: [XX]
• Assigned for patching: [XX]
• Completed: [XX]
• In progress: [XX]
• Pending: [XX]
• 
  

• We will continue to monitor the progress closely and share further updates as we move ahead. Any blockers or risks will be communicated proactively.

 

Posted By Nikhil22:28

0

Continue Reading