FAQ
Guys,
I have an just finished upgrading to 8.1.7 on all my boxes some of which are
Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0.
But on Windows2000, every time the box is rebooted the instance does not
come up automatically. However the service shows as running. I checked the
registry to make sure I had ORACLE_SID set right.

I have to manually start the instance every time and its a pain in the 'you
know what'. If anyone has had this problem and solved it please let me know
the solution.

Thanks,
Uma Mohoni
Consultant, CDI Corporation
@ iKimbo Inc.
500-A Huntmar Park Drive
Herndon, VA 20170
(703) 904-4150 Ext:237
umohoni_at_ikimbo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Uma Mohoni
INET: umohoni_at_ikimbo.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Igor Neyman at Aug 30, 2001 at 5:01 pm
    Add:

    ORA_%SID%_AUTOSTART "TRUE"

    value in the registry for your ORACLE/HOME.

    Igor Neyman, OCP DBA
    Perceptron, Inc.
    (734)414-4627
    ineyman_at_perceptron.com

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Thursday, August 30, 2001 1:03 PM
    Guys,
    I have an just finished upgrading to 8.1.7 on all my boxes some of which are
    Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0.
    But on Windows2000, every time the box is rebooted the instance does not
    come up automatically. However the service shows as running. I checked the
    registry to make sure I had ORACLE_SID set right.

    I have to manually start the instance every time and its a pain in the 'you
    know what'. If anyone has had this problem and solved it please let me know
    the solution.

    Thanks,
    Uma Mohoni
    Consultant, CDI Corporation
    @ iKimbo Inc.
    500-A Huntmar Park Drive
    Herndon, VA 20170
    (703) 904-4150 Ext:237
    umohoni_at_ikimbo.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Uma Mohoni
    INET: umohoni_at_ikimbo.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Igor Neyman
    INET: ineyman_at_perceptron.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Koivu, Lisa at Aug 30, 2001 at 5:14 pm
    Well, this may not be the absolutely correct way to do it... but this is what I did

    write a batch script that does the oradim call to start services and instance

    Put it in the batch scheduler and choose runtime as 'on system startup'

    Hasn't failed me yet.

    Lisa Koivu
    Blonde Vikings Fan and DBA
    Ft. Lauderdale, FL, USA

    (I'll be wearing my blonde wig to the game tommorrow.  Listen for me on TV)

    -----Original Message-----

    From:   Uma Mohoni [SMTP:umohoni_at_ikimbo.com]
    Sent:   Thursday, August 30, 2001 1:04 PM
    To:     Multiple recipients of list ORACLE-L

    Subject:        8.1.7 on W2K

    Guys,
    I have an just finished upgrading to 8.1.7 on all my boxes some of which are
    Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0.
    But on Windows2000, every time the box is rebooted the instance does not
    come up automatically. However the service shows as running. I checked the
    registry to make sure I had ORACLE_SID set right.

    I have to manually start the instance every time and its a pain in the 'you
    know what'.  If anyone has had this problem and solved it please let me know
    the solution.

    Thanks,
    Uma Mohoni
    Consultant, CDI Corporation
    @ iKimbo Inc.
    500-A Huntmar Park Drive
    Herndon, VA 20170
    (703) 904-4150 Ext:237
    umohoni_at_ikimbo.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Uma Mohoni
    INET: umohoni_at_ikimbo.com

    Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
    San Diego, California        -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from).  You may
    also send the HELP command for other information (like subscribing).
  • Jack C. Applewhite at Aug 30, 2001 at 8:53 pm
    Uma,

    Check your registry to ensure that the key ORA__AUTOSTART is set to
    TRUE. That will start the instance after the Service starts.

    It's documented for 8.1.6 in Appendix B "Oracle8i Configuration Parameters
    and the Registry" in "Oracle8i Client Administrator's Guide Release 2
    (8.1.6) for Windows". There you'll also find out other goodies, like how to
    set up for the instance to Shutdown Immediate when the server is shutdown.

    Jack

    Jack C. Applewhite
    Database Administrator/Developer
    OCP Oracle8 DBA
    iNetProfit, Inc.
    Austin, Texas
    www.iNetProfit.com
    japplewhite_at_inetprofit.com
    (512)327-9068

    -----Original Message-----
    Sent: Thursday, August 30, 2001 12:04 PM
    To: Multiple recipients of list ORACLE-L

    Guys,
    I have an just finished upgrading to 8.1.7 on all my boxes some of which are
    Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0.
    But on Windows2000, every time the box is rebooted the instance does not
    come up automatically. However the service shows as running. I checked the
    registry to make sure I had ORACLE_SID set right.

    I have to manually start the instance every time and its a pain in the 'you
    know what'. If anyone has had this problem and solved it please let me know
    the solution.

    Thanks,
    Uma Mohoni
    Consultant, CDI Corporation
    @ iKimbo Inc.
    500-A Huntmar Park Drive
    Herndon, VA 20170
    (703) 904-4150 Ext:237
    umohoni_at_ikimbo.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Jack C. Applewhite
    INET: japplewhite_at_inetprofit.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • The Oracle DBA at Aug 31, 2001 at 12:39 pm
    Who created the DBs on NT? How?

    When you created the 817 DBs, did you use the GUI or did you use the command line and
    a script?

    did you use autostart?

    Cheers,

    Earl

    ---

    TheOracleDBA
    theoracledba_at_lycos.com

    On Thu, 30 Aug 2001 09:03:47
    Uma Mohoni wrote:
    Guys,
    I have an just finished upgrading to 8.1.7 on all my boxes some of which are
    Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0.
    But on Windows2000, every time the box is rebooted the instance does not
    come up automatically. However the service shows as running. I checked the
    registry to make sure I had ORACLE_SID set right.

    I have to manually start the instance every time and its a pain in the 'you
    know what'. If anyone has had this problem and solved it please let me know
    the solution.

    Thanks,
    Uma Mohoni
    Consultant, CDI Corporation
    @ iKimbo Inc.
    500-A Huntmar Park Drive
    Herndon, VA 20170
    (703) 904-4150 Ext:237
    umohoni_at_ikimbo.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Uma Mohoni
    INET: umohoni_at_ikimbo.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    Get 250 color business cards for FREE!
    http://businesscards.lycos.com/vp/fastpath/
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: The Oracle DBA
    INET: theoracledba_at_lycos.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 30, '01 at 3:53p
activeAug 31, '01 at 12:39p
posts5
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase