Oracle Block Checksum 引入一段文档对于checksum的说明 A number calculated by the database from all the bytes stored in a data or redo block. If the DB_BLOCK_CHECKSUM initialization parameter is enabled, then the database calculates t 2018-10-10 Oracle #bbed #Internal
Pipelined Table Functions TABLE函数table function是一个用户自定义的PL/SQL函数,它能返回一个结果集(关联数组、嵌套表),你能像查询普通表一样查询它,通过SELECT语句里的TABLE表达式 1SELECT * FROM TABLE(table_function_name(parameter_list)) table函数能将行的集合作为入参,也就是说它的入参可以是嵌套表、数组或者游标等,因 2018-10-04 PL/SQL
11gR2 Clusterware and Grid Home – What You Need to Know 这篇文章详细的介绍了11g clusterware整体结构,记录一下 DETAILS 11gR2 Clusterware Key Facts 11gR2 Clusterware is required to be up and running prior to installing a 11gR2 Real Application Clusters database. The GRID home 2018-09-27 Oracle #cluster
12cR2 使用 opatchauto 安装 GI PSU 测试环境: oracle 12.2.0.1 rac 2 nodes 环境配置: type homepath owner version shared GI /u01/app/12.2.0/grid grid 12.2.0.1 no DB1 /u01/app/oracle/product/ 2018-09-26 Oracle #12c #Patch
12c new features: OPatch Automation Tool – opatchauto 从12c开始,在集群GRID/RAC环境下,通过root用户使用opatchauto命令安装patch,11g 是opatch auto opatchauto能同时对GI集群打补丁,包括grid目录和db目录,能很简单的对单机或rac进行补丁操作。 支持的平台 Oracle Solaris on x86-64 (64-bit) Linux x86-64 Oracle Solaris on 2018-09-24 12c新特性
Oracle Cluster Time Synchronization Service (CTSS) 以前我安装rac的同步都是用的ntp,后来oracle引入ctss,以下为官方介绍 The Cluster Time Synchronization Service (CTSS) is installed as part of Oracle Clusterware. By default the CTSS runs in observer mode if it detects a time sy 2018-09-23 Oracle #cluster
OEL7上配置dns服务 搭建rac的时候如果选择多个scan ip 则需要考虑配置dns server,多个虚拟机也可以考虑作为公用的dns服务器 安装相关packages12345678910111213[root@xb ~]# yum install bind* -yLoaded plugins: refresh-packagekitSetting up Install ProcessResolving Depend 2018-09-22 Linux #dns
在vmware linux 7.5安装oracle 12c rac 作为测试目的安装,环境如下: OS: OEL 7.5 64-bit (12c 已经不支持32位系统) db verions: 12.2 node: 2 (rac1.oracle.com,rac2.oracle.com) IP规划:12345678910192.0.2.11 rac1 rac1.oracle.com192.0.2.13 rac1-vip192.0.2.12 rac2 rac 2018-09-20 Oracle #cluster #12c
oracle用户密码错误导致被锁 碰到一个数据库用户总是被锁住 12345SQL> select name,lcount from user$ where name='WOLF';NAME LCOUNT------------------------------ ----------WOLF 149 从解锁到现在又失败了149 2018-09-07 Oracle
Scripts: Oracle11g自动化安装 安装脚本: https://raw.githubusercontent.com/xblvesting/oracle-install/master/auto-install.sh Readme 支持Oracle 11g和18c版本在linux6和7的安装 支持Dataguard的一键安装 部分安装日志: 1234567891011121314151617181920212223242526272 2018-09-06 Oracle #scripts