There are lot of questions in your mail.


1) About your script. If you run some script, verify that they don't point to the same files than the other DB.
2) About the error message regarding the existence of the file. Verify with an OS utility that the file concerned are not altreday used for another database. If not, then delete them.
3) About your new database. If you can't start the service, you have to delete it and create it again. (The fastest method)
4) About the ORA-01033: If you service is started or starting (In some bugged version) than you can stop it manually through SQL (Connect as sysdba and shutdown immediate) and after try to open it (Eventually step by step; mount, open) and the databse will be up or a new error message will appear with further information regarding the cause.

Degand Xavier

DX sprl

Belgium
----- Original Message -----
From: "Gaurav " <oracledba-ezmlmshield-x19720390.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: ORA - 01033 Error.
Date: Wed, 4 May 2005 15:37:31 +0530

>
> Hi all,
>
> Hi I created a new database on a Oracle10g server which already had two
> databases out of which one was functional. While executing databse scripts,
> system gave me warning that some .dbf files alraedy exists. i tried in both
> ways i.e dropping them as well as deleting them. Then when i tried to log on
> to sql after deleting those files so that i can again execute the dbase
> scripts, it gave error:
>
> ORA 01033- Oracle Initialization or Shut down in Process. Kindly do suggest
> me whatto do. Itried to manually run the services of dbconsole and
> service_name again, but it did not worked. Kindly suggest what to do. If u
> can tell me why it happened and oin what way i should proceed, I'll be
> really thankfull to you.
>
> Regards
>
> Gaurav Singh
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html



DEGAND XAVIER

DX SPRL

BRUSSELS, BELGIUM


Oracle LazyDBA home page