Thursday, 11 August 2011

Upgrade 10g to 11g(me)

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


No comments:

Post a Comment