Lakshmi.
Thanks for your advice. I have a question here, dont you think I should have the sid registered as a service before running the create databse script. At this point I deleted prod and all the related files. I tried to use oradim80 but it doesn't show the service is started in the service window of control panel