Message-Id: <10744.126926@fatcity.com> From: Garrity Ed R Date: Wed, 17 Jan 2001 14:59:10 -0500 Subject: RE: ORA-00257 :Urgent This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C080BF.F51DBE90 Content-Type: text/plain; charset="iso-8859-1" The most likely cause is that you have run out of space in the area where you are archiving your redo logs. If this is the case, you can free some space by moving your _archived_ redo logs to some place where you have room. The path location is in the initialization parameter LOG_ARCHIVE_DEST. If you are using 8i it will be in LOG_ARCHIVE_DEST_n. You could have up to 5 archive log destination areas, where n could be 1-5. To determine the location, Connect internal and use the following select: SELECT name, parameter from v$parameter where name like 'log_archive_dest%'; Once the archiving can archive all filled redo logs, users will be able to login once again. If someone is doing a mass update, insert or delete, or is importing, you will have to keep an eye on redo generation to see how fast the redo logs are filling. Ed -----Original Message----- From: Ajay Khandelwal [mailto:ajay@tems.com] Sent: Wednesday, January 17, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Subject: ORA-00257 :Urgent 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@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@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). ------_=_NextPart_001_01C080BF.F51DBE90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: ORA-00257 :Urgent

The most likely cause is that you have run out of = space in the area where you are archiving your redo logs.  If this = is the case, you can free some space by moving your _archived_ redo = logs to some place where you have room.  The path location is in = the initialization parameter LOG_ARCHIVE_DEST.  If you are using = 8i it will be in LOG_ARCHIVE_DEST_n.  You could have up to 5 = archive log destination areas, where n could be 1-5.

To determine the location, Connect internal and use = the following select:

SELECT name, parameter
from v$parameter
where name like 'log_archive_dest%';

Once the archiving can archive all filled redo logs, = users will be able to login once again.  If someone is doing a = mass update, insert or delete, or is importing, you will have to keep = an eye on redo generation to see how fast the redo logs are = filling.

Ed

-----Original Message-----
From: Ajay Khandelwal [mailto:ajay@tems.com]
Sent: Wednesday, January 17, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject: ORA-00257 :Urgent


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@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@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 =