DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: connection closed

  1. #1
    Join Date
    Apr 2000
    Location
    arlington, va USA
    Posts
    24
    When I try to connect to a database through my dba studio I get

    connection closed error

    First, why is this connection closed. ( I know that if the server crashes it can end the connection.)

    How do I start this connection again?

    Please advise

    Thanks in advance
    DBAWannaB

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Is your database active/functional?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Apr 2000
    Location
    arlington, va USA
    Posts
    24

    sam connection closed

    How do I know if it is active. I cant get anywhere in it. I get connection closed.
    Everytime I try to start the database through dbastudio it just stops on me with no error.

    Please help!!!
    DBAWannaB

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    So at this point it looks like your database instance is down. Now startup and mount the database using the server manager. Then take the tablespace offline immediate. Then issue the alter database datafile ... offline drop; Then issue alter database open...

    There had been a number of thread discussion on this isssue. So my advise is to use the search forms option to view all those related threads.

    If you have any problems, please let us know and we would be glad to help you.

    Sam

    [Edited by sambavan on 09-24-2001 at 03:47 PM]
    Thanx
    Sam



    Life is a journey, not a destination!


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