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

Oh sorry... I am on a Pentium IV system with Windows 2000 server using Oracle 8.1.7.4

AUTOSTART is not really what I need. Everything was set just like you said. What I need is for the database be "open", not just "mounted"

"Michael Blaser" <miblaser_at_bluewin.ch> wrote in message news:3e95c03a$1_5_at_news.bluewin.ch...
> 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 fi
x
> 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 - 15:22:27 CDT