RE: AIX(VERSION 4) /Oracle8172

From: <M.K.Jha_at_ponl.com>
Date: Tue, 15 Jun 2004 11:03:00 +0100
Message-ID: <NX772f2c-332f48cc@eur.ponl.com>

Check the userelimit with following :
ulimit -a

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

The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete the e-mail and other copies of it from your computer system. Thank you.

We believe this email to be virus free but do not warrant that this is the case and we will not accept liability for any losses arising from any virus being transmitted unintentionally by us.

We reserve the right to monitor all E-mail communications through our network

ForwardSourceID:NT0000454A

We believe this email to be virus free but do not warrant that this is the case and we will not accept liability for any losses arising from any virus being transmitted unintentionally by us.

We reserve the right to monitor all E-mail communications through our network

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

Received on Tue Jun 15 2004 - 05:01:19 CDT