Shutdown Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Shutdown Database

  1. #1
    Join Date
    May 2001
    Posts
    82

    Question

    Hi,

    I am not ablt to shutdown the database.
    It gives me ORA-00106 error.

    I am not very sure what to do.
    There are no other sessions connected to the database.

    When I look at the Alert log it has 2 more error messages.
    ORA-1106 and ORA-1093.

    Please Help.

    Thanks in advance.

    Regards,
    Radha.
    Share on Google+

  2. #2
    Join Date
    Aug 2001
    Posts
    267
    try to connect to internal again without using sql*net .. Just like connect internal/oracle;

    set ORACLE_SID=------
    connect internal/oracle;
    shutdown immediate ;
    Raghu
    Share on Google+

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    It seems there is some other session active.

    Shutdown immediate; if it does not work..

    issue shutdown abort;

    Thanks
    Kishore Kumar
    Share on Google+

  4. #4
    Join Date
    May 2001
    Posts
    82

    Question

    I tried Shutdown (Normal & Abort) through Server Manager connecting as user internal, but it gives me the error message:

    ORA-00106: cannot startup/shutdown database when connected to a dispatcher

    What should I do ? Please help.

    Thank you.
    Share on Google+

  5. #5
    Join Date
    May 2001
    Posts
    82
    Any Suggestions??
    Share on Google+

  6. #6
    Join Date
    Sep 2001
    Posts
    27
    I believe you are running MTS and you will need to establish a dedicated server connection for svrmgrl in order to perform a shutdown.

    Try this:

    If the database is configured for MTS and a particular client requires a dedicated server, the client can be configured to use a dedicated server in one of the following ways:

    A net service name can be configured with a connect descriptor that contains (SERVER=DEDICATED) in the CONNECT_DATA section. For example:

    sales=
    (description=
    (address=(protocol=tcp)(host=sales-server)(port= 1521))
    (connect_data=
    (service_name=sales.us.acme.com)
    (server=dedicated)))



    The client profile (sqlnet.ora file) can be configured with USE_DEDICATED_SERVER=ON. This adds (SERVER=DEDICATED) to the CONNECT_DATA section of the connect descriptors the client uses. For example:

    use_dedicated_server=on


    I have used the sqlnet.ora parameter before and it works.
    Good luck.


    Share on Google+

  7. #7
    Join Date
    May 2001
    Posts
    82
    Thank you yanert98
    Share on Google+

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