Hi,
upgradation of database
***********************
* install of new software
* take offline backup of database
* recompile invalid objects(run utlrp.sql)
* for 10g only,take privilleges and roles of all non system users information , connect role will have only create session privillege after upgrd
* run pre-upgradation script (warnings,create sysaux,updatetimezone version,update/add parameters .. etc....
* transfer the files and change ownership (if to new server -transfer files/if in same server change ownership to new oracle binaries owner)
* startup upgrade (start the database in upgrademode)
* catupgrd.sql - run main upgradation script
* check DBA_REGISTRY - make sure all the components are valid
* run utlrp.sql
these are general steps ..
Thanks and Regards,
Vimal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.