Home » SQL & PL/SQL » Client Tools » DIM-00020 (Oracle 9i,WinXp)
icon4.gif  DIM-00020 [message #446614] Tue, 09 March 2010 10:50 Go to next message
imsaikat50
Messages: 8
Registered: March 2010
Junior Member
I am getting this error when i try to create a new SID. I tried various sid but no SID generated but giving the same message.


C:\>oradim -new -sid TEST100 -srvc OracleServiceTEST100 -startmode a pfile='d:\oracle\ora92\database\INITTEST100.ora'
DIM-00003: An argument is missing for the parameter

C:\>oradim -new -sid TEST100 -srvc OracleServiceTEST100 -startmode a -pfile 'd:\oracle\ora92\database\INITTEST100.ora'
DIM-00020: A service for this SID is already created. Please enter a different SID name. No action has been taken
O/S-Error: (OS 2) The system cannot find the file specified.

C:\>oradim -delete -sid TEST100
DIM-00010: SYSTEM\CurrentControlSet\Services\OracleService key does not exist
O/S-Error: (OS 2) The system cannot find the file specified.

C:\>oradim -new -sid TEST10 -srvc OracleServiceTEST100 -startmode a -pfile 'd:\oracle\ora92\database\INITTEST100.ora'
DIM-00020: A service for this SID is already created. Please enter a different SID name. No action has been taken
O/S-Error: (OS 2) The system cannot find the file specified.

C:\>oradim -new -sid TEST1 -srvc OracleServiceTEST100 -startmode a -pfile 'd:\oracle\ora92\database\INITTEST100.ora'
DIM-00020: A service for this SID is already created. Please enter a different SID name. No action has been taken
O/S-Error: (OS 2) The system cannot find the file specified.

Can any one specify any kind of solution for this problem. Should be noted that no SID named TEST100 or TEST10 or TEST1 was created earlier.None of the services exists.
Re: DIM-00020 [message #446615 is a reply to message #446614] Tue, 09 March 2010 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SID is limited to 4 characters in Windows.

Regards
Michel
icon4.gif  Re: DIM-00020 [message #446676 is a reply to message #446614] Tue, 09 March 2010 23:00 Go to previous messageGo to next message
imsaikat50
Messages: 8
Registered: March 2010
Junior Member
Dear Michel,

I already worked with SIDs more than 4 character long in win xp.
This is not the real problem. I already worked with SIDs name TESTDB,Saikat etc all of them are more than 4 Character long.

can you find any other thing regarding this issue.

Thanks for your reply.

saikat
Re: DIM-00020 [message #446681 is a reply to message #446676] Tue, 09 March 2010 23:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And did you work with several instances with the same 4 characters on the same Win server?

Regards
Michel
icon4.gif  Re: DIM-00020 [message #446684 is a reply to message #446614] Tue, 09 March 2010 23:34 Go to previous messageGo to next message
imsaikat50
Messages: 8
Registered: March 2010
Junior Member
not the same 4 character. SIDs are as MYDB, TESTDB and now i intend to create a SID like TEST100. Its not created and also the Service for the SID is not also created but the same error message occured.

Yesterday I tried to create another SID like S1, which was never created earlier. But the same error occured.

Is there any problem of creating more than one/two SID in the same machine?

Basically i want to create a new DB instance say TEST100 manually. But as the SID is not created so I could not create the DB.

Thanks

saikat
Re: DIM-00020 [message #446685 is a reply to message #446615] Tue, 09 March 2010 23:49 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Don't know these commands and limitations, bot I have also worked with SIDs having more than 4 chars.

regards,
Delna
Re: DIM-00020 [message #446713 is a reply to message #446684] Wed, 10 March 2010 01:28 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
imsaikat50 wrote on Wed, 10 March 2010 06:34
not the same 4 character. SIDs are as MYDB, TESTDB and now i intend to create a SID like TEST100.

TESTDB and TEST100 have the same initial 4 letters.
Previous Topic: Delimited output from sqlplus (merged by CM)
Next Topic: Loop Select Statement
Goto Forum:
  


Current Time: Sun Dec 04 12:38:22 CST 2016

Total time taken to generate the page: 0.08194 seconds