unable to log into oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: unable to log into oracle

  1. #1
    Join Date
    Dec 2001
    Posts
    120

    unable to log into oracle

    hi,

    we have been running our oracle 9i rel 2 database installed on Win2k server supported by dual xeon processors for almost 4 months now. All was ok till yesterday.. suddenly the bulk inserts failed and thereon the oracle server hanged. we could not log into the oracle server from any of the client machines nor could we do it from the server itself. it simply hanged with no error messages of any kind. the CPU usage of the xeon database server showed 25% being still utilized by the oracle server. This is a very high use of CPU by any standards. Normally it takes hardly 10 -12% of CPU time. How can that be possible when none of the users are connected to the database? We have ran bulk inserts even before and never we faced this kind of problem. Finally we had to restart the database server and after doing that it seems its working fine. I have checked the alert log and the trace files but there also couldn't find any problem. Plz suggest me what could have gone wrong?? and how to find out what's wrong if the same thing reappears..


    Parijat Paul

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    look your alert.log and trace files

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by pando
    look your alert.log and trace files
    Originally posted by parijat67
    I have checked the alert log and the trace files but there also couldn't find any problem.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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