Home » Infrastructure » Windows » Drop/Delete an instance (11.2.0 / windows 10 and windows 7)
Drop/Delete an instance [message #662427] Mon, 01 May 2017 23:17 Go to next message
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
Re: Drop/Delete an instance [message #662429 is a reply to message #662427] Tue, 02 May 2017 00:03 Go to previous messageGo to next message
John Watson
Messages: 8922
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
Re: Drop/Delete an instance [message #662430 is a reply to message #662427] Tue, 02 May 2017 00:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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).

Re: Drop/Delete an instance [message #662456 is a reply to message #662430] Tue, 02 May 2017 10:41 Go to previous messageGo to next message
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!
Re: Drop/Delete an instance [message #666314 is a reply to message #662456] Fri, 27 October 2017 06:29 Go to previous message
gazzag
Messages: 1118
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!
Previous Topic: ODP.net passing grid data to SP UDT parameter - C#
Next Topic: Calling SP with array parameter from .net
Goto Forum:
  


Current Time: Thu Mar 28 17:31:37 CDT 2024