Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Cannot connect to running instance

    I'm experiencing a problem:
    I've reset redo.log files after an improper recovery from a tape.
    Just after the redo logs have been reset, all utilities and programs seemed to work properly.
    However, after i've made a new backup and restarted the host computer, oracle came up, but any program like sqlplus or exp now hangs tuing to establish a connection. They doesn't even show any error messages!
    Moreover, oracle does not shutdown normal or immediate after a connection attemt was made.

    I'm searching the web and the manual a few days - no result.

    Would you guys throw out a little hint at a possible ways for resolving this problem?

    Sorry for my ugly english

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    No OS or OS version. :-(
    No specific version of DB. :-(
    No actual error message (& claims none exist).
    Can you at least share with us the lines at the tail end of the alert_SID.log file which likely contains helpful clues as to what really is happening inside the database?
    Until then You're On Your Own (YOYO)!

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    SCO OpenServer Release 5.0.5
    Oracle 7.3.4

    tail aler_SID.log
    Completed: alter database open
    Thu Dec 18 10:27:41 2003
    Errors in file /u/app/oracle/admin/node/udump/ora_1041.trc:
    ORA-00600: internal error code, arguments: [2662], [0], [1235594], [0], [1235851
    ], [0], [], []
    Last edited by uxus; 12-17-03 at 22:03.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Deja vu' all over again.
    Friday I got a corrupted data block in the ROLLBACK tablespace.
    Oracle's only "advice" was to restore from a known good backup.
    Did so on Tuesday.
    However the DB refused to open with EXACTLY the same
    ORA-00600 [2662]... fingerprint
    SO I opened yet another iTAR and was told that this known bug is
    fixed in 10.0.1 and my only recourse was to restore from a known good backup; which I did today.
    Thank $Diety for backups. My DB is back online.
    YOYO!

  5. #5
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi chaps,

    It's not the sort of thing we want to be hearing about Oracle really. It's obviously a bit of a worry.

    The software which I deal with is such that the nature of the software and the size of the companies means that there is usually a ~4 hour window for a cold backup (that's heaven from what I hear!).

    Everything I've read so far about hot backup fills me with dread, nervous anticipation and fear :-(

    All the best,
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •