OM.indd

Size: px

Start display at page:

Download "OM.indd"

ひろみささおか
4 years ago
Views:

2 _ INDEX Platinum 10 Gold 12 Silver 14 Bronze FAQ 21 22

3 Platinum Platinum IT 保々雅世 3

4 IT Control Real Application Cluster Grid Oracle Application Server 10g CLE MASTER ORA IT ORACLE MASTER 4

5 Oracle Certifi cation Program Platinum Silver Oracle Silver Fellow Bronze Oracle Certified Databese Manager Gold Gold 8 Gold 8i Gold 9i Silver Oracle9i Database Silver Oracle Certified Databese Engineer Platinum Oracle Certified Workgroup Sever Engineer Platinum 8 Platinum 8i Platinum 9i Gold Oracle9i Database Gold Platinum Oracle9i Database Platinum Gold Oracle9i Application Server Silver Oracle9i Application Server Silver Oracle Application Server 10g Oracle Certified Databese Developer Oracle Certified Developer Oracle Certified Developer R6/6i Gold Oracle9i Forms Developer E-Developer Silver Oracle9i PL/SQL 5

6 Oracle Certification Program(OCP) ( ) 4 Bronze Silver Gold Platinum Platinum Gold Silver Bronze 3 Oracle Oracle Database10g Oracle 9i Database Oracle Application Server 10g Oracle9i Application Server PL/SQL Oracle PL/SQL Oracle Forms Developer Oracle DeveloperR6i/ Forms 6

7 Platinum Gold ( 1) ( 4) ( 7) ( 4) ( 7) OCM Platinum Oracle Datbase 10g OCP Silver OCA Bronze - ( 2) Oracle9i Database Platinum Oracle9i Database Gold Oracle9i Database Gold DBA 10g (1Z0-043J) Silver DBA 10g (1Z0-042J) Bronze SQL I (1Z0-017J) Bronze DBA 10g (1Z0-041J) OCM Platinum Oracle9i Database OCP Silver OCA Oracle9i Database Oracle Silver Fellow - ( 2) Gold OCP Oracle Application Server 10g ( 3) Silver OCA Oracle Application Server 10g Silver OCA Oracle9i Application Server Gold Oracle9i Forms Developer Silver Oracle9i PL/SQL OCP OCA Oracle9i DBA II (1Z0-032J) Oracle9i (1Z0-033J) Oracle9i DBA I (1Z0-031J) SQL (1Z0-011J) Oracle (1Z0-012J) 2 ( 5) 1 ( 6) Gold Oracle Database 10g Platinum Oracle9i Database Silver Oracle Database 10g Bronze Oracle Database 10g Oracle Silver Fellow Bronze DBA 10g 1Z0-041J Gold Oracle9i Database Silver Oracle9i Database Silver Fellow - - ( 3) ( 3) Silver Oracle Application Server 10g Silver OracleAS 10g (1Z0-311J) SQL (1Z0-011J) Oracle (1Z0-012J) Oracle9i AS (1Z0-301J) Oracle9i Forms Developer (1Z0-141J) SQL (1Z0-011J) Oracle (1Z0-012J) PL/SQL (1Z0-147J) Oracle Certified Developer OCP SQL (1Z0-011J) Oracle (1Z0-012J) PL/SQL (1Z0-101J) Oracle Developer R6i Forms I (1Z0-131J) Oracle Developer R6i Forms II (1Z0-132J) Oracle Fellow Oracle9i AS (1Z0-301J) Silver Oracle9i PL/SQL Oracle Silver Fellow PL/SQL (1Z0-147J) Oracle Silver Fellow SQL(1Z0-011J) Oracle (1Z0-012J) 3 1Oracle Certified Master (OCM) Oracle Certified Professional (OCP) Oracle Certified Associate (OCA) Platinum Oracle9i Database 6 Gold Oracle9i Database 7 Oracle7 Oracle8 Oracle8i Oracle9i Database 7

8 Oracle9i Database Platinum Oracle9i Database 4 Platinum 9i Platinum g Platinum Gold Oracle9i Database 1Z0-040J DBA10g Gold 1Z0-033J Oracle9i 1Z0-043J 1 3 Gold DBA10g 1Z0-032J 1 Oracle9i DBA 3 2 Silver Oracle9i Database 1Z0-042J Silver DBA10g 1Z0-042J Silver Silver DBA10g 1Z0-031J Oracle9i DBA ORACLE Silver Fellow 1Z0-041J Bronze DBA10g 1Z0-041J Bronze Bronze DBA10g 1Z0-011J Oracle9i SQL 1Z0-017J Bronze SQL 1Z0-012J Oracle9i Oracle9i Platinum Oracle9i Gold 3 1class Requirement2class Requirement4 8

9 _ Platinum Platinum Oracle Database cation/ TEL : _ ID ID TEL :00 18:00 Platinum _ 30 _ Platinum 7 17 Oracle University 7 17 Platinum 3 9

10 Platinum Platinum 1. 10gPlatinum Linux 2.Manual 10gPlaitnum create user,create table,create tablespace 3.Grid Control,Real Application Clusters 9iPlatinum 10gPlatinum 10g Grid Control Real Application Cluster Platinum D a y. 1 D a y Real Application Clusters 4. Enterprise Manager 10g Grid Control 4. Data Guard

11 [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] (Listener Control ) [ ] [ ] Enterprise Manager Grid Control [ ] Enterprise Manager Grid Control [ ] Enterprise Manager [ ] Enterprise Manager Grid Control [ ] Enterprise Manager [ ] Enterprise Manager [ ] [ ] [ ] [ ] Grid Control Database Control [ ] [ ] [ ] [ ] [ ] [ ] [ ] Enterprise Manager Grid Control [ ] Enterprise Manager Grid Control [ ] Grid Control [ ] [ ] Recovery Manager [ ] Recovery Manager [ ] Recovery Manager [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] Undo [ ] [ ] [ ] SQL*Loader [ ] [ ] ( ) [ ] [ ] ( ) [ ] [ ] [ ] LOB [ ] [ ] [ ] Data Warehouse [ ] (Data Loader Data Pump ) [ ] Data Pump [ ] Data Pump [ ] [ ] [ ] [ ] [ ] Statspack [ ] [ ] [ ] ADDM [ ] [ ] [ ] SGA [ ] SQL [ ] work area size PGA [ ] PGA Advisor [ ] ( [ ] [ ] [ ] [ ] ( ) [ ] SQL Tuning Advisor [ ] SQL Access Advisor [ ] Optimizer [ ] [ ] SQL Real Application Clusters [ ] Oracle Clusterware [ ] [ ] ASM [ ] ASM [ ] ASM [ ] ASM [ ] [ ] Data Guard [ ] Data Guard Manager DGMGRL [ ] [ ] [ ] [ ] [ ] "read-only" [ ] [ ] Data Gurad 11

12 Gold Gold Oracle Enterprise Manager _ Gold DBA10g [ ] [ ] [ ] [ ] / [ ] NLS Oracle Listener [ ] [ ] Recovery Manager [ ] Recovery Manager [ ] Recovery Manager [ ] Recovery Manager [ ] BACKUP [ ] [ ] LIST REPORT [ ] [ ] Enterprise Manager [ ] [ ] [ ] [ ] REDO [ ] [ ] [ ] [ ] [ ] [ ] Enterprise Manager [ ] Recovery Manager [ ] SQL [ ] RESETLOGS [ ] [ ] [ ] [ ] Enterprise Manager [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] ANALYZE DBVERIFY [ ] DBMS_REPAIR [ ] DB_BLOCK_CHECKING [ ] Recovery Manager [ ] [ ] SQL [ ] UNDO [ ] REDO [ ] [ ] [ ] [ ] [ ] [ ] [ ] ASM [ ] ASM SQL [ ] ASM [ ] ASM [ ] ASM [ ] [ ] SGA [ ] PGA [ ] Resource Manager [ ] [ ] [ ] [ ] [ ] [ ] [ ] 12

13 1 2 A ALTER SESSION TIME_ZONE B NLS_LANG C ORA_SDTZ D ALTER DATABASE TIME_ZONE 4 PGA A PGA_TARGET B SGA_TARGET C PGA_AGGREGATE_TARGET D SGA_AGGREGATE_TARGET A,C ALTER SESION TIME_ZONE ORA_SDTZ C PGA_AGGREGATE_TARGET 0 PGA PGA 2 A DB_RECOVERY_FILE_DEST B DB_CREATE_FILE_DEST C DB_RECOVERY_FILE_RETENTION_TARGET D DB_RECOVERY_FILE_DEST_SIZE A,D DB_RECOVERY_FILE_DEST DB_RECOVERY_FILE_DEST_SIZE DB_CREATE_FILE_DEST Oracle Managed Files OMF DB_RECOVERY_FILE_RETENTION_TARGET 5 Oracle Enterprise Manager A SQL Tuning B C D SQL Tuning SQL Access D SQL SQL Tuning SQL Access SQL Tuning SQL B* SQL SQL SQL Access SQL 3 A B C D 6 RESETLOGS REDO A %r B %s C %d D %t B Oracle Database A RESETLOGS RESETLOGS %r REDO RESETLOGS_ID %t %s %d 13

14 Silver Silver Oracle Oracle Enterprise Manager 10g PL/SQL UNDO Oracle Oracle Enterprise Manager 10g _ Silver DBA10g Oracle [ ] Oracle [ ] Oracle [ ] Oracle [ ] [ ] DBCA [ ] [ ] SQL*Plus isql*plus [ ] [ ] Enterprise Manager Database Control [ ] Oracle Listener [ ] Oracle [ ] Oracle [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] Data Pump [ ] SQL*Loader PL/SQL [ ] [ ] PL/SQL [ ] [ ] [ ] [ ] Database Control [ ] Database Control Oracle Net [ ] Database Control [ ] [ ] Oracle Net Manager [ ] [ ] [ ] [ ] [ ] [ ] [ ] Automatic Database Diagnostic Monitor ADDM [ ] Automatic Workload Repository UNDO [ ] UNDO [ ] UNDO [ ] UNDO [ ] UNDO [ ] [ ] [ ] [ ] REDO [ ] ARCHIVELOG [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] REDO [ ] [ ] 14

15 1 Data Pump A Data Pump B Data Pump C EXP_FULL_DATABASE D RESOURCE A,C Data Pump EXP_FULL_DATABASE RESOURCE A B C D AUTOEXTEND D AUTOEXTEND 3 Oracle Universal Installer 1 A B C Oracle D C Oracle Universal Installer) 4 A B C D A 5 DML A INSERT B ALTER C ROLLBACK D SAVEPOINT C,D INSERT DML ALTER DDL 6 UNDO A UNDO_TABLESPACE B UNDO_RETENTION C UNDO_MANAGEMENT D UNDO_GUARANTEE B UNDO_TABLESPACE UNDO UNDO_MANAGEMENT UNDO UNDO_GUARANTEE 15

16 Bronze Bronze SQL Oracle Enterprise Manager 10g SQL*Plus isql*plus SQL _ Bronze DBA10g [ ] SQL [ ] Oracle DBA [ ] Oracle [ ] Oracle [ ] Oracle Enterprise Manager Database Control SQL*Plus [ ] Enterprise Manager dbconsole process [ ] Enterprise Manager Database Control [ ] Enterprise Manager Database Control [ ] Enterprise Manager [ ] SQL*Plus isql*plus [ ] [ ] Enterprise Manager Net Services Administration [ ] listener control [ ] Oracle Oracle [ ] Oracle [ ] Oracle [ ] Oracle [ ] Oracle [ ] Oracle [ ] [ ] UNDO [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] Enterprise Manager [ ] [ ] [ ] [ ] fl ashback drop fl ashback table [ ] Oracle [ ] _ Bronze SQL SQL Select [ ] SQL SELECT [ ] SELECT [ ] SQL isql*plus(sql*plus) [ ] [ ] [ ] SQL [ ] SELECT [ ] [ ] SELECT [ ] [ ] [ ] [ ] [ ] GROUP BY [ ] HAVING [ ] [ ] [ ] / [ ] (DML) [ ] (DML) [ ] [ ] [ ] 16

18 Platinum (CTC) & DB&Middleware _ Paltinum10g OracleRAC Platinum Oracle Database Platinum _ Platinum10g Gold NTT IT _ Platinum 8iPlatinum _ 10gGold 8i 9i 8i _ _ 18

19 Silver BP _ _ Oracle Master10g Bronze _ Bronze SQL Bronze DBA10g SQL _ Java _ IT _ _ 10g SQL SQL Oracle 19

20 Silver OCA Gold OCP Platinum OCM OCM OCM OCM / Platinum Platinum Club 20

21 FAQ _ Platinum _ Platinum Platinum Oracle9i Database 231,000 15,750 _ Platinum Platinum Oracle Database cation/ _ Web Step1 : : ID _ TEL : Platinum ID _ OAIWDP (1 Class/ 2 Class)? _ ID Web _ ORACLE _ (1 Class/ 2 Class) Oracle University

22 ?? e Q&A 4 80% 300 ILT Q&A Q&A Oracle Database g g i i i g Oracle E-Business Suite 11i 22

24 Learn Oracle From Oracle.

untitled

untitled Oracle Direct Seminar !?Oracle Database 11g Agenda Oracle Database Enterprise Manager Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000