autostart on Windows NT with oracle 8
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: autostart on Windows NT with oracle 8

  1. #1
    Join Date
    May 2000
    Posts
    4
    Hi,

    i tried to startup an Oracle instance (version 8) on WinNT 4.0 setting the services in Regedit to Manually, created a CMD. with following sentence:
    oradim -startup -sid XXX -usrpwd ORACLE -pfile f:\XXX\pfile\initXXX.ora -starttype srvc,inst

    put it in the ...Micorsoft/system/Winlogon as a command and it doesn't function.

    I recieved following message in the oradim.log:
    ****************************************
    Oradim80: Command Line Mode.
    ----------------------------

    Please specify service or instance to start.
    ****************************************

    Can someone tell me what I'm doing wrong?`

    Is there a better way to startup automatically an oracle instance? I' tried it with the automatically way and didn't function.

    Thanks a lot in advance!

    Uiyi
    Willi

  2. #2
    Join Date
    Aug 2000
    Location
    York - England
    Posts
    33
    UiYi

    Did you set the Oracle Sid prior to running Oradim
    Set oracle_sid = database_name

    I woul dnot recommend using Oradim to start/stop a database as you have to have the internal password in a file which could breach security for your site

    Create a user and grantthat user the SYSOPER role
    Then connect username/password as sysoper for this user and all this user can do is start/stop the database and nothing else. Therefore the integrity and security of the database remains in tact

    I hope this helps

    Cheers
    :p :p :p

Posting Permissions

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


Click Here to Expand Forum to Full Width