RE: AIX(VERSION 4) /Oracle8172

From: Graeme Farmer <graeme.farmer_at_mincom.com>
Date: Tue, 15 Jun 2004 09:34:03 +1000
Message-ID: <DA5B390A2CBAA64AB2367C2EDA3210F60CA6569F@tqxbneclu03.root.tequinox.com>

Hi Seema,

for >2GB files, check out ulimit -d and ulimit -dH (values in OS blocks of 512kb) and if necessary upate /etc/security/limits (fsize, fsize_hard) for oracle user (or use smit).

Regards,
Graeme.

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

From: Seema Singh [mailto:oracledbam_at_hotmail.com] Sent: Tuesday, 15 June 2004 1:03 AM
To: oracle-l_at_freelists.org
Subject: 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

--

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Limited unless expressly stated otherwise.

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

Received on Mon Jun 14 2004 - 18:32:00 CDT