RE: ORA-00257 :Urgent

From: Sonja Sehovic <sonja.sehovic_at_zg.tel.hr>
Date: Thu, 18 Jan 2001 16:03:55 +0100
Message-Id: <10745.126997@fatcity.com>

Sorry I didn't read this mail sooner. I might help you. Yes well, it works fine BEFORE 8i database. We had same problem the other day (8.1.7). After cleaning archive destinations (we have two) our database didn't respond. Database didn't react on ALTER SYSTEM SWITCH LOGFILE;
We reported it to Oracle. It is a BUG!
WORKAROUND:
If you have in your init.ora file parameter LOG_ARCHIVE_DEST_n you should write

LOG_ARCHIVE_DEST_n ="LOCATION/.....REOPEN =5" Try with: ALTER SYSTEM ARCHIVE LOG START TO '<current destination>';

HTH,
Sonja

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of dgoulet_at_vicr.com
Sent: Wednesday, January 17, 2001 8:41 PM To: Multiple recipients of list ORACLE-L Subject: Re:ORA-00257 :Urgent

Ajay,

ORA-00257 means the archiver is stuck. To correct:

connect internal via svrmgrl
run "archive log list"
look for where the archiver belives it's sending the log files, ex:

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /ora1/archive/active/  <--- here we are
Oldest online log sequence     168479
Next log sequence to archive   168481
Current log sequence           168481

4) check out this area, is it out of space? If so, do whatever you usually do
to clean it out, the archiver will resume by itself.

____________________Reply Separator____________________
Author: "Ajay Khandelwal" <ajay_at_tems.com>
Date:       1/17/2001 10:50 AM

Hi Guys,
while trying to connect to one of my database users getting ora-00257 can't conn connect only as internal acr error. I checked the disk space which looks ok. what should be the possible fix.
TIA
-Ajay

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ajay Khandelwal
INET: ajay_at_tems.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message