| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_01C080C0.43B119D0
Content-Type: text/plain;
charset="iso-8859-1"
My select statement was incorrect, use value instead of parameter.
SELECT name, value
from v$parameter
where name like 'log_archive_dest%';
-----Original Message-----
From: Garrity Ed R
Sent: Wednesday, January 17, 2001 2:59 PM
To: 'ORACLE-L_at_fatcity.com'
Subject: 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_at_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_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). ------_=_NextPart_001_01C080C0.43B119D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Wed Jan 17 2001 - 14:01:22 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: ORA-00257 :Urgent</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>My select statement was incorrect, use value instead =
of parameter.</FONT>
</P>
<P><FONT SIZE=3D2>SELECT name, value</FONT>
<BR><FONT SIZE=3D2>from v$parameter</FONT>
<BR><FONT SIZE=3D2>where name like 'log_archive_dest%';</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Garrity Ed R </FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, January 17, 2001 2:59 PM</FONT>
<BR><FONT SIZE=3D2>To: 'ORACLE-L_at_fatcity.com'</FONT>
<BR><FONT SIZE=3D2>Subject: RE: ORA-00257 :Urgent</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>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.</FONT></P>
<P><FONT SIZE=3D2>To determine the location, Connect internal and use =
the following select:</FONT>
</P>
<P><FONT SIZE=3D2>SELECT name, parameter</FONT>
<BR><FONT SIZE=3D2>from v$parameter</FONT>
<BR><FONT SIZE=3D2>where name like 'log_archive_dest%';</FONT>
</P>
<P><FONT SIZE=3D2>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.</FONT></P>
<P><FONT SIZE=3D2>Ed</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Ajay Khandelwal [<A =
HREF=3D"mailto:ajay_at_tems.com">mailto:ajay_at_tems.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, January 17, 2001 1:50 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: ORA-00257 :Urgent</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi Guys,</FONT>
<BR><FONT SIZE=3D2>while trying to connect to one of my database users =
getting ora-00257 can't</FONT>
<BR><FONT SIZE=3D2>conn connect only as internal acr error.</FONT>
<BR><FONT SIZE=3D2>I checked the disk space which looks ok.</FONT>
<BR><FONT SIZE=3D2>what should be the possible fix.</FONT>
<BR><FONT SIZE=3D2>TIA</FONT>
<BR><FONT SIZE=3D2>-Ajay</FONT>
</P>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Ajay Khandelwal</FONT>
<BR><FONT SIZE=3D2> INET: ajay_at_tems.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
 |
 |