Results 1 to 7 of 7
  1. #1
    Join Date
    May 2003
    Posts
    45

    Unanswered: oracle databse startup problem

    I have system installed with oracle8i+developer6i with a windows-2000 o.s.
    everything fine with win-2000. I have recently upgraded the system to win-xp professional after which the database does not start automatically.Every time i need to start it manually.

    Any ideas how to make it automatic.

    Thanx

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Check the registry to ensure that the ORA_sidname_AUTOSTART = TRUE

    HTH
    Gregg

  3. #3
    Join Date
    May 2003
    Posts
    45
    Yes in the registry oracle_sidname_autostart is set to true...Even then no good

  4. #4
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106
    did you try to re - oradim the instance?
    Refer to manual:
    http://download-west.oracle.com/docs...ymig.htm#27759
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  5. #5
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Hi,
    I believe u can set the service of this database in AUTO mode and whenever the m/c is started the database service will come-up. Like all other services in windows....We have done it here...

    Regards,
    Kamesh Rastogi
    - KR

  6. #6
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Edit your Windows service startup mode:

    c:\> set oracle_sid=......

    c:\> oradim -edit -sid ........ -startmode a


    HTH,

    clio_usa - OCP 8/8i/9i DBA

  7. #7
    Join Date
    May 2003
    Posts
    45
    I have checked service of this databse...it was set to AUTO only,but the status show starting...and all the other options restart,start ...are not active....so I went to properties options -- recovery tab and slected restart option on first faliure ..and restated the machine..but still no good.


    i did not understand what 'clio_usa' said.


    thanx

Posting Permissions

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