Delete an Oracle database in Linux or Windows

Delete an Oracle database in a Linux operating system in detail:

1. Disable oracle server and background processes
Ps-ef | grep ora
Turn off the database
Shutdown immediate
 

2. Disable the listener.
Lsnrctl status
If it is enabled, execute lsnrctl stop to disable it.
 

3. delete the file under $ ORACLE_HOME.
Delete a database using the dbca graphic interface
 

4. Delete the three folders dbhome oraenv coraenv under/usr/local/bin.
Rm-f dbhome
Rm-f oraenv
Rm-f coraenv
 

5. Delete oratab and orainst. loc under/etc.
Rm-f oratab
Rm-f orainst. loc
 

6. Delete ORCLfmap under/opt
Rm-fR ORCLfmap
 

7. [oracle @ RedHat ~] $ Env | grep ORA
ORACLE_SID = ora10g
ORACLE_BASE =/u01/app/oracle
ORACLE_HOME =/u01/app/oralce/product/10.2.0/db_1
Delete all files in the preceding directory
Rm-fR/u01
 

8. Delete oracle users, oinstall and dba
Oracle users must be deleted first
Userdel-r oracle
Groupdel oinstall
Groupdel dba

1 2 Next Page