DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: startup database

  1. 10-14-2003, 01:37 AM #1
    Avi123india
    Avi123india is offline Junior Member
    Join Date
    Apr 2003
    Posts
    16

    startup database

    Hi,

    I m using Oralce 8.1.6 on win 2000 with default database (DB_name = orcl and SID=orcl)
    I'hv created new database((DB_name = test and SID=test) but whenever
    i restart my server i hv to start database(startup pfile=...) and then
    only it is available for use.

    What i want is to start the database automatically when system start.


    Any expert can help.


    Thanks !!
    Avi
    Reply With Quote Reply With Quote
  2. 10-14-2003, 02:25 AM #2
    mdash
    mdash is offline Junior Member
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    ORA__AUTOSTART =TRUE in the registry
    Reply With Quote Reply With Quote
  3. 10-14-2003, 08:57 AM #3
    gbrabham
    gbrabham is offline Member
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    Ensure that the Service is set for AUTOMATIC in the Services panel
    Service is "OracleServiceXXXX" xxxx is the instance name.

    As mentioned, in the registry
    hkey_local_machine\software\oracle\home0\ ORA_XXXX_AUTOSTART TRUE

    Ensure that the entry for ORA_XXXX_PFILE is the correct initialization
    file to startup the database (and is in the correct location).

    Gregg
    Reply With Quote Reply With Quote
  4. 10-14-2003, 12:56 PM #4
    bhallar
    bhallar is offline Member
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    When u create a Database manually in Window NT u need to create init.ora file under $ORACLE_HOME/database which should have only one entry like
    IFILE='d:\oracle\admin\mydb\pfile\initmydb.ora'

    Just like a softlink in unix. Pls check this out if u don't have create one , hope this would resolve urs problem.
    Reply With Quote Reply With Quote
  5. 10-14-2003, 05:17 PM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and why would that stop his database autostarting. Also you dont need to have ifile =xxx to start any database
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width