Oracle 11gr2 deinstall卸载oracle和grid
在10g中要卸载CRS是件非常繁琐的事。到了11g,oracle提供了卸载工具deinstall,用这个工具可以卸载的非常干净。这个工具默认放在oracle用户下的$ORACLE_HOME/deinstall/deinstall,grid用户下的$ORACLE_HOME/deinstall/deinstall 。google了下,发现只需要执行这个工具一次就可以了。但是在自己的实际测试当中分别or...
Complete Checklist for Upgrading 12c Release 2 (12.2) using DBUA
(文档 ID 2189854.1)PurposeDetails Upgrade Path / Compatibility Matrix for 12.2 Oracle Database. Requirements and Recommendations for Target database&nb...
RAC Certification Matrix for UNIX
Oracle RAC Technologies Certification Matrix for UNIX Platforms Please consult your hardware and software vendors as not all vendors may choose to support their hardware or software in every possible cluster combinationFor RAC database and SAP certification information...
Exadata Flash Cache 简介(二)
转:https://blogs.oracle.com/ExadataCN/entry/exadata_flash_cache_%E7%AE%80%E4%BB%8B_%E4%BA%8C在前一篇博客里,我们介绍了Exadata Flash Cache card(智能闪存卡)的基本概念和工作方式,在这篇文章当中,我们会从介绍如何在Exadata上管理和维护智能闪存卡。 由于智能闪存卡在Exadata上可以作为 Flash C...
Exadata Smart Flash Cache 简介(一)
转:https://blogs.oracle.com/ExadataCN/entry/exadata_smart_flash_cache_%E7%AE%80%E4%BB%8BExadata 作为能够提供高性能和高可用性的数据库一体机,既可以满足OLAP类型的应用,可也以满足OLTP类型的应用。对于后一种类型的应用,Smart Flash Cache(以下简称智能闪存)无疑为提高OLTP应用的性能提供了重要的保证。...
Oracle ASM hidden parameters
SQL Language
Oracle ASM Filter Driver (ASMFD)
Oracle ASM Filter Driver (ASMFD) – New Features for Oracle ASM 12.1.0.2转载: http://www.oracle.com/technetwork/cn/articles/database/asmfd-2398572-zhs.html什么是 Oracle ASM Filter Driver (ASMFD)?简单地说,这是一个可以取代 ASMLIB 和 udev 设置的新功能,并且还增加了 I/O Filter 功能...
RAC一个节点OHASD启动不了waiting for init.ohasd to be started
Cluster failed to start due to problem with socket pipe npohasd (文档 ID 1612325.1) 转到底部 APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform....
RAC一个节点OHASD启动不了waiting for init.ohasd to be started
Cluster failed to start due to problem with socket pipe npohasd (文档 ID 1612325.1)转到底部APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform....
Oracle DG/ADG上CPU/PSU补丁安装
Oracle DG/ADG上CPU/PSU补丁安装
Oracle DataGuard切换步骤
ADG或者DG的切换步骤:<br /><br />1. 可以切换的情况,主库查询<br />SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;<br />SWITCHOVER_STATUS<br />--------------------<br />TO STANDBY<br /><br /><br />2.如果主库是上面的状态,将主库切换至备用模式<br />SQL> alter database commit to switchove...
Oracle ADG实施步骤
主库<br />IP地址:192.168.1.100<br />操作系统版本:rhel6 64bit<br />数据库版本:11.2.0.4 64bit<br />数据库sid名:orcl<br />数据库名:orcl<br />数据库db_unique_name:orcl<br /><br /><br />备库1 物理备库 (只安装oracle数据库软件,无需建库)<br />IP地址:192.168.1.101<br />操作系统版本:r...
Oracle数据库对GCC的安装顺序
glibc-common-2.12-1.80.el6.x86_64.rpm<br />kernel-headers-2.6.32-279.el6.x86_64.rpm<br />libgcc-4.4.6-4.el6.x86_64.rpm<br />glibc-2.12-1.80.el6.x86_64.rpm<br />libgomp-4.4.6-4.el6.x86_64.rpm<br />nscd-2.12-1.80.el6.x86_64.rpm<br />glibc-headers-2.12-1.80.el6.x86_64.rpm<br />glibc-devel-2.12-1...
Oracle产品考试认证列表
Oracle产品考试认证列表http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=651#2
Rman增量备份 level 1和2的区别
RMAN备份全为全备和增量备份增量备份:分为0 1 2级ORACLE官方解释: A level 1 incremental backup can be either of the following types:Adifferential backup, which backs up all blocks changed after the most recentincremental backup at level 1 or 0A cumulative backup, which backs up all...