Oracle 刪庫

hai503發表於2017-09-06
Oracle
最近，“從刪庫到跑路”的話題熱度攀升，今天就教你如何進行Oracle 刪庫！

DBCA啟動圖形介面


選擇要刪除的DB，點選finish按鈕即可。


半杯茶的工夫，刪庫完成！比安裝EZ很多~~


附1. 手工建立的資料庫註冊到DBCA（新增到最後一行）：
  1. [oracle@db01 ~]$ vi /etc/oratab
  2. #



  6. # This file is used by ORACLE utilities. It is created by root.sh
  7. # and updated by either Database Configuration Assistant while creating
  8. # a database or ASM Configuration Assistant while creating ASM instance.

  10. # A colon, ':', is used as the field terminator. A new line terminates
  11. # the entry. Lines beginning with a pound sign, '#', are comments.
  12. #
  13. # Entries are of the form:
  14. # $ORACLE_SID:$ORACLE_HOME:<N|Y>:
  15. #
  16. # The first and second fields are the system identifier and home
  17. # directory of the database respectively. The third filed indicates
  18. # to the dbstart utility that the database should , "Y", or should not,
  19. # "N", be brought up at system boot time.
  20. #
  21. # Multiple entries with the same $ORACLE_SID are not allowed.
  22. #
  23. #
  24. ORCL:/u01/app/oracle/product/11.2.0/db_1:N
  25. PROD:/u01/app/oracle/product/11.2.0/db_1:N


附2. DBCA靜默安裝的樣例：

點選(此處)摺疊或開啟


  2. [oracle@db01 ~]$ dbca -silent -createDatabase -templateName $ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc -gdbname PROD -sid PROD -characterSet ZHS16GBK
  3. Enter SYS user password:
  4.  
  5. Enter SYSTEM user password:
  6.  
  7. Copying database files
  8. 1% complete
  9. 3% complete
  10. 37% complete
  11. Creating and starting Oracle instance
  12. 40% complete
  13. 45% complete
  14. 50% complete
  15. 55% complete
  16. 56% complete
  17. 60% complete
  18. 62% complete
  19. Completing Database Creation
  20. 66% complete
  21. 70% complete
  22. 73% complete
  23. 85% complete
  24. 96% complete
  25. 100% complete
  26. Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/PROD/PROD.log" for further details.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12707874/viewspace-2144581/，如需轉載，請註明出處，否則將追究法律責任。

相關文章