Re: oracle doesnt start

Ed,

From the readme.txt from the 8.1.6.3.4 patchset

--The following fixes were included in 8.1.6.1.5 PSE but not in 8.1.6.3.0 Patchset.
  They are include in this PSE to make 8.1.6.3 cumulative from 8.1.6.1.5 PSE. 1612473 1266248 RDBMS ORACLESERVICE<SID> FAILS TO AUTOMATICALLY START THE DATABASE You can obtain the patchset from http://metalink.oracle.com Click on the Patches button, select Oracle Server - Enterprise Edition for WinNT and search.

There is one other thing to check:

there is a registry setting

HKLM\Software\Oracle\HOME0\ORA_<SID>_AUTOSTART:REG_EXPAND_SZ:TRUE

This can be set via the Oracle Administration Assistant for NT. In the Assistant window, expand the tree, select the database, right click on it and select Startup/Shutdown options. You'll see a checkbox for the instance to be started when the service is started.

hth,

Paul

ed zappulla wrote:
>
> one question - why not use an init?SID?.ora file and start the db with
> sql*plus?
>
> Hi Paul, I want the db to start when the machine boots. I have it installed
> in other places and it works fine. Don't know why it doesn't start now.
> Will the patch definitly fix this? What was the problem?
>
> "Paul Drake" ?paled_at_home.com? wrote in message
> news:3AD00115.C38765B8_at_home.com...
> ? ed zappulla wrote:
> ? ?
> ? ? ugh! i have a new install of oracle. 8.1.6/win2k. the
> OracleServiceOracle
> ? ? does not start when the machine reboots. If I use db admin to start it
> I
> ? ? get an error "error processing initialzation parameters". If i browse
> for a
> ? ? def_init.ora file then it starts. I deleted the data base using the db
> ? ? config assistant and created a new one. it starts during the install.
> when
> ? ? I reboot. Bam! no start.
> ? ?
> ? ? Any ideas?
> ?
> ?
> ? patch to Oracle 8.1.6.3.4.
> ?
> ? login to metalink and get the patch.
> ?
> ? make sure that all Oracle Services are stopped prior to applying the
> ? patch.
> ? also check that any other programs are stopped that could be locking
> ? .dlls in the %ORACLE_HOME%\Bin
> ? such as Apache, Backup software agents and snmp agents.
> ?
> ? create a cold backup set before applying the patch.
> ?
> ? after applying the patch, rebuild the data dictionary (covered in the
> ? readme in the patchset).
> ?
> ? one question - why not use an init?SID?.ora file and start the db with
> ? sql*plus?
> ?
> ? hth,
> ?
> ? Paul
Received on Sun Apr 08 2001 - 12:49:32 CDT