Newbee Question: oracle startup + shutdown
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Newbee Question: oracle startup + shutdown

  1. #1
    Join Date
    Apr 2001
    Posts
    13

    Question

    We don't have a DBA in our company and I am asked to do a simple shut down/start up script for backup purposes. With my limited DBA knowledge and a bit of reading, I came up with:

    Shutdown:

    sqlplus
    connect sys/password
    shutdown transactional
    exit

    Startup:

    sqlplus
    connect sys/password
    startup
    exit

    Will this work? Or am I totally naive? This is a development database by the way and there is only two developers currently.

    Also, when I issue: connect sys/password, I got a protocol error. Can someone tell me why? Thanks!

  2. #2
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    You need to set the Oracle_sid for which you are starting and shutting down

    Set the SID then do your sqlplus, then connect sys/password

    For our shutdowns we use shutdown immediate rather than transactional. If someone is logged in to the database with a transaction started and not commited the database will set and wait for the transaction to commit before it shutsdown. If theis person is gone for the night the db will never shut down
    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  3. #3
    Join Date
    Apr 2001
    Posts
    13
    Can anyone tell me what is the command to set the SID? Thanks!

  4. #4
    Join Date
    Jan 2001
    Posts
    61
    The Command to set The ORACLE_SID is

    SET ORACLE_SID=

    Then you can verify the ORACLE_SID you just set

    Unix
    echo $ORACLE_SID

    NT
    echo %ORACLE_SID%

    Ravi

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