Re: help, auto startup (open) of Oracle 8 db

On 3 Jun 2004 11:04:21 -0700, timjowers_at_yahoo.com (Tim Jowers) wrote:

>Oracle services start fine but the database has to be "opened" with
>DBA Studio before it may be accessed. Is there anyway to get the
>database to startup automatically?
>
>What works:
>1) Oracle services startup fine
>2) Open DBA Studio, "BTGWS304 - SYSTEM AS SYSDBA" -> Instance ->
>Database and then click the "Open" radio button and click Apply. Says
>it will use the file
>c:\oracle\oracle81\sysman\ifiles\def_BTGWS304.ora. Messages are
>"starting up the database", "mounting the database", "opening the
>database", and "processing completed."
>
>What I tried:
>1. Checked that ORA_BTGWS304_AUTOSTART is set to "TRUE". (REG_SZ)
>2. Made sure the following servies are running and autostart.
>OracleOraHome81DataGatherer
>OracleOraHome81PagingServer
>OracleOraHome81TNSListener
>OracleServiceBTGWS304
>3. Verfied that TNSName has the right entry for
>jdbc:oracle:thin:@portal:1521:btgws304 where portal is the machine
>name and btgws304 is the database instance.
>
>BTGWS304 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = PORTAL)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = btgws304)
> )
> )
>
>Thanks for any pointers,
>TimJowers

Check out the alert log

--
Sybrand Bakker, Senior Oracle DBA