** 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
- Select Source DB
# 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
-> Next
Select upgrade timezone -> Next
-> Next
(No) Move DB files -> Next
(No New Listener) -> Next
I have my own backup -> Next
-> Finish
#Check
- sysresv
- sqlplus ->
show parameter compatible
set line 255;select * from v$version
## 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
- Select Source DB
# 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
-> Next
Select upgrade timezone -> Next
-> Next
(No) Move DB files -> Next
(No New Listener) -> Next
I have my own backup -> Next
-> Finish
#Check
- sysresv
- sqlplus ->
show parameter compatible
set line 255;select * from v$version
0 comments:
Post a Comment