Instance terminated. Need to restart the DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Instance terminated. Need to restart the DB

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    25
    Oracle 816
    Win2000

    I increased the number of processes in the init.ora and wanted to restart the database. At command prompt gave sqlplus
    then connected as system/manager@oracle1 as sysdba
    and issued shutdown immediate
    didnot get any response.then says instance terminated.
    when i came out of sqlplus.
    could not connect again........

    urgent Help required

  2. #2
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    1. Shutdown can be given only from svrmgrl (m) prompt.
    2. you may have a tns problem (not a database one)
    3. however you can go back (with the parameter you changed)

  3. #3
    Join Date
    Oct 2000
    Posts
    25

    I tried from svrmgr as well

    I tried from svrmgrl as well.
    Since its ora8i, oracle recommends that we start using sqlplus.

    Problem is solved now.
    I restarted the server and shutdown and startup thru svrmgr.
    svrmgr is the best way of doing these operations but oracle is changing everything.
    Any way thanks a lot.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Wink

    Oracle wants to keep DBA`s positions in the market always. They keep giving hard time, taking of the support for products DBA`s are used to..

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