OraFAQ Forum: Client Tools

Home » Other » Client Tools » DIM-00020 (Oracle 9i,WinXp)

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

DIM-00020 [message #446614]

Tue, 09 March 2010 10:50

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.

Report message to a moderator

Re: DIM-00020 [message #446615 is a reply to message #446614]

Tue, 09 March 2010 10:54

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SID is limited to 4 characters in Windows.

Regards
Michel

Report message to a moderator

Re: DIM-00020 [message #446676 is a reply to message #446614]

Tue, 09 March 2010 23:00

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

Report message to a moderator

Re: DIM-00020 [message #446681 is a reply to message #446676]

Tue, 09 March 2010 23:13

Michel Cadot
Messages: 68634
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

Report message to a moderator

Re: DIM-00020 [message #446684 is a reply to message #446614]

Tue, 09 March 2010 23:34

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

Report message to a moderator

Re: DIM-00020 [message #446685 is a reply to message #446615]

Tue, 09 March 2010 23:49

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

Report message to a moderator

Re: DIM-00020 [message #446713 is a reply to message #446684]

Wed, 10 March 2010 01:28

Frank
Messages: 7901
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.

Report message to a moderator

Previous Topic:	Delimited output from sqlplus (merged by CM)
Next Topic:	Loop Select Statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 06:10:31 CDT 2024