Fuller Theological Seminary May 2, 2004 Create the Oracle 9i User Account for Open VMS (system administrator task): Find your next UIC: show [100,*]/brief – this will list all UIC for the 100 group These are the quotas needed for the Oracle9i User: (It is easier to give your Oracle 9i user full sys privs as shown below) UAF> show oracle9i Username: ORACLE9I Owner: ORACLE DBA Account: UIC: [100,106] ([ORACLE9I]) CLI: DCL Tables: DCLTABLES Default: ORADISK:[ORACLE9I] LGICMD: Flags: DisForce_Pwd_Change Primary days: Mon Tue Wed Thu Fri Secondary days: Sat Sun No access restrictions Expiration: (none) Pwdminimum: 8 Login Fails: 0 Pwdlifetime: (none) Pwdchange: 15-FEB-2004 06:38 (pre-expired) Last Login: 30-APR-2004 11:41 (interactive), 3-MAY-2004 10:58 (non-interactive) Maxjobs: 0 Fillm: 4096 Bytlm: 2000000 Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0 Maxdetach: 0 BIOlm: 10240 JTquota: 32768 Prclm: 20 DIOlm: 300 WSdef: 16384 Prio: 4 ASTlm: 250 WSquo: 32768 Queprio: 4 TQElm: 200 WSextent: 65536 CPU: (none) Enqlm: 2000 Pgflquo: 2500000 Authorized Privileges: ACNT ALLSPOOL ALTPRI AUDIT BUGCHK BYPASS CMEXEC CMKRNL DIAGNOSE DOWNGRADE EXQUOTA GROUP GRPNAM GRPPRV IMPERSONATE IMPORT LOG_IO MOUNT NETMBX OPER PFNMAP PHY_IO PRMCEB PRMGBL PRMMBX PSWAPM READALL SECURITY SETPRV SHARE SHMEM SYSGBL SYSLCK SYSNAM SYSPRV TMPMBX UPGRADE VOLPRO WORLD Default Privileges: ACNT ALLSPOOL ALTPRI AUDIT BUGCHK BYPASS CMEXEC CMKRNL DIAGNOSE DOWNGRADE EXQUOTA GROUP GRPNAM GRPPRV IMPERSONATE IMPORT LOG_IO MOUNT NETMBX OPER PFNMAP PHY_IO PRMCEB PRMGBL PRMMBX PSWAPM READALL SECURITY SETPRV SHARE SHMEM SYSGBL SYSLCK SYSNAM SYSPRV TMPMBX UPGRADE VOLPRO WORLD Identifier Value Attributes ORA_AGENT_ID %X80010002 ORA_DBA %X80010004 SQLPLUS_ACCESS %X80010007 3.) Modify SYSGEN parameters for the SGA you will need (it is best to run AUTOGEN when this part if finished, but not absolutely necessary for the database to run correctly – but running AUTOGEN will improve your VMS system efficiency and performance: $MCR SYSGEN SYSGEN> SHOW PQL_* Parameter Name Current Default Min. Max. Unit Dynamic -------------- ------- ------- ------- ------- ---- ------- PQL_DASTLM 24 24 -1 -1 Ast D PQL_MASTLM 100 4 -1 -1 Ast D PQL_DBIOLM 32 32 -1 -1 I/O D PQL_MBIOLM 100 4 -1 -1 I/O D PQL_DBYTLM 65536 65536 -1 -1 Bytes D PQL_MBYTLM 750000 1024 -1 -1 Bytes D PQL_DCPULM 0 0 -1 -1 10Ms D PQL_MCPULM 0 0 -1 -1 10Ms D PQL_DDIOLM 32 32 -1 -1 I/O D PQL_MDIOLM 100 4 -1 -1 I/O D PQL_DFILLM 128 128 -1 -1 Files D PQL_MFILLM 2048 2 -1 -1 Files D PQL_DPGFLQUOTA 65536 65536 -1 -1 Pagelets D internal value 4096 4096 0 -1 Pages D PQL_MPGFLQUOTA 1500000 2048 -1 -1 Pagelets D internal value 93750 128 128 -1 Pages D PQL_DPRCLM 32 32 -1 -1 Processes D PQL_MPRCLM 10 0 -1 -1 Processes D PQL_DTQELM 16 16 -1 -1 Timers D PQL_MTQELM 100 0 -1 -1 Timers D PQL_DWSDEFAULT 12480 1024 -1 -1 Pagelets internal value 780 64 0 -1 Pages PQL_MWSDEFAULT 12480 512 -1 -1 Pagelets internal value 780 32 32 -1 Pages PQL_DWSQUOTA 24960 2048 -1 -1 Pagelets D internal value 1560 128 0 -1 Pages D PQL_MWSQUOTA 24960 1024 -1 -1 Pagelets D internal value 1560 64 64 -1 Pages D PQL_DWSEXTENT 1196032 16384 -1 -1 Pagelets D internal value 74752 1024 0 -1 Pages D PQL_MWSEXTENT 1196032 2048 -1 -1 Pagelets D internal value 74752 128 128 -1 Pages D PQL_DENQLM 128 128 -1 -1 Locks D PQL_MENQLM 8192 30 -1 -1 Locks D PQL_DJTQUOTA 4096 4096 -1 -1 Bytes D PQL_MJTQUOTA 8192 0 -1 -1 Bytes D SYSGEN> SHOW GBL* Parameter Name Current Default Min. Max. Unit Dynamic -------------- ------- ------- ------- ------- ---- ------- GBLSECTIONS 1915 250 80 65535 Sections GBLPAGES 125985357 65536 10240 -1 Pagelets D internal value 7874085 4096 640 -1 Pages D GBLPAGFIL 7864576 512 32 -1 Pages D **How to calculate SGA**