10g to 11g
1.install higher version softwer(11g) in 10g db machine
2.10g pfile copy and past 11g home path(dbs)
$export ORACLE_SID=test(10g)
$export ORACLE_HOME=11g home path
$export LD_LIBARY_PATH=11g LIB path
$sqlplus / as sysdba
sql>startup upgrade
sql>@?/rdbms/admin/utlu111i.sql
check everthing(tablespace size) and go to change
3.down the db
4.open 10g db (normal) and change
5.down db
6.use the 11g home path(pfile is 10g) and startup the db
$sqlplus / as sysdba
sql>start upgrade
sql>@?/rdbms/admin/catupgrde.sql
sql>@?/rdbms/admin/utlrp.sql
sql>shu immediate
sql>startup
1.install higher version softwer(11g) in 10g db machine
2.10g pfile copy and past 11g home path(dbs)
$export ORACLE_SID=test(10g)
$export ORACLE_HOME=11g home path
$export LD_LIBARY_PATH=11g LIB path
$sqlplus / as sysdba
sql>startup upgrade
sql>@?/rdbms/admin/utlu111i.sql
check everthing(tablespace size) and go to change
3.down the db
4.open 10g db (normal) and change
5.down db
6.use the 11g home path(pfile is 10g) and startup the db
$sqlplus / as sysdba
sql>start upgrade
sql>@?/rdbms/admin/catupgrde.sql
sql>@?/rdbms/admin/utlrp.sql
sql>shu immediate
sql>startup
No comments:
Post a Comment