如何手動移除database

[watermelonyu]

我本來用oui來移除db,卻失敗

我就改用手動除

將所有

datafiles,crontrol file,undo,passwod file..整個目錄都移走了

$ORACLE_HOME/dbs/*

/etc/oratab

$ORACLE_BASE/admin/$SID/bdump cdump create pfile udump

/usr/local/bin/coraenv dbhome oraenv

都移除了,請問還有什麼要移除

因為這西都移除之後

在dbca 移除database畫面能會出現這個Instance 的資料

所以就沒辦法用dbca 建立相同Instance name 的db

我想應該還有東西沒移除乾淨,請問是哪些東西移除呢?

[watermelonyu]

忘了補充

OS:HPUX 11.23 IA64

oracle 9.2.0.6

有試過reboot server

[watermelonyu]

環境變數 ORACLE_SID=xxx 也刪除了嗎?

[watermelonyu]

只保留oracle home and oracle base

其他都刪了

[watermelonyu]

To delete a database,



First:

Select "rm -f "||name from v$controlfile

union

select "rm -f "||name from v4datafile

union

select "rm -f "||member from v$logfile;



Second:

Clean up above output & make it executable



Third:

If installation follows OFA standard:

remove directory $ORACLE_BASE/admin/$ORACLE_SID



Fourth:

Delete archive log directory (if archive mode)

[watermelonyu]

因為整個環境都已經全部移除了

所以沒辦法再模擬一次

我的作法就只差archive log 沒有移除,

順便問一下,oui 裡面的instance name到底去哪裡抓的?

這幾天我再用手動試試刪除,再測dbca 是否看得到

[watermelonyu]

oui will reference the response file when install, following link should be what you looking for .



http://oraclesvca2.oracle.com/docs/cd/B14117_01/em.101/b12140/4_oui_response_files.htm#i1005570

[watermelonyu]

Dear Joey :

Try to delete

/var/opt/oracle ....

[watermelonyu]

if you want to delete database.you can do following step:



dbca

1.select delete database

2.select database name.

3.auto delete ....



preform command



1.rm $initSID.ora

2.rm control file.

3.rm /var/opt/oracle

4.re-config .profile(modify SID)



it is best use dbca to delete database.it is very easy and safety