Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2010
    Posts
    27

    Unanswered: create a windows script to automate shutdown databases during maintainance

    Can any one please me the script to automate shutdown databses during maintainance.
    The script would be scheduled from the Windows server and will be shutting down databases hosted in AIX server .

    Thanks,

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >The script would be scheduled from the Windows server and will be shutting down databases hosted in AIX server .

    via what mechanism does Windows interact with AIX system?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2010
    Posts
    27

    create a windows script to automate shutdown databases during maintainance

    Windows will interact with AIX with winscp.

    Thanks,

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Windows will interact with AIX with winscp.
    Winscp is Secure CoPy
    OK, you can copy I am not sure what from Windows to AIX.
    Now what does Windows do next to achieve the desired goal?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2010
    Posts
    27

    create a windows script to automate shutdown databases during maintainance

    Windows server will interact with Aix servers using SQLPLUS COMMANDS (TNSNAMES).

    Please let me know because I am working on this issue and it needs to be resolved.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Sql> shutdown immediate
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Why not schedule it on the AIX server. It would be much easier!
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  8. #8
    Join Date
    Jun 2010
    Posts
    27

    script

    I need to write a script which should be scheduled from Windows server in order to startup and shutdown the AIX servers.

    What all we need to set up in the Windows batch profile.

    Windows server will interact with AIX servers using sql commands (Tnsnames)

    Please let me know the script which needs to be written and the settings which we need to do in the batch profile for automatic startup and shutdown of AIX servers from Windows server.

    Thanks

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    just place in the *BAT file the same commands as you would issue manually to do what needs to be done
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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