Re: Oracle 10g Release 2 OpenVMS I64 V8.4 porting OpenBravo ERP

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Thu, 24 Mar 2011 13:51:48 -0400
Message-ID: <WwLip.753751$De6.463590_at_en-nntp-01.dc1.easynews.com>


"BillPedersen" <wmapedersen_at_gmail.com> wrote in message news:add047bc-ce58-4df0-9772-d22c23c777fe_at_j13g2000pro.googlegroups.com... On Mar 10, 11:46 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> Sounds like a bad query somehow ... can you try running that query
> thru some other tool ( like SQL Developer or Toad etc ) to give you
> some idea on what needs to be check out and/or fixed?
>
> Ok, finally got my Oracle 10gR2 Linux (x86) implementation up and
> running and it gets past the offending point in the code.
>
> Configuration is:
>
> ANT and necessary code residing on OpenVMS I64 V8.4 with Oracle JDBC
> Thin Driver pointing at the Linux DB instance.
>
> Linux environment is Red Hat V4.8 with Oracle 10gR2.
>
> In this environment the ANT build of OpenBravo ERP is proceeding... I
> has proceeded past the point of failure when entirely on OpenVMS.
>
> So this points at the NETV2 process as either not having sufficient
> quotas or similar. I would generally doubt privileges as well over
> 15000 SQL transactions had already been processed and additionally
> other transactions of a similar nature have been executed. I am
> leaning toward the quotas as the particular transaction is fairly
> large but not to the extent of surpassing SQL limits as it has run
> properly in this other environment.
>
> Any suggestions?
>
> Any place I should look for the particular quotas the NETV2 server is
> started with and possibly how to change?
>
> Now, that said, I have now seen an error - farther on, where is it
> JAVA and fork oriented... So I will need to explore that problem now
> while I think of the other issues and talk with folks.
>
> Thanks,
>
> Bill.
>

I have these quotas setup on my Oracle server, and they are based upon Oracle's recommendations (among others, I run lots of different things on that server).

SYSGEN> SHOW PQL_M
Parameter Name Current Default Min. Max. Unit Dynamic

--------------            -------    -------   -------    -------  ----  -------
PQL_MASTLM                   2048          4         4         -1 Ast 
D
PQL_MBIOLM                   1000          4         4         -1 I/O 
D
PQL_MBYTLM                1000000     128000    128000         -1 Bytes 
D
PQL_MCPULM                      0          0         0         -1 10Ms 
D
PQL_MDIOLM                   2048          4         4         -1 I/O 
D
PQL_MFILLM                   2048          2         2         -1 Files 
D
PQL_MPGFLQUOTA            2000000     512000    512000         -1 Pagelets 
D
 internal value            125000      32000     32000         -1 Pages 
D
PQL_MPRCLM                     20          0         0         -1 Processes 
D
PQL_MTQELM                   2000          0         0         -1 Timers 
D
PQL_MWSDEFAULT              43888      16384     16384         -1 Pagelets
 internal value              2743       1024      1024         -1 Pages
PQL_MWSQUOTA                87776      32768     32768         -1 Pagelets 
D
 internal value              5486       2048      2048         -1 Pages 
D
PQL_MWSEXTENT             1873920      65536     65536         -1 Pagelets 
D
 internal value            117120       4096      4096         -1 Pages 
D
PQL_MENQLM                   8192         64        64         -1 Locks 
D
PQL_MJTQUOTA                 8192          0         0         -1 Bytes 
D

HTH
Syltrem Received on Thu Mar 24 2011 - 12:51:48 CDT

Original text of this message