help, auto startup (open) of Oracle 8 db

From: Tim Jowers <timjowers_at_yahoo.com>
Date: 3 Jun 2004 11:04:21 -0700
Message-ID: <b1b4167f.0406031004.26e3be2f@posting.google.com>

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 Received on Thu Jun 03 2004 - 13:04:21 CDT