如何進(jìn)行Oracle 刪庫

如何進(jìn)行Oracle 刪庫，很多新手對此不是很清楚，為了幫助大家解決這個難題，下面小編將為大家詳細(xì)講解，有這方面需求的人可以來學(xué)習(xí)下，希望你能有所收獲。

今天就教你如何進(jìn)行Oracle 刪庫！

DBCA啟動圖形界面


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


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


附1. 手工創(chuàng)建的數(shù)據(jù)庫注冊到DBCA（添加到最后一行）：

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

2. #
   

3. 
   

4. 
   

5. 
   

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.
   

9. 
   

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靜默安裝的樣例：

點擊(此處)折疊或打開

1. 
   

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.

看完上述內(nèi)容是否對您有幫助呢？如果還想對相關(guān)知識有進(jìn)一步的了解或閱讀更多相關(guān)文章，請關(guān)注億速云行業(yè)資訊頻道，感謝您對億速云的支持。