RE: AIX(VERSION 4) /Oracle8172

  • From: M.K.Jha@xxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx, oracledbam@xxxxxxxxxxx
  • Date: Tue, 15 Jun 2004 11:03:00 +0100

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@xxxxxxxxxxx]
Sent: Tuesday, 15 June 2004 1:03 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


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


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

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: