Question Re: Drop Oracle DB in Technology Q&A

Drop Oracle DB

Former Member — Wed, 15 Apr 2015 11:26:54 GMT

Hello,

What are the steps to delete only Oracle database after a migration to another database (Hana) and the application server has to remain in a dedicated server?

Regards.

Re: Drop Oracle DB

AtulKumarJain — Wed, 15 Apr 2015 12:34:32 GMT

Hi Ruben,

Follow the link below,

Removing Oracle Database Software

Use Oracle Universal Installer to remove Oracle .

It will not effect you SAP application .

Best Regards,

Atul

Re: Drop Oracle DB

Former Member — Wed, 15 Apr 2015 12:54:03 GMT

Hello Atul, Only I need to drop oracle db. Oracle software is used for another SAP system. Regards.

Re: Drop Oracle DB

former_member182967 — Thu, 16 Apr 2015 02:58:20 GMT

Hello Ruben,

You can delete the database by using Oracle DBCA.

Reference to Oracle document: Dropping a Database

Regards,

Ning Tong

Re: Drop Oracle DB

Former Member — Mon, 20 Apr 2015 12:56:01 GMT

Hello Ning,

If I press finish button with the selected Database I will only delete the BWD datafiles , will not?

The oracle home will not be modified? I've another database and both are using the same Oracle Home.

Re: Drop Oracle DB

former_member182967 — Mon, 20 Apr 2015 14:53:51 GMT

Hello Ruben,

Drop database only deletes datafiles, undos, redo logs, controlfiles, initial files, tempfiles belong to this instance...

It will not delete the Oracle database server software.

Regards,

Ning