databse startup problem

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

i have oracle database startup problem.
i have installed oracle8i(8.1.7) on windowsXP i have configured everything properly but i m unable to start database automatically and for this when i checked services of database it shows starting not started so i have to start it manually.Can u plz tell me how i can resolve my problem

2

Pls visit
http://www.oracle.com/ultrasearch/wwws/searchoc.jsp
for FAQ and Search site.

This forum is a UNIX based Q&A Support.

3

Check regedit: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\DATABASE_STARTUP="AUTO" , sometimes it can help.

And better, use UNIX instead. It's really more powerfull and "transparent". For Oracle specially.

4

hi there,

This is Durga Prasad. i hv seen ur problem regarding the startup of Oracle 8i. Can u please check the following

  1. Have you set the path of ur ifile at the c>prompt, if not please do set the prompt at the dos prompt before starting the database manually. This could solve ur problem.
    e:g :

  2. At the time of creating the database, at the dos prompt u hv to mention the -startmode auto for ur problem.
    set oracle_sid=ur database instance name -intpwd database instance name -startmode auto -pfile path of the database instance

the syntax is : c>oradim -new -sid database inst
regards

Durga Prasad