Upgrade Oracle 12C

** Myself

## from 10g
- Set new oracle home & Path
export ORACLE_HOME=$ORACLE_BASE/12102
export PATH=$ORACLE_HOME/bin:$PATH
- Run Upgrade Tool
dbua
#check /etc/oratab -> Oracle Home has set to Y
clip_image001
- Select Source DB
clip_image002
clip_image003
# case recycle not empty ,Check
# select * from registry$sys_inv_objs;
select * from registry$nonsys_inv_objs;

show recyclebin;
purge dba_recyclebin;

- Check again -or- Fix & check
clip_image004
-> Next
clip_image005
Select upgrade timezone -> Next

clip_image006
-> Next
clip_image007


(No) Move DB files -> Next
clip_image008
(No New Listener) -> Next
clip_image009
I have my own backup -> Next
clip_image010
-> Finish
clip_image011
clip_image012
clip_image013
clip_image014
#Check
- sysresv
- sqlplus ->
show parameter compatible
set line 255;select * from v$version









































0 comments:

Loading