The database becames unreachable!!!
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 24

Thread: The database becames unreachable!!!

  1. #1
    Join Date
    Aug 2002
    Location
    Sofia, Bulgaria
    Posts
    84

    Question The database becames unreachable!!!

    I have the following problem:
    I have a production database(Oracle version 8.1.7) running on Windows2000,on which is running project with web interface(we are using jsp and tomcat). A few weeks ago something unexplainable has happened. A database became unreachable and I could not neither logon on the database server or the database. I checked the alert.log file, oracle.exe process but I could not find anything strange. A few times a day in the last weeks the database became unreachable and only thing I could do is to restart the database. But this doesn't solve my problem.
    I will appreciate any suggestions!
    Radoslav Rusinov
    OCP 8i,9i,10g DBA
    http://dba-blog.blogspot.com

  2. #2
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97

    Question

    You obtain to connect to the base for some another applicatory one?
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  3. #3
    Join Date
    Aug 2002
    Location
    Sofia, Bulgaria
    Posts
    84
    the applications with web interface became very slowly. When I am trying to connect to the database through DBA Studio(for example) the connection is timed out. When I am trying to connect to the server on which is running the database with remote administration tool, I must wait a few minutes for response. The whole computer on which the database is running is unreachable. After while,when I connect through remote administration tool, I check the oracle.exe process and CPU but there is no obviosly problem. In alert.log file nothing is writed too.
    Radoslav Rusinov
    OCP 8i,9i,10g DBA
    http://dba-blog.blogspot.com

  4. #4
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    Possibly problem of memoria or I/O. What more you it executes in this server? Which the size of the SGA?
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  5. #5
    Join Date
    Aug 2002
    Location
    Sofia, Bulgaria
    Posts
    84
    please, check sga_size.html for reference.
    The most executed on this database are DML's, especially updates
    Attached Files Attached Files
    Radoslav Rusinov
    OCP 8i,9i,10g DBA
    http://dba-blog.blogspot.com

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you bounce the database and that doesn't fix your problem, it sounds like a networking error. I would get your network guys to sniff the wire while you are having these problems. Also, a more specific Oracle error message/number would help.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Aug 2002
    Location
    Sofia, Bulgaria
    Posts
    84
    in the alert.log file no error is logged. How can I understand what makes the database unreachable. May be JDBC driver is old, but this problem appears one month ago and I was not change anything before that happens.
    Radoslav Rusinov
    OCP 8i,9i,10g DBA
    http://dba-blog.blogspot.com

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    someone would give nfos such as.

    Am I using thin or thick JDBC?

  9. #9
    Join Date
    Aug 2002
    Location
    Sofia, Bulgaria
    Posts
    84
    tell me yours suggestions: which views,etc. will you check if you have such kind of problem. Because it's unexplainable - sometimes it happens, sometimes not. The database activity is the same through all work day!
    The applications uses thin JDBC.
    Last edited by rado; 05-16-2003 at 03:24 AM.
    Radoslav Rusinov
    OCP 8i,9i,10g DBA
    http://dba-blog.blogspot.com

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Well do you know what JDBC are you using? Thin or Thick?

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