2.5 执行以下命令使用DBCA根据模板创建新数据库
dbca –silent –createdatabase –responseFile dbca.rsp
方法二:使用纯SQL语法
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
![](http://cms.it168.com/Images/OutliningIndicators/None.gif)
2.6 使用DBCA卸载数据库
dbca -silent -deleteDatabase -responseFile dbca.rsp
3、如何以silent模式将9i库升级到10g
3.1 配置当前的环境为10g的环境
export ORACLE_HOME=/usr/local/oracle/10g
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
$ORACLE_HOME是已经安装了10g软件的ORACLE_HOME
3.2 执行升级命令
dbua -silent -sid $ORACLE_SID -oracleHome $ORACLE_HOME_9i -backupLocation $DB_BACKUP_DIR_9i
注意:<1> dbua是10g的$ORACLE_HOME/bin下的dbua, 可用which dbua检查
<2> -sid对应9i的sid -oracleHome对应9i的ORACLE_HOME
<3> -backupLocation 指定备份数据库的目录,如果升级失败,可以通过运行下面脚本来恢复
$DB_BACKUP_DIR_9i/$ORACLE_SID_restore.sh
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25837567/viewspace-714372/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25837567/viewspace-714372/