• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 16309
  • Last Modified:

How to upgrade from an Oracle 10g 10.2.0.3 to 10.2.0.4 Database on MS Vista

Can you please provide the detailed steps that one needs to take in order to upgrade an Oracle 10g Database (10.2.0.3 to 10.2.0.4) on Microsoft Windows Vista?  If you have the patch numbers that one needs to download from Oracle's Metalink and the order that they need to be applied.  Several users have pointed out that you cannot apply patches to a 10.2.0.3 database until it is upgraded to 10.2.0.4 and that interim patches require the Opatch utility.  Any details would be appreciated!

Thanks,

T.J.
0
rockwise
Asked:
rockwise
1 Solution
 
TolomirAdministratorCommented:
Cannot access metalink right now:

https://metalink.oracle.com/CSP/ui/index.html

---
404 Not Found
Resource /CSP/ui/signin_de.html not found on this server

---

Might be a locale problem.

Will see.

Tolomir
0
 
FayyazCommented:
Here you go
The patch No. is 6810189
Step 1). download the pacth from metalink. the file name for solaris is p6810189_10204_win32.zip
Step 2). Extract the file using unzip utilities p6810189_10204_win32.zip
Step 3). Stop all services
         i) shutdown database (using: connect / as sysdba and shutdown immediate )
         ii) Shutdown listener (using lsnrctl stop)
        iii) emctl stop dbconsole  (if dbconsole is configured and running).
       iv). isqlplusctl stop (if isqlplus is configured and running)
Step 4). Start Oracle Universal Installer located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe
select the proper Oracle home and click next ..... next ... next
On the Summary screen, click Install. When the installation is complete, the End of Installation screen appears. On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.

Step 5). startup the listener.  (lsnrctl start )
Step 6). Start the Oracle Database Upgrade Assistant:
From the Start menu, select Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools and then Database Upgrade Assistant to start the Oracle Database Upgrade Assistant.
On the Welcome screen, click Next.
On the Databases screen, select the name of the Oracle Database that you want to update, then click Next.
On the Recompile invalid objects screen, select the Recompile the invalid objects at the end of upgrade option, then click Next.
If you have not taken the back up of the database earlier, on the Backup screen, select the I would like to take this tool to backup the database option, mention the Path, then click Next.

On the Summary screen, check the summary, then click Finish.

On the End of Upgrade screen, click Exit, then click Yes to exit from Oracle Database Upgrade Assistant.

Step 7). Restart the database:

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql


Note:

When the 10.2.0.4 patch set is applied to an Oracle Database 10g Standard Edition database, there may be 54 invalid objects after the utlrp.sql script runs. These objects belong to the unsupported components and do not affect the database operation.
Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following:

BIN$4lzljWIt9gfgMFeM2hVSoA==$0

 


Run the following command to check the status of all the components after the upgrade:

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

In the output of the preceding command, the status of all the components should be VALID for a successful upgrade.





       
0
 
rockwiseAuthor Commented:
Thanks for the suggestion.  This patch should do it.  It comes with its own Universal Installer making it easier to deploy than the earlier interim patches.  Also it can be applied to all 10g Release 2 Databases (10.2.0.x) as well as most 32-bit operating systems - MS Windows Server 2003, Server 2003 R2, Windows XP Professional, Windows Vista SP1, and even Windows 2000 SP2 or later.

Thanks again,

T.J.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now