Any limit on REdo logfile for 7.3.2 on 2.6

From: Chi-Wai <dleung_at_hill.ucr.edu>
Date: 10 Jun 1998 17:37:29 -0700
Message-ID: <6ln8s9$ccv$1@hill.ucr.edu>

Hi All,

Is there a limit on
logfile size (I mean redo log)?
(For Solaris 2.6 with 7.3.2 Oracle Server (non-parallel server))

Because if I use 30M ,it does not have problem when I create the database, it give me problem every single time when I need to re-create the controlfile.

It give me ORA 1620
no public thread are available.

If I change the following script to 10M, then NO MORE ERROR anymore.

Dominica Leung
dleung_at_cncx.com

---

create database "DATAWHSE"

    maxinstances 8
    maxlogfiles 32
    character set "US7ASCII"
    datafile

'/datawhse/oradata/DATAWHSE/system01.dbf' size 100M
    logfile

'/datawhse/oradata/DATAWHSE/redoDATAWHSE01.log' size 30M, <--
'/datawhse/oradata/DATAWHSE/redoDATAWHSE02.log' size 30M, <--
'/datawhse/oradata/DATAWHSE/redoDATAWHSE03.log' size 30M; <--
 

disconnect
spool off Received on Wed Jun 10 1998 - 19:37:29 CDT