Re: Oracle DB won't open automatically. help.

Version? compatible parameter? platform? Just a few questions. My crystall ball broke centuries ago.

hm . . . but i guess you are using an nt box, cause of oradim. okay first check the registry ORA_SID_AUTOSTART it should be TRUE . . . second check in the control panel / service --> there should be the service set to auto . . . that's it and it should work just fine

"Michael Stevens" <someone_at_microsoft.com> schrieb im Newsbeitrag news:C9ila.274$35.1070_at_dfw-service2.ext.raytheon.com...
> I am a beginner at Oracle. I had an older computer running with an Oracle
> database. I recently got a newer computer and wanted to transfer my older
> database to the new computer. I don't know how to properly backup and
> restore Oracle database files.
>
> I read somewhere that I could just shutdown my old oracle instance and
copy
> all the database files from one computer to the other. I installed Oracle
> on my new computer and created an instance of a database with the same SID
> as what is on my old computer. Then I copied the old database files on
top
> of it. I also copied the tnsnames.ora and all the other files in that
> network\admin directory.
>
> I had to log into the database as "internal" and then tell the database to
> change from status "mounted" to status "open". After that, everything
> worked fine.
>
> The only problem is that every time I reboot the database reverts back to
> status "mounted" and I have to go change it to status "open" before I can
> use it. How do I get the database to automatically open?
>
> I thought that "oradim -edit -sid %ORACLE_SID% -startmode auto" would fix
my
> problem but it did not.
>
> I have searched the newsgroups and documentation for an answer to this and
I
> can't find anything.
>
>
Received on Thu Apr 10 2003 - 14:04:27 CDT