Results 1 to 5 of 5

Thread: bounce database

  1. #1
    Join Date
    May 2003
    Posts
    58

    Unanswered: bounce database

    Hi,

    Could someone please tell how to bounce a database (after changing init.ora). Please outline steps or please show me some documentation. Appreciate any help!

    Thanks in advance.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Depends on what version of Oracle you're using ...

    from command prompt:
    svrmgrl

    svrmgrl> set instance xxxx
    svrmgrl> connect internal/password@sid
    svrmgrl> shutdown immediate

    svrmgrl> startup pfile=c:\....\initxxx.ora

    Oracle 9 ... use sqlplus

    HTH
    Gregg

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    You can also bounce a database through OEM (assuming you use OEM, of course). Although it doesn't give you the same control as SQL (because all you can do is click on the buttons/choices that it offers you) it does make it easier for you to perform tasks like this if your knowledge of sql is not as good as it should be.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Apr 2004
    Posts
    35
    in oracle 9i

    you can use

    startup force
    when connect to sysdba
    this will shutdown and restart the database

    or you use spfile instead of pfile for if your are doing changes in init parameters

    skg

  5. #5
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    A complete procedure for How to Startup, shutdown and check Oracle instance and listener could be found at this URL.

    It has both UNIX & Windows (8i & 9i) commands..


    HTH,

    clio_usa - OCP 8/8i/9i DBA

Posting Permissions

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