- 博客(61)
- 资源 (24)
- 收藏
- 关注
原创 OCM实验目录
OCM实验目录 环境准备 http://blog.csdn.net/rlhua/article/details/21370431session0 http://blog.csdn.net/rlhua/article/details/21475621session11.Database
2014-03-29 10:24:43 10512 7
原创 oracle分享相关链接
OCP 051,051,053 vce文件分享(别人制作的,感谢): http://pan.baidu.com/s/1dDxLdvj
2014-03-08 19:19:21 4332 3
翻译 Oracle Data Guard_ 主库添加或删除在线重做日志文件
8.3.5 Adding or Dropping Online Redo Log Files8.3.5 添加或删除现在重做日志文件Changing the size and number of the online redo log files is sometimes done to tune the database. You can add or drop onlin
2014-03-30 20:43:11 2890
翻译 Oracle Data Guard_ 主库重命名数据文件
8.3.4 Renaming a Datafile in the Primary Database8.3.4 在主库中重命令数据文件(即手动在备库修改相等的变化)When you rename one or more datafiles in the primary database, the change is not propagated to the standby database
2014-03-30 20:13:21 1777
翻译 Oracle Data Guard_ 主备库传输表空间
8.3.3 Using Transportable Tablespaces with a Physical Standby Database8.3.3 物理备库使用传输表空间You can use the Oracle transportable tablespaces feature to move a subset of an Oracle database and plu
2014-03-30 20:12:14 1671
翻译 Oracle Data Guard_ 主库删除表空间
8.3.2 Dropping Tablespaces and Deleting Datafiles8.3.2 删除表空间和删除数据文件When you delete one or more datafiles or drop one or more tablespaces in the primary database, you also need to delete the
2014-03-29 22:24:25 2004
翻译 Oracle Data Guard_ 主库添加数据文件或创建表空间
8.3 Managing Primary Database Events That Affect the Standby Database8.3 管理主库能影响备库的事件To prevent possible problems, you must be aware of events on the primary database that affect a standby dat
2014-03-29 21:05:48 3978
翻译 Oracle Data Guard_ 备库以只读或读写方式打开访问
8.2 Opening a Standby Database for Read-Only or Read/Write Access8.2以只读或者可读写方式打开备库来访问When a standby database is open for read-only access, users can query the standby database but cannot update it
2014-03-29 15:04:38 7498
翻译 Oracle Data Guard_启动和关闭物理备库
启动时应用重做日志,关闭时取消重做日志: 8.1 Starting Up and Shutting Down a Physical Standby DatabaseThis section describes the SQL*Plus statements used to start up and shut down a physical standby database.
2014-03-29 12:34:48 6420
原创 EXP-00091和IMP-00010解决办法
在session4的4小题需要用到SH.COUNTRIES表,而手工建库时,这个SH用户没有这个表,就想着将别处的这个表拷贝过来。原来导出表的库:database ORACLE_SID=TEST0221 版本: 11.2.0.4需要导进的库:database ORACLE_SID=PROD 版本:10.2.0.1因为字符集的问题,出现了EXP-00091的错误因为数据库版
2014-03-27 15:56:05 12898 1
原创 OCM_Session4_3_Oracle_Loader External Tables
3. Oracle_Loader External Tables 3.1 In the scripts directory, you will find prod_master.dat and prod_master.ctl. Using the information found in these files, create an external table names PROD_MASTER
2014-03-27 12:55:17 3676
原创 OCM_Session6_3_Manage Instance Memory Structures
3. Manage Instance Memory Structures 3.1 Create a view owned by user SYS that lists the packages,procedures,triggers and functions that are in memory and occupy more than 50KB. The view should
2014-03-25 15:30:04 2033
原创 OCM_Session6_1_Instance Configuration
1. Instance Configuration 1.1 Configure your database to record checkpoints in the alert.log file. 1.2 Ensure all user trace files are placed in the USER_DUMP_DEST location.实例配置:1.配置数据库记录检
2014-03-25 15:29:13 2126
原创 OCM_Session8_3_Role Transitions Involving Physical Standby Databases
在上一章节已经测试过物理备库是否在应用归档日志,在这一章节中再次验证主库创建的表空间是否应用到备库。1.首先创建一个表空间。SYS@PROD>create tablespace swtich_tbs datafile '/u01/app/oracle/oradata/PROD/Disk1/swtich_tbs01.dbf' size 10m;Tabl
2014-03-25 13:45:52 2044 1
原创 OCM_Session8_2_Step-by-Step Instructions for Creating a Physical Standby Database
2.Step-by-Step Instructions for Creating a Physical Standby Database准备工作:创建转储目录[oracle@ocm2 dbs]$ mkdir -p /u01/app/oracle/admin/PRODSTD/adump[oracle@ocm2 dbs]$ mkdir -p /u01/app
2014-03-25 11:45:31 2438
原创 OCM_Session8_1_Preparing the Primary Database for Standby Database Creation
要求部署物理standby并进行主备切换测试官方文档:Data Guard Concepts and Administration -> 3 Creating a physical Standby Database 和 7 Role Transitions 注意事项:(1)建议手工配置DG,手工配置和GC配置不可交叉(2)不使用real-time (实时)方式启动自动恢复,采用性能
2014-03-25 11:44:04 2345
原创 OCM_Session7_0_DBCA删除RAC数据库实例
DBCA 删除RAC数据库实例适用于使用DBCA安装RAC数据库过程中,中间节点断开的现象。在我使用DBCA安装RAC数据库时,在90%时,rac1节点死机,故只能使用DBCA删除后再重建。官方文档参考:http://docs.oracle.com/cd/B19306_01/install.102/b14205/dbcacrea.htm#RISOL2405
2014-03-23 21:14:04 2308
原创 OCM_Session7_13_database 实例安装和ASM 实例安装
十三、 database 实例安装和ASM 实例安装使用oracle用户,在rac1和rac2上都可以使用dbca前提(1)启动集群进程 ons gsd vip (2)启动两个节点监听listener (3)vip进程运行在各自的节点上1.选择“Oracle Real Application Cluster database”RAC方式创建数
2014-03-23 21:13:13 2093
原创 OCM_Session7_12_安装listener监听
十二、安装listener监听使用oracle用户,在rac1和rac2上都可以起netca1.打开网络配置界面,选择“Cluster configuration”集群配置方案,点击“Next”,如果你的是单实例就选择“single node configuration”2.选中两个节点“Select all nodes”,点击“Next”
2014-03-23 19:57:38 1913
原创 OCM_Session7_11_安装oracle软件
十一、安装oracle软件[oracle@rac1 database]$ pwd/stage/database/Disk1/database[oracle@rac1 database]$ lltotal 28drwxr-xr-x 9 oracle oinstall 4096 Jul 3 2005 docdrwxr-xr-x 5 oracle oinstall
2014-03-23 19:44:26 1839
原创 OCM_Session7_10_安装clusterware
十、安装clusterware开始安装,我是使用xmanager 4安装的,我的本机ip为192.168.1.103[root@rac1 ~]# xhost+-bash: xhost+: command not found[root@rac1 ~]# export DISPLAY=192.168.1.103:0.0[root@rac1 ~]# su - or
2014-03-23 16:59:48 2556
原创 OCM_Session7_9_安装clusterware前检查配置信息,以及安装缺少的包
九、安装clusterware前检查配置信息,以及安装缺少的包准备工作:Clustware 安装文件路径 /stage/clustware/Disk1/数据库文件路径/stage/database/Disk1/ [root@rac1 ~]# mkdir -p /stage/clustware/Disk1[root@rac
2014-03-23 10:38:27 2003
原创 OCM_Session7_8_分区,并使用udev来配置裸设备
八,分区,并使用udev来配置裸设备。接下来启动,然后分区:这里在每个磁盘上分别创建1个分区,且把磁盘所有空间都用于这1个主分区。对共享磁盘分区时,只需要以root用户在任意节点上创建即可,不需要在每个节点上执行!-----------------------------------------------------------------------------
2014-03-23 10:27:14 2043
原创 OCM_Session7_7_VBOX配置共享存储
七,添加共享磁盘 1.选中需要设置的虚拟电脑,点击'设置'。 2.在设置界面点击'存储',选择孔志伟:SATA,添加虚拟硬盘。 3.选择创建新的虚拟盘。 4.虚拟硬盘文件类型,默认VDI。 5.存储在硬盘上,选择'固定大小'。 6.文件位置,名称和大小,点击创建。这里重复3~6,创建4个
2014-03-23 10:12:44 1917 1
原创 OCM_Session7_6_配置oracle用户ssh对等性
六、配置oracle用户ssh对等性这个OCM要求配置。参考官方文档:http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htm2.4.7.1 Configuring SSH on Cluster Member NodesTo configure SSH, you
2014-03-23 09:37:20 2467
原创 OCM_Session7_5_修改/etc/security/limits.conf和 /etc/pam.d/login和/etc/profile
五、修改/etc/security/limits.conf和 /etc/pam.d/login和/etc/profile 这个在OCM环境已经配置好。参考官方文档:http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htmTo increase the shell limits:
2014-03-23 09:29:08 4750
原创 OCM_Session7_4_修改内核配置文件/etc/sysctl.conf
四、修改内核配置文件--两个节点都要执行 这个在OCM环境已经配置好参考官方文档:http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htmTo view the current value specified for these kernel parameters, and t
2014-03-23 09:26:10 3275
原创 OCM_Session7_3_修改 oracle 用户的初始化参数文件,建路径
三、修改 oracle 用户的初始化参数文件 在OCM环境中,我们也只需要在查看:cat /home/oracle/.bash_profile官方参考:http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htm2.5 Configuring the oracle User
2014-03-23 09:19:25 2172
原创 OCM_Session7_2_创建组,用户,设置用户密码
二、创建组,用户,设置用户密码,在OCM环境中,用户和用户组也已经配置好。我们只需要查看 id oracle。参考官方文档:http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htm2.4.6 Creating Identical Users and Groups on Other
2014-03-23 09:12:01 1840 1
原创 OCM_Session7_1_配置/etc/hosts
一、配置/etc/hosts在安装rac第一步是配置/etc/hosts文件,在OCM环境中已经配置好,我们只需要查看:cat /etc/hosts参考官方文档:http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htm2.7.1 IP Address RequirementsBefore star
2014-03-23 09:07:16 1908
原创 OCM_Session7_0_准备工作,确定hostname和ip地址
当在一个os上安装racdb时,第一步需要确定节点的IP地址。我这里的ip地址如下:#node1192.168.1.151 rac1.localdomain rac1192.168.1.152 rac1-vip.localdomain rac1-vip172.168.1.14 rac1-priv.localdomain rac1-priv
2014-03-23 09:02:34 1879
原创 OCM_Session7_0_CRS-0223
在用DBCA删除后,重建创建racdb数据库,到存储选项这里,出现如下错误: 查看各服务状态[oracle@rac1 ~]$ crs_stat -tName Type Target State Host ----------------------------------------------
2014-03-23 08:40:08 1711
原创 OCM_Session7_0_which srvctl
在使用srvctl出现以下错误: [oracle@rac1 ~]$ srvctl/u01/app/oracle/product/10.2.0/db_1/jdk/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file
2014-03-23 08:32:25 1993
原创 OCM_Session3_3_Flashback Database
3. Flashback Database 3.1 Turn on Flashback Database 3.1.1 Configure a flash recovery area of 4GB 3.1.2 Put your flash recovery area in /home/oracle/flash (you may have to create this diretory) 3.2
2014-03-21 14:32:58 2322
原创 OCM_Session3_2_Using RMAN
2. Using RMAN 2.1 Configure RMAN options for the PROD database 2.1.1 Turn backup optimization on 2.1.2 Set your default channel to write to /home/oracle/backup (you may have to create this dir
2014-03-21 14:31:23 2419
原创 OCM_Session3_1_Create an RMAN Catalog
1. Create an RMAN Catalog 1.1 Create a tablespace in your EMREP database called RC_DATA. 1.1.1 Make it locally managed. 1.1.2 Create it with one datafile of size 100MB.参考联机文档:Backup and Reco
2014-03-21 14:29:46 2828
翻译 Oracle11G RMAN_1_Introduction to Backup and Recovery
1 Introduction to Backup and Recovery备份和恢复的介绍This chapter explains Oracle Database backup and recovery and summarizes the Oracle solutions. This chapter contains the following topics:本章解释了Oracle
2014-03-21 09:15:23 3404 2
原创 OCM_Session1_9_Database Backup and Availability
9. Database Backup and Availability 9.1 Backup the database to prepare for complete recovery under all circumstances. 9.2 Open the database. 9.1 Backup the database to prepare for comp
2014-03-19 16:24:18 2320
原创 OCM_Session1_8_Schema Statistics and Parameter File Configuration
8. Schema Statistics and Parameter File Configuration 8.1 Compute statistics for the various schemas in the database as necessary for use with cost based optimization. 8.2 Investigate the paramete
2014-03-19 16:21:33 2663
原创 OCM_Session1_7_Schema Creation
7. Schema Creation 7.1 As user SYS, run the script /home/oracle/scripts/create_bishhr.sql Ignore any errors concerning OE. But do not ignore any other errors.7. Schema Creation
2014-03-19 16:16:50 2454
Oracle 10g 10.2.0.1 在Oracle Linux 5.4 32Bit RAC安装手册(一抹曦阳)
2014-07-31
Oracle 12C 在 Oracle Linux 6.5 64Bit 安装手册
2014-07-29
OCP11G-1Z0-053
2013-11-14
OCP11G-1Z0-052
2013-11-14
OCP11G-1Z0-051
2013-11-14
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人