| Title: | VAX and Alpha VMS |
| Notice: | This is a new VMSnotes, please read note 2.1 |
| Moderator: | VAXAXP::BERNARDO |
| Created: | Wed Jan 22 1997 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 703 |
| Total number of notes: | 3722 |
problem:
openvms (vax) V6.2 after installing all known patches
when using sysman to start sqlplus it fails with the following
error:
SYSMAN> do run DISK23:[ORACLE.ORACLE70.sqlplus]sqlplus
%SYSMAN-I-OUTPUT, command execution on node OZ
%DCL-W-ACTIMAGE, error activating image
DISK23:[ORACLE.ORACLE70.SQLPLUS]SQLPLUS
-CLI-E-IMGNAME, image file DSA3:[ORACLE.ORACLE70.SQLPLUS]SQLPLUS.EXE
-SYSTEM-F-EXQUOTA, exceeded quota
This problem occurs in a cluster as well as on standalone node
When running the executable from the dcl prompt it works ok.
pql and uaf parameters:
PQL_DDIOLM 18 18 -1 -1 I/O D
PQL_MDIOLM 4 4 -1 -1 I/O D
PQL_DFILLM 16 16 -1 -1 Files D
PQL_MFILLM 2 2 -1 -1 Files D
PQL_DPGFLQUOTA 8192 8192 -1 -1 Pages D
PQL_MPGFLQUOTA 512 512 -1 -1 Pages D
PQL_DPRCLM 8 8 -1 -1 Process D
PQL_MPRCLM 0 0 -1 -1 Process D
PQL_DTQELM 8 8 -1 -1 TimersD
PQL_MTQELM 0 0 -1 -1 Timers D
PQL_DWSDEFAULT 1205 100 -1 -1 Pages
PQL_MWSDEFAULT 1205 60 -1 -1 Pages
PQL_DWSQUOTA 2410 200 -1 -1 Pages D
PQL_MWSQUOTA 2410 60 -1 -1 Pages D
PQL_DWSEXTENT 2410 400 -1 -1 Pages D
PQL_MWSEXTENT 2410 60 -1 -1 Pages D
PQL_DENQLM 30 30 -1 -1 Locks D
PQL_MENQLM 4 4 -1 -1 Locks D
PQL_DJTQUOTA 1024 1024 -1 -1 Bytes D
PQL_MJTQUOTA 0 0 -1 -1 Bytes D
SYSTEM_OZ>>uaf sh system
Username: SYSTEM Owner: SYSTEM MANAGER
Account: SYSTEM UIC: [1,4] ([SYSTEM])
CLI: DCL Tables: DCLTABLES
Default: SYS$SYSROOT:[SYSMGR]
LGICMD: LOGIN
Flags:
Primary days: Mon Tue Wed Thu Fri
Secondary days: Sat Sun
No access restrictions
Expiration: (none) Pwdminimum: 8 Login Fails: 0
Pwdlifetime: 30 00:00 Pwdchange: 1-MAY-1997 07:35
Last Login: 27-MAY-1997 13:43 (interactive), 27-MAY-1997 14:15
(non-interactive)
Maxjobs: 0 Fillm: 300 Bytlm: 76092
Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0
Maxdetach: 0 BIOlm: 24 JTquota: 5120
Prclm: 10 DIOlm: 24 WSdef: 4096
Prio: 4 ASTlm: 200 WSquo: 8192
Queprio: 4 TQElm: 200 WSextent: 16384
CPU: (none) Enqlm: 200 Pgflquo: 150000
Authorized Privileges:
CMKRNL CMEXEC SYSNAM GRPNAM ALLSPOOL DETACH DIAGNOSE LOG_IO
GROUP ACNT PRMCEB PRMMBX PSWAPM ALTPRI SETPRV TMPMBX WORLD
OPER EXQUOTA NETMBX VOLPRO PHY_IO BUGCHK PRMGBL SYSGBL MOUNT
PFNMAP SHMEM SYSPRV BYPASS SYSLCK SHARE GRPPRV READALL
SECURITY
Default Privileges:
CMKRNL CMEXEC SYSNAM GRPNAM ALLSPOOL DETACH DIAGNOSE LOG_IO
GROUP ACNT PRMCEB PRMMBX PSWAPM ALTPRI SETPRV TMPMBX WORLD
OPER EXQUOTA NETMBX VOLPRO PHY_IO BUGCHK PRMGBL SYSGBL MOUNT
PFNMAP SHMEM SYSPRV BYPASS SYSLCK SHARE GRPPRV READALL
SECURITY
Identifier Value Attributes
ORA_DBA %X80010015
PSI$GETOUT %X8001001C
INTMAX_2 %X80010023
jan
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 677.1 | EPS::VANDENHEUVEL | Hein | Tue Jun 03 1997 09:34 | 15 | |
Jan,
ENQLM and BYTLM appear both to be too low for any serious work.
You might be just on the edge when running interactivly (mailbox less?)
Use ANAL/SYS or one of the quota command files that float around to
display the remaining enqlm and bytlm (and the rest while you are
at it) for an interactive session (after executing a command or two)
to figure out what is low. [$write sys$output f$getjpi(pid,"ENQLM")...]
Groetjes,
Hein.
| |||||
| 677.2 | BSS::JILSON | WFH in the Chemung River Valley | Tue Jun 03 1997 13:12 | 5 | |
I would agree on BYTLM. SYSMAN creates a subprocess for the work and BYTLM is pooled between all processes in the job tree. Increase BYTLM to say 1000000 and try that. Jilly | |||||