Results 1 to 11 of 11
  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Unanswered: Database starting automatically?

    hi

    now we are starting the database manually like this
    >svrmgrl
    >connect internal
    >startup

    I want to start the database automatically when system is starting ans also closing automatically.
    How to do automatically.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    For example, our Oracle 7 database runs under OpenVMS. In system startup file (systartup_vms.com) is a line of a code
    Code:
    submit/noprint/user=ora7 disk0:[oracle7.code.db_kcora7]startup_exclusive_kcora7

    which starts the database up during system startup process. (It is a .com file that invokes .sql file that connects internal and starts up the DB).

    Something like that stands in a shutdown file (and it closes the database) - only, be careful to leave enough time for database to close before system shuts down.

    If your system runs under Windows, use "Scheduled Tasks"; write a script that will start up your database and schedule it "At System Startup".
    I wouldn't know how to shut down a database automatically during Windows shutdown process ... perhaps there's someone who can tell you how to accomplish this task.

    And if you have another operating system, I have no idea how to do that

  3. #3
    Join Date
    Nov 2003
    Location
    Belgium
    Posts
    25

    Starting under Unix

    Quote Originally Posted by m_sreedhar
    hi

    now we are starting the database manually like this
    >svrmgrl
    >connect internal
    >startup

    I want to start the database automatically when system is starting ans also closing automatically.
    How to do automatically.
    When you install Oracle under Unix, you will have some scripts to start the DB (like dbstart, ...). You must write which will accept the two parameters stop and start. Copy this script in the /ect/init.d directory (as root) and make link in the directory /ect/rcx.d called SxxOracle and KxxOracle.
    (xx = number e.g. S99Oracle). Automatically when you reboot the Unix, your Oracle DB will stop and restart.

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    As you can see, it is different depending on your OS ...

    If it is Windows based, Set the SERVICE to automatic and in the registry
    ensure that the Oracle_sid_AutoStart is set to "True"


    HTH
    Gregg

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    this might be helpful for Unix-based:
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Quote Originally Posted by m_sreedhar
    hi

    now we are starting the database manually like this
    >svrmgrl
    >connect internal
    >startup

    I want to start the database automatically when system is starting ans also closing automatically.
    How to do automatically.
    That depends on your OS. Each OS flavor has it's own scripts.

    What is your OS - so we can help you ???


    HTH,

    clio_usa - OCP 8/8i/9i DBA

  7. #7
    Join Date
    Nov 2003
    Posts
    10
    Quote Originally Posted by clio_usa
    That depends on your OS. Each OS flavor has it's own scripts.

    What is your OS - so we can help you ???


    HTH,

    clio_usa - OCP 8/8i/9i DBA




    i am using windows 2000 server OS.

  8. #8
    Join Date
    Nov 2003
    Posts
    10
    Quote Originally Posted by gbrabham
    As you can see, it is different depending on your OS ...

    If it is Windows based, Set the SERVICE to automatic and in the registry
    ensure that the Oracle_sid_AutoStart is set to "True"


    HTH
    Gregg


    hi

    SERVICE is automatic and ORACLE_SID_AUTOSTART is true. Both are setting correct.But database is not starting.

  9. #9
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    in %ORACLE_HOME%\database directory, create a file initSID.ora with this line in it:

    IFILE='c:\dir\dir\initSID.ora'

    Then try again by restarting the OracleServiceSID


    HTH,

    clio_usa - OCP 8/8i/9i DBA

  10. #10
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Along with the response from CLIO_USA ... ensure you path is correct ...
    Is this the only SID on the machine ??

    Gregg

  11. #11
    Join Date
    Nov 2003
    Posts
    10
    Quote Originally Posted by clio_usa
    in %ORACLE_HOME%\database directory, create a file initSID.ora with this line in it:

    IFILE='c:\dir\dir\initSID.ora'

    Then try again by restarting the OracleServiceSID


    HTH,

    clio_usa - OCP 8/8i/9i DBA

    The above path was already there.Is any other settings are needed?

Posting Permissions

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