Wednesday, January 27, 2016

dim-00019 create service error

set ORACLE_SID=orcl

oradim -new -sid ORCL -startmode manual -spfile
Enter password for Oracle service user: <PASSWORD IS ENTERED>
DIM-00019: create service error
O/S-Error: (OS 87) The parameter is incorrect.



You said "Even after deleting the service"
How have you been deleting the service ?
Check out if your service still exists at the registry level
1. regedit
2. go towards HKEY_LOCAL_MACHINE > SYSTEM > CURRENT CONTROL SET > SERVICES > and check the Oracle services.
If your service is still present > delete your service at this level
As a last resort you might want to reboot your server (if possible)



C:\>oradim -delete -sid cs62

C:\>oradim -new -sid cs62

C:\>set oracle_sid=cs62

C:\>sqlplus /nolog






oradim -new -sid orcl -intpwd orcl -startmode manual -pfile 'F:\oracle10g\pr
oduct\10.2.0\db_1\database\initorcl.ora'
Instance created.
DIM-00019: create service error
O/S-Error: (OS 2) The system cannot find the file specified.

Solution of the Problem
On linux environment you don't need these things. But in windows environment you need to do a lot of things more than restoring files. Whenever a windows OS gets corrupted you loose the Oracle Universal Installer repository and the regedit entries along with oracle home structure. So to solve the problem it is better to install new oracle software in your windows machine without any database and then create oracle instance and service using oradim.

No comments:

Post a Comment

Followers