RE: AIX(VERSION 4) /Oracle8172

From: Martha Delgado <mdelgado_at_devoto.com.uy>
Date: Mon, 14 Jun 2004 12:36:38 -0300
Message-ID: <003601c45225$629de8c0$79c809c0@PCMARTHAD>

Hi,
It's a fact that you have these errors because AIX doesnīt handle such big files; I donīt remember exactly the maximum size for the datafiles; but is a limitation of the operating system.
I had an oracle database 8.1.7 with AIX 4.3.3; thereīs an attribute that enables the operating system to handle big files; you have to initialize this attribute when you define the oracle administrator's user , and Iīm sure you wonīt have problems.
regards,

Martha

-----Mensaje original-----

De: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]En nombre de Seema Singh Enviado el: Lunes, 14 de Junio de 2004 12:03 p.m. Para: oracle-l_at_freelists.org
Asunto: AIX(VERSION 4) /Oracle8172

Hi,

I have one instance on AIX version 4 .This instance is crashing on regular basis.I have been noticing following problem.

ORA-16038: log 3 sequence# 723 cannot be archived
ORA-19502: write error on file "", blockno  (blocksize=)
ORA-00312: online log 3 thread 1: '/u02/oradata/DSS/redo3a.log'
ORA-00312: online log 3 thread 1: '/u04/oradata/DSS/redo3b.log'

ARCH: Connecting to console port...
ARCH: or
ORA-00476: RECO process terminated with error PMON: terminating instance due to error 476 Instance terminated by PMON, pid = 133128 or
ARC1: Error 19504 creating archivelog file '/u06/oracle/b

These all errors are coming since we created maxsize 2048m of datafiles in autoextend mode.
AIX version is 4.I'm assuming AIX 4 doesn't handle 2GB files.Metalink say it's due to file size.Doesn any one have such situation in past? If yes how did fixed pl? ANy suggestions are welcome. thx
-seema

---

MSN Toolbar provides one-click access to Hotmail from any Web page – FREE download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Jun 14 2004 - 10:43:48 CDT