Greetings All (again),
This post is a continuance of my previous post regarding re-installing Oracle 11g. (
2278220
We had a development server that had problems with an OS update, and the OS software ended up being re-installed. All of the Oracle files and directories are back, including all of the .DBF, control, redo, and spfile files for the database that was running when the server had problems.
I reinstalled the oracle binaries (only), I did NOT create a database. All of the .DBF files for the DEV01 database are present and in their original locations.
I am now trying to create the Windows Service for the Oracle instance (dev01) and I am having significant problems. I know I need to use the ORADIM utility to accomplish this.
My researching has found many posts that indicate to use the ORADIM documentation to use this utility, that’s fine so far as syntax is concerned. But I don’t know what combination of parameters I need/should use to accomplish my goal.
Below is the oradim command that I tried to use: (using dev01 as sid)
oradim –NEW –SID dev01 -INTPWD apassword -STARTMODE auto -SRVCSTART system –SPFILE
The error I get is:
DIM-00002: The specified command was invalid.
Enter one of the following command:
Create an instance by specifying the following options:
-NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
[-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
[-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]. . .
My interpretation of the oradim documentation is that when using the –SPFILE parameter you do NOT identify the path to the spfile as you would when using a pfile. I presume that Oracle will look for the spfile in the default location, which in my case is D:\Oracle\product\11.2.0\dbhome_1\database\SPFILEDEV01.ORA
I checked the PATH and ORACLE_HOME environmental variables, they are correct.
I have tried the oradim command with a few formats including providing a fully qualified path to the spfile. I get the same error.
Any suggestions and help will appreciated.
Thanks for you time,
Bob