Upgrade

Upgrade Pre-upgrade Tasks Backup Configuration:

bash

Copy

# Backup network configuration
tar -czf network_backup.tar.gz $ORACLE_HOME/network/admin/
# Document environment
env | grep ORACLE > oracle_env.txt

Verify Compatibility:

bash

Copy

# Check current version
sqlplus -v
# Review upgrade matrix
# Document connected applications

Upgrade Process Instant Client Upgrade:

bash

Copy

# Download new version
wget https://download.oracle.com/otn_software/linux/instantclient/new_version.zip
# Extract to new location
unzip new_version.zip -d /opt/oracle/new_version
# Update environment variables
vi ~/.bashrc
source ~/.bashrc

Full Client Upgrade:

bash

Copy

# Run upgrade installer
./runInstaller -silent -responseFile upgrade.rsp
Post-upgrade Tasks

Verify Installation:

bash

Copy

# Check version
sqlplus -v
# Test connectivity
sqlplus username/password@ORCL

Update Applications:

bash

Copy

# Update JDBC drivers
cp $ORACLE_HOME/jdbc/lib/ojdbc8.jar /app/lib/
# Update ODBC configuration
odbcconf /A {CONFIGDSN "Oracle in OraClient19Home1"}

Rollback Plan

bash

Copy

# Restore environment variables
cp oracle_env.txt.bak ~/.bashrc
# Restore network configuration
tar -xzf network_backup.tar.gz -C $ORACLE_HOME/
# Switch back to old version
export ORACLE_HOME=/opt/oracle/old_version
source ~/.bashrc