温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

如何进行Oracle 删库

发布时间:2021-11-12 15:55:07 来源:亿速云 阅读:183 作者:柒染 栏目:关系型数据库

如何进行Oracle 删库,很多新手对此不是很清楚,为了帮助大家解决这个难题,下面小编将为大家详细讲解,有这方面需求的人可以来学习下,希望你能有所收获。

今天就教你如何进行Oracle 删库!

DBCA启动图形界面
如何进行Oracle 删库

选择要删除的DB,点击finish按钮即可。
如何进行Oracle 删库

半杯茶的工夫,删库完成!比安装EZ很多~~
如何进行Oracle 删库

附1. 手工创建的数据库注册到DBCA(添加到最后一行):

  1. [oracle@db01 ~]$ vi /etc/oratab

  2. #




  3. # This file is used by ORACLE utilities. It is created by root.sh

  4. # and updated by either Database Configuration Assistant while creating

  5. # a database or ASM Configuration Assistant while creating ASM instance.


  6. # A colon, ':', is used as the field terminator. A new line terminates

  7. # the entry. Lines beginning with a pound sign, '#', are comments.

  8. #

  9. # Entries are of the form:

  10. #   $ORACLE_SID:$ORACLE_HOME:<N|Y>:

  11. #

  12. # The first and second fields are the system identifier and home

  13. # directory of the database respectively. The third filed indicates

  14. # to the dbstart utility that the database should , "Y", or should not,

  15. # "N", be brought up at system boot time.

  16. #

  17. # Multiple entries with the same $ORACLE_SID are not allowed.

  18. #

  19. #

  20. ORCL:/u01/app/oracle/product/11.2.0/db_1:N

  21. PROD:/u01/app/oracle/product/11.2.0/db_1:N



附2. DBCA静默安装的样例:

点击(此处)折叠或打开


  1. [oracle@db01 ~]$ dbca -silent -createDatabase -templateName $ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc -gdbname PROD -sid PROD -characterSet ZHS16GBK

  2. Enter SYS user password:

  3.  

  4. Enter SYSTEM user password:

  5.  

  6. Copying database files

  7. 1% complete

  8. 3% complete

  9. 37% complete

  10. Creating and starting Oracle instance

  11. 40% complete

  12. 45% complete

  13. 50% complete

  14. 55% complete

  15. 56% complete

  16. 60% complete

  17. 62% complete

  18. Completing Database Creation

  19. 66% complete

  20. 70% complete

  21. 73% complete

  22. 85% complete

  23. 96% complete

  24. 100% complete

  25. Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/PROD/PROD.log" for further details.

看完上述内容是否对您有帮助呢?如果还想对相关知识有进一步的了解或阅读更多相关文章,请关注亿速云行业资讯频道,感谢您对亿速云的支持。

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI