Drop a instance

[Former Member]

Dear Friends,

I am working on SAP 4.7 on AIX operating syatem & oracle 9i database.

We have two landscape system.We have two instance on a single system(DEV & QAS). now i want to drop one instance(QAS).because we are facing space problem in system.

Please tell me the process & how can i do free the disk space.

Thanks & Regards

Gopal

Edited by: gopal kaushik on Apr 18, 2008 9:52 AM

[Former Member]

Hello Gopal,

Nothing to worry about the droping the instance... To construct it will take time, to destruct it's just seconds .... Remove all the Files under /ORACLE/920_64 /QAS and remove /usr/sap/QAS file systems...

If you are using MCOD, you need to drop the table spaces to remove the space....

Let me know if you need any more details....

Cheers,

Praveen

Edited by: Praveen kumar on Apr 18, 2008 4:03 PM

[Former Member]

Hi,

check the the following installation document for sap

https://websmp106.sap-ag.de/~sapdownload/011000358700001245102003E/I_UX_ORA2.pdf

look at part 7.3 Deletion of an SAP System Installation

regards,

kaushal

[Former Member]

Hi Gopal,

From the installation Master CD(any latest installation master CD's) there is an option to Remove the Instance,I think this option is available under 'Additional Software Life Cycle Tasks' in the installation Master GUI(start the installation master drill down to to Remove instance & select the instance ID you want to delete and go ahead.

Regards,

Sam

[Former Member]

Dear Sam,

After drop an instance, this will not affect the other instance.And i get the free space or require a database reorgation to free the space

Thanks & regard

Gopal

[Former Member]

Hi Gopal,

I guess, there is nothing can be deleted from Instalation master...

Be careful while doing that...

Cheers,

Praveen

[Former Member]

Hi Gopal,

Deletion of instance is absolutely possible from the installation master GUI,this will not affect the other instances.In a single instance deletion(not MCOD) after the instance deletion is done you have to physically remove the database files.

For an MCOD i think you may require to do a re-org after the deletion.

Regards,

Sam

[Former Member]

Dear Sam,

Thanks for answer.

Can you tell me that i will do all database re org or partily(table).

Thanks & Regards

Gopal

[Former Member]

Hi Gopal,

I think whole DB re-org needs to be done.

Regards,

Sam