RE: Autostart at boottime-Oracle8

Ravi,

If you change the password for internal manually using ORAPWD80, it does not change the batch file used by the Oracle service to start the db:
oracle_home\DATABASE\STRT<sid>.CMD. You can manually edit the file to specify the new password for internal or you can recreate the database services using ORADIM80. Yes, it's a gaping security hole. You're supposed to change the permissions on the file so no one else can read it. I think they may have eliminated this file on 8i, but I don't have a db handy to check it.

Keep in mind that the service will start as long as it can execute the STRT<sid>.CMD file, regardless of whether the commands within the file execute properly.

One other culprit that can prevent the services from starting is tabs in the init.ora file. I can't remember the bug #, but oradim can't process the init.ora file if there are tabs in it, but the db will start fine from server manager.

HTH,

• Anita
  • "Miller, Bryan" <MillerB_at_telergy.net> wrote:
    > Check in control panel under services, make sure all
    > of the Oracle services
    > are set to start on boot.
    > Bryan M. Miller
    > Junior Oracle DBA
    > IT Operations
    > Telergy Inc.
    > Email: bmiller_at_telergy.net
    > Phone: (315)362-2642
    > Pager: (315)647-1908
    >
    >
    > -----Original Message-----
    > From: Ravi Babu [mailto:lravibabu_at_hotmail.com]
    > Sent: Thursday, July 06, 2000 6:25 AM
    > To: Multiple recipients of list ORACLE-L
    > Subject: Autostart at boottime-Oracle8
    >
    > Hello,
    > For security reasons i have changed the internal
    > password
    > with the help of
    > ORAPWD80. After that whenever i restart the
    > server, oracle
    > is not auto
    > started and i have to start it explicitly. I am
    > using
    > Oracle8 ver 8.0.5 on
    > NT 4.0. I have checked the registry but not
    > finding any
    > variable to set for
    > autostart at boot. What should i try to make it
    > autostart at
    > bootime. Please
    > help.
    > Bye
    > Ravi.
    >
    >
    

    ---

    
    > Get Your Private, Free E-mail from MSN Hotmail at
    > http://www.hotmail.com
    >
    > --
    > Author: Ravi Babu
    > INET: lravibabu_at_hotmail.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).
    > --
    > Author: Miller, Bryan
    > INET: MillerB_at_telergy.net
    >
    > 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).
    

    ---