ITPub博客

<p>之前通过orabbix可以监控oracle很多对象,具体可以参考:</p><p>http://blog.itpub.net/24486203/viewspace-1788791/</p><p>1.在被监控端创建脚本，此脚本用于获取表空间及空间使用信息,此脚本由oracle用户下创建(这里我将system及sysaux 监控去除掉了)．这个zabbix用户为之前orabbix所创建用户</p><p>[roo...

       之前也写过一篇10046的文章：10046简介       今天，Think想和大家一起共同深入去理解一下Oracle的这些调试事件            10046事件是SQL_TRACE的扩展，被戏称为"吃了兴奋剂的SQL_TRACE"       有效的追踪级别：              ① 0级：SQL_TRACE=FASLE       ② 1级：SQL_TRA

最近有一套系统一条简单的语句执行很慢：create table xxx as select * from xxx；做了简单的10046如下：SQL ID: 479aa0z9yttdr Plan Hash: 2897757325create table CRE000_HR_DMcall     count       cpu    elapsed       disk      query &...

本文描述在Linux环境下搭建LAMP平台，所用软件均为最新版，CentOS6.0+Apache2.2.21+MySQL5.5.17+PHP5.3.8。 L部分就不用说了吧，下面按照AMP的顺序挨个操作。 0、准备工作 检查依赖包是否安装： # rpm -...

+----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------...

在安装完RAC11.2.0.4,并打上PSU后，在通过DBCA创建数据库实例是出现诡异现象：弹出来的框为单实例创建，二并非RAC实例。反复试了几次都是同样的问题，检查安装无问题。在metalink上查看了下，问题原因很多，同事通过sqlplus连接空实例测试出现如下报错：[oracle@zderp2vprd01 cfgtoollogs]$ sqlplus / as sysdbaSQL*...

Using configuration parameter file: /oracle/app/11.2.0/grid_1/crs/install/crsconfig_paramsStopping CRS...Stopped CRS successfullypatch /osbackup/soft/21523375/21352635  apply successful for home  /oracle/app/11.2.0/grid_1 patch /osbackup/soft/21523375/21352649  apply fail...

概述---------------------gc buffer busy是RAC数据库中常见的等待事件，11g开始gc buffer  busy分为gc buffer busy acquire和gc buffer  busy release。gc buffer busy acquire是当session#1尝试请求访问远程实例(remote  instance) buffer，但是在session#1之前已经有相同实例上另外一个session#2请...

连接数据库的几种方式：语法：cx_Oracle.connect('username','pwd','IP/HOSTNAME:PORT/TNSNAME')import cx_Oracledb1=cx_Oracle.connect('yang','yang','127.0.0.1:1523/yangdb')db2=cx_Oracle.connect('yang/yang@1...

申明：本文转载自：http://czmmiao.iteye.com/blog/1763055IPC Send timeout故障现象RAC 数据库上比较常见的一种问题就是“IPC Send timeout”。数据库Alert log中出现了“IPC Send timeout”之后，经常会伴随着ora-29740 或者 "Waiting for clusterware split-brain resolution"等，数据库实例会因此异常终止...

You can create a physical standby of a multitenant container database (CDB) just as you can create a physical standby of a regular primary database. The following are some of the behavioral differences to be aware of when you create and use a physical standby of a CDB:创建一个多租户的CDB环境...

SQL> SELECT NAME,VALUE,DISPLAY_VALUE,ISPDB_MODIFIABLE FROM v$parameter WHERE ISPDB_MODIFIABLE='TRUE';NAMEVALUEDISPLAY_VALUEISPDBsessions472...

The Oracle database uses the LOG_ARCHIVE_TRACE initialization parameter to enable and control the generation of comprehensive trace information for log archiving and redo transport activity.The additional tracing that is output when LOG_ARCHIVE_TRACE is set to a non-z...

Oracle 12C rac DataGuard环境部署。

关于DGbroker的配置网上有太多资料了，此处在不做详细介绍配置，贴一片metalink上的文章共大家参考学习。1. Prerequisits,Start the Dataguard broker DMON process. ----------启动dg_brokerOn Primary and Standby,SQL> alter system set dg_broker_start=true sid='*';  2. Connect to DGMG...

Standard distributions are available as compressed tar files, Zip archives, or RPM packages. Distribution files have names of the form mysql-VERSION.tar.gz, mysql-VERSION.zip, or mysql-VERSION.rpm, where VERSION is a number like 5.7.14. File names for source d...

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterLinux x86-64SYMPTOMSDynamically added new disks to storage using udev rules(as per the docs note 414897.1, 1528148.1, 371814.1 etc).During start_udev, udev has deleted the public network interface a...

在AIX6.1下安装ORACLE11.2.0.4 RAC的时候，在节点2执行root.sh报错如下：[root@oratest02:/oracle/]#sh /oracle/app/11.2.0/grid_1/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:    ORACLE_OWNER= grid    ORACLE_HOME=  ...

enq: IV - contention9294.14.37.4OtherIn this DocumentSymptomsCauseSolutionReference...

[root@jttmsvura02 bin]# ./wsadmin.sh -conntpe NONE -lang jythonWASX7209I: 浣跨. SOAP 杩..?ㄨ??ュ.?.. jttmsvura02CellManager01 涓..杩.??.mgr?.?杩.??.被anagerWASX7411W: 蹇界.浠ヤ??.??.?.」锛.-conntpe, NONE]WASX7031I: 瑕..?.府?╋?璇疯??ワ??.rint Help.help()?wsadmin>AdminTask.changeHostName('[inter...