I have all basic file like control file,redolog file datafile, parameter file (pfile) and database name is "PROD" now can u tell me how can I reinstall oracle as well as database using existing file..????
I feel nothing went wrong. Is this windows platform? if so, login as sys using sqlplus and give STARTUP.
I guess that service is started but the database is not started. In order to start the db automatically when the server is re-stared, u need to make the following registry entry to TRUE.
Italics are variables and specific to your database.