Install Guides Menu
Upgrade Oracle Database from 10.2.0.1 to 10.2.0.4
Upgrade Oracle Database from 10.2.0.1 to 10.2.0.4
Show/Hide All
1. Download Patch Set
1. Download the patch
6810189.rar
2. Extract the file to %DRIVE%\Aventa_Install using WinRAR
Close Section
2. Backup Database
1. Go to the Oraback folder and run
backup.bat
2. Check the .log files for redlive and redplay to ensure the backup has completed successfully
Close Section
3. Shutdown Oracle Database
1. Open cmd and run the following commands:
sqlplus /nolog
conn sys as sysdba
enter password:
SHUTDOWN IMMEDIATE
Close Section
4. Stop Services
1. Run services.msc
2. Stop the following services
OracleDBConsoleRED
OracleServiceRED
OracleOraDB10g_Home1TNSListener
They may not be called exactly the same as these
Close Section
5. Run the setup
1. Run Aventa_Install\6810189\setup.exe
Welcome screen
Specify Home Details screen
Name = 'OraDb10g_home1'
Path = 'C:\oracle\product\10.2.0\db_1'
Product-Specific Prerequisite Checks
Oracle Configuration Manager Registration screen
Summary screens
End of Installation screens
Close Section
6. Start all services
1. Run services.msc
2. Start the following services
OracleDBConsoleRED
OracleServiceRED
OracleOraDB10g_Home1TNSListener
They may not be called exactly the same as these
Close Section
7. Run through the upgrade
1. Run command prompt and enter the following:
sqlplus /nolog
conn sys as sysdba
enter password:
STARTUP UPGRADE
SPOOL patch.log
@ORACLE_HOME\rdbms\admin\catupgrd.sql
SPOOL OFF
SHUTDOWN
STARTUP
@ORACLE_HOME\rdbms\admin\utlrp.sql
Close Section
8. To check version
1. Run Sqlplus and log in as system
2. Enter the following command
select * from v$version
This should return 10.2.0.4.0 as the version number
Close Section