ORACLE 10g下载地址
oracle 下载还需要用户名我自己注册了个方便大家使用下载
user:1603869780@qq.com
pass:qwe123QWE
密码是这个 一般不会动了 大家也不用帮我找回密码了
每次都改 也很麻烦的
如果有需要可以帮我浏览下 右侧的需要的信息
用迅雷下就不用密码了 下载也不会卡到最后 还可以续传
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (x64)
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_database.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_client.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_clusterware.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_clusterware_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux_x86_64.cpio.gz
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for AIX5L
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_database.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_client.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_cluster.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_gateways.cpio.gz
Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86)
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_database_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_client_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_clusterware_solx86.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (x86-64)
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_database_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_client_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_clusterware_solx86_64.zip
Oracle OCM 课程
Oracle Database 11g: SQL Tuning Workshop
Oracle Database 11g: Security
Enterprise DBA Part 1B: Backup and Recovery
Oracle Database 11g: Data Guard Administration
Oracle Database 11g: RAC for Administrators
Oracle Database 11g: Implement Streams
Oracle OCM 学习目标
◇熟练掌握在Unix/Linux系统上Oracle大型数据库的日常维护、管理、规划、设计、调优、开发等综合技能；
◇成为企业大型数据中心核心管理人员及企业项目管理人员；
◇最终获得OCM大师认证证书。
Oracle OCM课程大纲：
OCM学习课时：理论288小时 +开放实验室（无限制）
>>课程一：Oracle 数据库集群 RAC
>>课程二：Oracle 网格计算与控制Grid Control
>>课程三：Oracle性能优化Performance Tuning
>>课程四：Oracle数据仓库术 Data Warehouse
>>课程五：Oracle备份还原Backup and Recovery
>>课程六：Oracle 关键业务容灾 Data Guard
>>课程七：Program with PL/SQL
>>课程八：OCM Exam Preparation Workshop
1、数据库设计实训：通过主流ER图设计工具实现四阶段的数据库设计。
2、优化实训：通过RDA、AWR、Statspack等工具诊断数据库的性能瓶颈通过实例调优和SQL调优解决数据。
3、库的性能问题：并有能力提交巡检报告、健康检查报告、优化报告的关键项目文档。
4、网格实训：在多节点的平台上实现复杂的大型企业级数据库系统，并有能力处理复杂的技术问题。
如RAC+Grid Control网格数据库的安装配置,Data Guard的2级灾备时网络带宽瓶颈和切换问题，goldengate实现数据库同步问题。
http://www.oracle.com/pls/db102/portal．all books，Orace 10．2官方文档，最权威的文档，适合系统学习。
http://www.oracle.com/technology/index.html，OTN，资料新、覆盖面广，尤其适合快速入门、图文并茂；缺点是分类方式不太适合中国用户的习惯。
https://metalink.oracle.com, Metalink，各种深度的文档一应俱全，也是所有补丁的发源地，不过用户需要申请账号。
http://www.ippub.net, 这是很多Oracle DBA开始成长的地方。
http://www.eygle.com, 这是Eygle的个人网站，Eygle(Oracle ACE Director)是国内Oracle数据库领域中的知名资深人士。
http://asktom.oracle.com，大名鼎鼎的AskTom。
http://www.databasejournal.com和http://www.oracle-base.com这两个站点程度类似，经常会有针对某专题的系列文章，适合初学者。
一、术语说明
db机：是指在section 0阶段进行手动建库的机器。
gridcontrol机：是指在section 2阶段进行grid control软件安装的机器。
RAC机：是指在section 7阶段使用VNC连接到远程服务器安装RAC时使用的远程机器。
奇数机(ODD)与偶数机(EVEN)：在真正考试时，每个人面前会有两台机器，一台称为奇数机(ODD)，一台称为偶数机(EVEN)，要你在ODD机器桑做什么或者在EVEN机器上做什么，偶数还是奇数是依靠机器的hostname最后一位或者两位数字来定的，通常会要求你在奇数机上创建数据库，在偶数机上安装Grid Control的OMS。偶数机上是没有Oracle软件的，因此OMS需要的Repository这个数据库也需要创建在奇数机上，再加上之后第二天会要求创建的Standby实例，总共会有三个实例运行在奇数机上。
二、考试安排及要求
（一）时间安排
第一天：
section 0:创建一个数据库 45分钟
section 1:数据库和网络配置 120分钟
section 2:Gridcontrol安装配置 120分钟
section 3:数据库备份恢复 60分钟
section 4:数据仓库管理 90分钟
第二天：
section 5:数据库管理 120分钟
section 6:数据库性能管理 120分钟
section 7:部署Oracle RAC数据库 105分钟
section 8:部署Dataguard数据库 60分钟
（二）注意事项
三、考试题库及讲解
（一）section 0:创建数据库(即手动建库)【在db机操作】
1、手动建库
1）确定实例名
export ORACLE_SID=test
2）建立密码文件
orapwd file=orapwtest password=oracle
3）建立pfile
cat init.ora|grep -v ^ #|grep -v ^ $ >inittest.ora
在inittest.ora里只包含如下初始参数：
db_name=test
processes=150
controlfiles=(xxxxxx,xxxxxx)
db_block_size=8192
log_buffer=50000000
sga_target=300m
undo_management=auto
undo_tablespace=undotbs
background_dump_dest
core_dump_dest
user_dump_dest
4）建立spfile并启动实例
sql>sqlplus / as sysdba
sql>create spfile from pfile
sql>startup nomount
5）手工创建数据库（使用create database命令）
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY z6r58
USER SYSTEM IDENTIFIED BY y1tz5p
LOGFILE GROUP 1('/u01/oracle/oradata/mynewdb/redo01.log') SIZE 100M,
GROUP 2('/u01/oracle/oradata/mynewdb/redo02.log') SIZE 100M,
GROUP 3('/u01/oracle/oradata/mynewdb/redo02.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1(在考试时去掉这条语句)
TEMPFILE '/u01/oracle/oradata/mynewdb/temp01.dbf' SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/oracle/oradata/mynewdb/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
6）运行相关脚本
CONNECT SYS/password AS SYSDBA
@/u01/oracle/rdbms/admin/catalog.sql
@/u01/oracle/rdbms/admin/catproc.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catoctk.sql
@?rdbms/admin/owminst.pld
connect system/oracle
@?/sqlplus/admin/pupbld.sql
2、section 0阶段考试需要注意的具体事项
1）按题目要求设置“字符集”
2）有5块磁盘，建库建在指定位置，一般都是建在文件系统上
3）考试的结果是美国那边直接用脚本连到你的服务器上，通过数据字典抓取结果，然后判断你哪些错了，所以，一定要保证在最后的时候，数据库是OPEN的，监考老师说还有5分钟结束考试的时候，不要再做什么其他操作了。如果之前你创建完数据库，想要shutdown之后冷备一下的话，请估算好时间。我听到的案例是冷备刚完成，数据库还未startup，结果美国那边开始抓取考试结果，因为无法连接数据库，因此第一天上午的section得了零分。
4）为了节省时间，如果题目里没有明确要求备份，可以先不备份。
5）如果有时间，用root用户修改/etc/hosts文件，使该文件里包括2个节点的主机名和相应的ip地址。
3、参考的联机文档
1）administrator's guide->2）creating a oracle database->3）Manually Creating an Oracle Database
（二）section 1:数据库和网络的配置【在db机操作】
1、数据库配置（管理表空间）
有如下考题需要注意：
一、Create a temporary tablespace group that contains two temporary tablespaces to support batch process about creation of large indexes, and analyzing tables. Use the following specifiction:
1、Temporary tablespace group named TEMP_GRP containing temporary tablespaces TEMP1 and TEMP2.
2、Make TEMP_GRP the default temporary tablespace for all new users;
Answer:
create temporary tablespace temp1 tempfile 'u01/app/oradata/temp1.dbf' size 50m tablespace group TEMP_GRP;
create temporary tablespace temp2 tempfile 'u01/app/oradata/temp2.dbf' size 50m tablespace group TEMP_GRP;
alter database default temporary tablespace TEMP_GRP;
select * from database_properties;
二、Create a permanent tablespace to store sample test data. Use the following specification:
1、Tablespace name of EXAMPLE
2、Initial datafile size of 400MB with the file expected to grow to 4GB
3、Initial extent size of 1MB
4、Next extent size of 1MB
Answer:
create tablespace example datafile 'xxxxxx' size 400m autoextend on maxsize 4g
extent management local uniform size 1m;
三、Create a permanent tablespace to store indexes. Use the following specification:
1、Tablespace name of INDX
2、File size of 40MB
Answer:
create tablespace indx datafile '******' size 40m;
四、Create a permanent tablespace to store data bollected from the various Oracle tools. Use the following specification:
1、Tablespace name of tools
2、File size of 48MB
3、Initial extent size of 4MB
4、Next extent size of 4MB
Answer:
create tablespace tools datafile '******' size 48m extent management local uniform size 4m;
五、Create a permanent tablespace for storing segments associated with online transaction processing with high insert rates. Due to the potential high volume of concurrent inserts, every effort should be taken to reduce contention such of the tables that will be stored in this tablespace. Use the following specification:
1、Tablespace name of OLTP
2、File size of 48MB
3、Initial extent size of 2MB
4、Next extent size of 2MB
Answer:
create tablespace oltp datafile '******' size 48m extent management local uniform size 2m segment space management auto;
六、Due to the expected high volumn of transaction, the database should have the following configuration:
1、A minumum of 5 redo log groups
2、Each redo log group should not be a single point of failure
3、File size of 100MB
4、Specify the Location such that it minimuzes contention and reduces the risk of a single point of failure case of disk drive failure.
Answer:
sql>ALTER DATABASE ADD LOGFILE
group 4 ('/u01/app/oradata/test/log4a.log', '/u01/app/oradata/test/log4b.log') size 100m,
group 5('/u01/app/oradata/test/log5a.log', '/u01/app/oradata/test/log5b.log') size 100m;
sql>alter database add logfile member '/u01/app/oradata/shuai/redo1b.log' to group 1;
注意：日志组的两个member 应该分布在2个不同的磁盘上。
七、Triplex the controlfile to minimize recovery in case of disk drive failure.
Answer:
将数据库关闭，然后拷贝控制文件到目标路径，然后改pfile中的control参数，重新生成spfile，最后启动数据库。
OCA:
STEP 1 - PASS THIS EXAM
or select one of the exams at the bottom of the page *
1Z0-051
Oracle Database 11g: SQL Fundamentals I *
STEP 2 - PASS THIS EXAM
1Z0-052
Oracle Database 11g: Administration I
OCP:
STEP 1 - PRIOR CERTIFICATION
Oracle Database 11g Administrator Certified Associate
STEP 2 - COMPLETE TRAINING
Complete one of the approved advanced courses
Oracle Database 11g: Data Warehousing Fundamentals
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2
Oracle Database: Develop PL/SQL Program Units
Oracle Database: Introduction to SQL/PLSQL Accelerated
Oracle Database: SQL and PL/SQL Fundamentals
Oracle Grid Infrastructure 11g: Manage Clusterware and ASM
1Z0-053
Oracle Database 11g: Administration II
OCM:
STEP 1 - PRIOR CERTIFICATION
Oracle Database 11g Administrator Certified Professional
STEP 2 - COMPLETE TRAINING
Complete two of the approved advanced courses
Oracle Database 11g: SQL Tuning Workshop
Oracle Database 11g: Performance Tuning DBA Release 2
Oracle Database 11g: Data Guard Administration Release 2
Oracle Database 11g: Implement Streams Release 2
Oracle Database 11g: Security Release 2
Oracle Database 11g: Advanced PL/SQL
Oracle Spatial: Essentials
Oracle Database 11g: New Features for Administrators Accelerated Release 2
Oracle Database 11g: New Features for Oracle9i DBAs
Oracle Database 11g: Backup and Recovery Workshop
Oracle Database 11g : OCM Exam Preparation Workshop
Oracle Database 11g: Administer a Data Warehouse
Oracle Database 11g: OLAP Essentials
Oracle Data Modeling and Relational Database Design
Oracle Database 11g: Data Warehousing Fundamentals
Oracle Enterprise Manager 11g: Grid Control Essentials
Oracle Database 11g: RAC Administration
STEP 3 - PASS THIS EXAM
Oracle Database 11g Certified Master Exam
STEP 4 - COMPLETE THIS FORM
Complete a Course Submission Form for each of the two required courses.You will submit two course forms.
STEP 5 - COMPLETE THIS FORM
Submit Fulfillment Kit Request (This form is submitted exactly the same as the Course Submission Form)
--------------------------------------------------------------
Oracle Database 11g: SQL Tuning Workshop Release 2
Price: CNY 2171
This Oracle Database 11g: SQL Fundamentals course teaches you about the fundamentals of SQL using Oracle Database 11g database technology. Learn essential SQL skills to write queries against single & multiple tables, manipulate data in tables & more.
Oracle Database 11g: PL/SQL Fundamentals
Price: CNY 1448
This Oracle Database 11g: PL/SQL Fundamentals training explores the basics of PL/SQL syntax and programming
constructs. Learn how to identify programming extensions that PL/SQL provides to SQL and how to write PL/SQL code to interface with the database.
Oracle Database: Program with PL/SQL
Price: CNY 7238
This Oracle Database: Program with PL/SQL training covers the creation and execution of PL/SQL blocks of
application code to integrate SQL with the programming constructs. Learn to develop stored procedures,
functions, packages & more.
Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2
Price: CNY 2895
This Oracle Grid Infrastructure 11g training course reviews components, including Oracle Automatic Storage Manager (ASM), ASM Cluster File System and Oracle Clusterware. It's based on Oracle Database 11g Release 2.
Oracle Database 11g: Performance Tuning DBA Release 2
Price: CNY 3619
This Oracle Database 11g Performance Tuning training is an advanced curriculum course. It builds on the Introduction to Performance Tuning in the Administration Workshop I and II courses, focusing on the tuning tasks expected of a DBA.
Oracle Database 11g: Complete Course
Price: CNY 14476
This Oracle Database 11g: Complete - Self-Study Course gives you a firm foundation in basic database administration, SQL and PL/SQL database reporting and programming with Oracle Database 11g Release 1. Learn how to install and maintain an Oracle instance, access data and more.
Oracle Database 11g: Ultimate Course
Price: CNY 34018
This Oracle Database 11g: Ultimate Self-Study Course bundle will give you a firm foundation in basic database administration. Explore SQL and PL/SQL database reporting and programming with Oracle Database 11g Release 1.
Oracle Database 11g：Data Guard 管理 发行版 2
Price: CNY 2895
在本课程中，学员将了解如何使用 Oracle Data Guard 来使 Oracle DB 在计划及非计划停机时间里免受损害。同时还将学习如何以备用角色使用 Oracle Data Guard 备用数据库来支持生产功能，如报告、查询和测试。
Oracle Database 11g: RAC Administration Release 2
Price: CNY 2171
In this course, students will learn about RAC database administration in the Oracle Grid Infrastructure environment.
This course is based on Oracle Database 11g Release 2.
Oracle Database 11g: Data Warehousing Fundamentals
Price: CNY 2171
This Database 11G Data Warehousing training teaches data warehousing concepts and technologies, while examining Oracle’s approach to data warehouse implementation. Review partitioning, parallel operations, materialized views and more.
