上一篇推荐的脚本是升级单实例数据字典的,这一篇针对RAC环境数据字典升级。
update.sh
echo 'specify current oracle SID'
update.sh
echo 'specify current oracle SID'
read instance1
echo 'specify oracle database name'
read dbname
export ORACLE_SID=$instance1
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba <
@catbundle.sql psu apply
@utlrp.sql
quit
EOF
srvctl stop database -d $dbname
cd $ORACLE_HOME/cpu/view_recompile
sqlplus / as sysdba <
startup nomount
alter system set cluster_database=false scope=spfile;
shutdown immediate;
startup upgrade
@view_recompile_jan2008cpu.sql
quit
EOF
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba <
@utlrp.sql
quit
EOF
cd $ORACLE_HOME/cpu/view_recompile
sqlplus / as sysdba <
@view_recompile_jan2008cpu.sql
shutdown immediate;
startup;
select version,id,comments from registry$history;
quit
EOF
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba <
<%}%>
@catbundle.sql opsu apply
@utlrp.sql
quit
EOF
cd $ORACLE_HOME/cpu/view_recompile
sqlplus / as sysdba <
shutdown immediate;
startup upgrade
@view_recompile_jan2008cpu.sql
shutdown;
startup nomount;
alter system set cluster_database=true scope=spfile;
alter system set cluster_database_instances=2 scope=spfile;
shutdown abort
quit
EOF
srvctl start database -d $dbname
sqlplus / as sysdba <
select version,id,comments from registry\$history;
quit
EOF
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29047826/viewspace-1709417/,如需转载,请注明出处,否则将追究法律责任。
请登录后发表评论
登录
全部评论
<%=items[i].createtime%>
<%=items[i].content%>
<%if(items[i].items.items.length) { %>
<%for(var j=0;j
<%}%> <%if(items[i].items.total > 5) { %>
<%}%>
<%=items[i].items.items[j].createtime%>
<%=items[i].items.items[j].username%> 回复 <%=items[i].items.items[j].tousername%>: <%=items[i].items.items[j].content%>
还有<%=items[i].items.total-5%>条评论
) data-count=1 data-flag=true>点击查看
<%}%>
转载于:http://blog.itpub.net/29047826/viewspace-1709417/