OraFAQ Forum: Windows » Drop/Delete an instance

Home » Infrastructure » Windows » Drop/Delete an instance (11.2.0 / windows 10 and windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Drop/Delete an instance [message #662427]

Mon, 01 May 2017 23:17

Gr8dba
Messages: 3
Registered: May 2017

Junior Member

HI,
I am fairly new Oracle DBA and I am training to find a job.
I made a mistake while typing to create my oracle instance. I would like to drop/delete that instance but I am not able to:

I was supposed to enter:

> ORADIM -NEW -SID prod -PFILE "C:\oracle\product\11.2.0\prod\initprod.ora

instead, I typed in

> ORADIM -NEW -SID prod -PFILE "C:\oracle\product\11.2.0 by mistake i typed "enter" while aiming at the "\"
I got the message:
Instance Created.

I would like to find that instance and drop it completely and try it again.

Thanks

Report message to a moderator

Re: Drop/Delete an instance [message #662429 is a reply to message #662427]

Tue, 02 May 2017 00:03

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Th oradim utility doesn't create an instance, all it does is create a Windows service. So you can remove it with the Windows registry editor. Or, if you want, you can use oradim with the -DELETE switch:

DIM-00002: The specified command was invalid.
Enter one of the following commands:
Create an instance by specifying the following options:
     -NEW -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid | -APXSID sid|
 -SRVC srvc | -ASMSRVC srvc | -MGMTDBSRVC srvc | -IOSSRVC srvc |
 -APXSRVC srvc  [-SYSPWD pass] [-STARTMODE auto|manual]
 [-SRVCSTART system|demand] [-PFILE file | -SPFILE] [-MAXUSERS maxusers]
 [-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
Edit an instance by specifying the following options:
     -EDIT -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid | -APXSID sid
 [-SYSPWD pass]  [-STARTMODE auto|manual] [-SRVCSTART system|demand]
 [-PFILE file | -SPFILE] [-SHUTMODE normal|immediate|abort]
 [-SHUTTYPE srvc|inst] [-MAXUSERS maxusers] [-RUNAS osusr/ospass]
Delete instances by specifying the following options:
     -DELETE -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid |
 -APXSID sid| -SRVC srvc | -ASMSRVC srvc | -MGMTDBSRVC srvc |
 -IOSSRVC srvc | -APXSRVC srvc

Report message to a moderator

Re: Drop/Delete an instance [message #662430 is a reply to message #662427]

Tue, 02 May 2017 00:19

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you want to continue to get help you should envisage to feedback in your topics and follow the OraFAQ Forum Guide.
Also (once again) read How to use [code] tags and make your code easier to read.

Also always post your Oracle version, with 4 decimals, as solution depends on it (once again).

Report message to a moderator

Re: Drop/Delete an instance [message #662456 is a reply to message #662430]

Tue, 02 May 2017 10:41

Gr8dba
Messages: 3
Registered: May 2017

Junior Member

Thank you all for your help! it is very appreciated. I will try when I am off from work and provide feedback!

Report message to a moderator

Re: Drop/Delete an instance [message #666314 is a reply to message #662456]

Fri, 27 October 2017 06:29

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Gr8dba wrote on Tue, 02 May 2017 16:41

Thank you all for your help! it is very appreciated. I will try when I am off from work and provide feedback!

Report message to a moderator

Previous Topic:	ODP.net passing grid data to SP UDT parameter - C#
Next Topic:	Calling SP with array parameter from .net

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 00:52:19 CST 2025