Monday, October 6, 2008

Upgrade Oracle Database to Oracle Database (patchset 3948480)

Yesterday I have Completed Platform migration on payroll database. While doing the migration, I have upgraded Oracle Database to Oracle Database
1. Log in to the Oracle Database server machine as the oracle user (administrator role in case of windows) on Unix.
2. Make sure that your environment contains the correct values for the ORACLE_HOME and ORACLE_SID variables.
3. Shut down any existing Oracle9i database instances with normal or immediate priority As the oracle user:
sqlplus /nolog
SQL> connect / as sysdba
SQL>shutdown immediate

4. Download the patchset & Extract the patch set (3948480 into Stage directory.
5. Install the patch set
cd /Stage/3948480/Disk1/
Run Setup.exe
Next ->
Specify File Locations
Source Path: choose default
Destination Name: ORACLE_HOME (select from dropdown list, which databse you want to upgrade)
Destination Path: /oracle/products/payroll
Next ->
Install ->
End of Installation

Pre Installation Steps before Database Upgrade
1. If JServer is part of the installation, ensure that there is at least 10 MB of free space allocated to the SYSTEM tablespace.
2. For RAC installations, ensure that there is at least 50 MB of free space allocated to the XDB tablespace.
3. Set the value of the SHARED_POOL_SIZE and the JAVA_POOL_SIZE initialization parameters as follows:
1. Start the database:
3. If necessary, enter the following command to determine whether the system uses an initialization parameter file (initsid.ora) or a server parameter file (spfiledbname.ora):
This command displays the name and location of the server parameter file or the initialization parameter file.
Note:The UF installation uses an spfile (Oracle9i Database will automatically use the ORACLE_HOME/dbs/spfilewebct.ora file if it exists), but we want to make sure that the pfile and the file match up to reduce confusion.
4. Determine the current values of these parameters:
5. If the system is using a server parameter file:
a. If necessary, set the value of the SHARED_POOL_SIZE initialization parameter to at least 250 MB:
d. If necessary, set the value of the JAVA_POOL_SIZE initialization parameter to at least 250 MB:

6. If the system uses an initialization parameter file, if necessary, change the values of the SHARED_POOL_SIZE and the JAVA_POOL_SIZE initialization parameters to at least 250 MB in the initialization parameter file (initsid.ora).
7. Shut down the database:

Upgrading the Database

Perform the following steps on every database associated with the upgraded Oracle home:

1. Log in as the oracle user:
sqlplus /nolog
SQL> connect / as sysdba
2. Enter the following SQL*Plus commands:
SQL> startup migrate
SQL> spool patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> spool off

3. Review the patch.log file for errors and inspect the list of components that is displayed at the end of catpatch.sql script.
4.list provides the version and status of each SERVER component in the database. If necessary, rerun the catpatch.sql script after correcting any problems.
5. Restart the database:
SQL> shutdown immediate
SQL> startup
5. Execute the following script to recompile all invalid PL/SQL packages now. (This step is optional but recommended.)
SQL> @?/rdbms/admin/utlrp.sql
6. Restart the listener & other processes


oakleyses said...

nike air max, gucci handbags, ugg boots, louis vuitton outlet, polo ralph lauren, christian louboutin outlet, christian louboutin uk, cheap oakley sunglasses, nike free, tory burch outlet, burberry pas cher, polo outlet, jordan shoes, sac longchamp pas cher, oakley sunglasses, replica watches, louis vuitton, longchamp outlet, oakley sunglasses, nike free run, christian louboutin shoes, ray ban sunglasses, oakley sunglasses wholesale, louis vuitton outlet, nike air max, louis vuitton, louboutin pas cher, tiffany jewelry, prada handbags, nike roshe, oakley sunglasses, air max, prada outlet, ugg boots, nike outlet, tiffany and co, ray ban sunglasses, longchamp outlet, chanel handbags, michael kors pas cher, longchamp pas cher, jordan pas cher, replica watches, polo ralph lauren outlet online, uggs on sale, longchamp outlet, kate spade outlet, christian louboutin

oakleyses said...

ray ban uk, coach purses, polo lacoste, sac vanessa bruno, nike tn, hogan outlet, michael kors, michael kors outlet online, converse pas cher, nike air max uk, kate spade, michael kors outlet, hollister pas cher, uggs outlet, coach outlet, north face, michael kors outlet, north face uk, nike air max uk, ray ban pas cher, uggs outlet, nike air force, ralph lauren uk, mulberry uk, lululemon canada, nike free uk, true religion jeans, guess pas cher, replica handbags, timberland pas cher, nike blazer pas cher, coach outlet store online, michael kors outlet online, burberry handbags, abercrombie and fitch uk, michael kors, nike air max, michael kors outlet, vans pas cher, oakley pas cher, true religion outlet, hollister uk, nike roshe run uk, sac hermes, true religion outlet, new balance, michael kors outlet online, burberry outlet, true religion outlet

oakleyses said...

timberland boots, instyler, wedding dresses, mcm handbags, beats by dre, ghd hair, converse, oakley, herve leger, nike huaraches, hollister, valentino shoes, nfl jerseys, mac cosmetics, vans, abercrombie and fitch, insanity workout, mont blanc pens, hollister clothing, reebok outlet, bottega veneta, louboutin, lululemon, p90x workout, baseball bats, nike roshe run, celine handbags, vans outlet, converse outlet, north face outlet, hermes belt, new balance shoes, north face outlet, ray ban, longchamp uk, jimmy choo outlet, babyliss, ralph lauren, gucci, chi flat iron, soccer jerseys, asics running shoes, iphone cases, ferragamo shoes, hollister, nike trainers uk, soccer shoes, nike air max, giuseppe zanotti outlet, nike air max

oakleyses said...

canada goose, moncler outlet, canada goose outlet, toms shoes, montre pas cher, louis vuitton, moncler, canada goose, swarovski, juicy couture outlet, louis vuitton, replica watches, links of london, moncler, canada goose uk, moncler uk, hollister, wedding dresses, thomas sabo, karen millen uk, canada goose outlet, barbour uk, louis vuitton, ugg uk, ugg,ugg australia,ugg italia, moncler outlet, doudoune moncler, ugg,uggs,uggs canada, canada goose, supra shoes, coach outlet, canada goose outlet, ugg pas cher, ugg, pandora uk, louis vuitton, canada goose jackets, juicy couture outlet, moncler, marc jacobs, louis vuitton, pandora jewelry, lancel, swarovski crystal, pandora jewelry, pandora charms, barbour, moncler