How to upgrade oracle 9i to 10g on windows

One thing to check is, Database character set. Thanks for your time. January 29, - pm UTC. You would have to get the views, synonyms, grants, users, etc over some other way either install them from your scripts or use data pump to copy them over - but move the 1TB of data via transports. You would want the same characterset, for transports to work.

Thanks Tom! Thanks a ton for you to keep us updated to latest oracle technologies. Post db upgrade when trying to bring db up,got below error message.

Kindly let me know the possibility of error. Hello, Thanks for the information. We are upgrading and moving the database from one server to another at the same time.

What should the process of upgrade be? Should we upgrade the db first before moving it to the new server or upgrade it after? Can you please post the sequence of that also and where it fits in the list of steps that you have mentioned here? Probably you could see all the datafiles. I would like to thank you for this wondrful article on behalf of my grandson.

Hi, Need your input on Oracle database upgrade from 10g Both ebusiness suite Does the upgrade impacts any of the applications for example database procedures, packages, tables, forms etc.. For technical reasons, check new features in 11gR1 and see if you are planning to use some of those features. Are you looking for this file in new Home or Old Home? AS the scope is just to encrypt 1 tablespace with upgrade from 10g to 11gR1 , i am using the approach for upgeade to 11gR1 as mention by you in above steps.

For certain shared-cursor related operations, mutexes are used as a replacement for library cache latches and librarycache pins. Using mutexes is faster, uses less CPU and also allows significantly improved concurrency over the existing latch mechanism. The use of mutexes for cursor pins can be enabled by setting the init. This allows faster diagnosis of memory usage in prior releases many smaller allocations were grouped under the?

This view is very cheap to query even on high-concurrency systems, as it does not require librarycache latch use. OEM Partition Manager introduced. Miscellaneous Oracle10g enhancements:. Set Database Default Tablespace syntax. RMAN introduces compression for backups. New alter database begin backup syntax. Oracle10g Data Guard Broker introduced. Flashback enhancements for flashback database and flashback table syntax. Cross Platform Transportable Tablespaces.

Share this: Twitter Facebook. Like this: Like Loading This entry was posted in Oracle Datagard and tagged Steps to upgrade oracle database from 10g to 11g. Bookmark the permalink. Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email required Address never made public.

Name required. Blog Stats 23, hits.