- 博客(228)
- 资源 (13)
- 收藏
- 关注
原创 Install Oracle Database 12cR2 On Oracle Enterprise Linux7.3
请仔细阅读Oracle官方手册Database Installation Guide for Linux 安装操作系统之后如果想安装VBOX的增强功能可能出现的报错如下:[root@oel73 log]# vi vboxadd-install.log /tmp/vbox.0/Makefile.include.header:97: *** Error: unable to find t
2017-03-09 21:12:53 2307
原创 Install Oracle Database 12cR2 On RHEL7.3
请仔细阅读Oracle官方手册Database Installation Guide for Linux 安装操作系统之后如果想安装VBOX的增强功能可能出现的报错如下:[root@rh73 log]# vi vboxadd-install.log /tmp/vbox.0/Makefile.include.header:97: *** Error: unable to find th
2017-03-07 21:05:36 1349 1
转载 RHEL6&7的Kickstart的变化
转自本文链接:http://linux.52zhe.info/read.php/299.htm本文作者:kook(若就博客内所涉及的技术问题交流,请用下面的MSN或Gmail联系我)联系方式:(MSN:kook#live.com) (Google talk:kookliu)没有版权:GNU,转载时请注明“转载人”欠本人一顿饭,来日见面之时兑现!谢谢合作!一直关注订阅这哥
2016-04-25 18:21:43 978
原创 12c单实例数据库打最新12.1.0.2.160119 PSU补丁记录
12c单实例数据库打最新12.1.0.2.160119 PSU补丁记录 [oracle@oel11 ~]$ opatch lsinvOracle Interim Patch Installer version 12.1.0.1.9Copyright (c) 2016, Oracle Corporation. All rights reserved.Oracle
2016-02-01 16:26:27 1529
原创 11g单实例数据库打最新11.2.0.4.160119 PSU补丁记录
11g单实例数据库打最新11.2.0.4.160119 PSU补丁记录[oracle@rh64 ~]$ opatch lsinvOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation. All rights reserved.Oracle Hom
2016-02-01 15:53:28 1623
原创 11g R2 RAC打最新11.2.0.4.8 PSU补丁记录
采用手工打补丁,步骤如下:1.su - # $GRID_HOME/crs/install/rootcrs.pl -unlock2.su - grid$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./21523375/21352649$ $GRID_HOME/OPatch/opatch na
2015-10-30 15:55:17 2238
原创 12c单实例数据库打最新12.1.0.2.5 PSU补丁记录
[root@oel11 ~]# su - oracle[oracle@oel11 ~]$ env|grep ORAORA_NLS10=/s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/nls/dataORACLE_SID=PROD12ORACLE_BASE=/s01/oracle12c/app/oracleORACLE_HO
2015-10-30 11:05:24 2066
原创 11g单实例数据库打最新11.2.0.4.8 PSU补丁记录
[root@rh64 soft]# su - oracle[oracle@rh64 ~]$ opatch lsinvOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation. All rights reserved.Oracle Home
2015-10-30 10:28:01 1786
原创 linux命令技巧
[oracle@rh64 ~]$ cat lgrw.txtcat: lgrw.txt: No such file or directory[oracle@rh64 ~]$ ^rw^wrcat lgwr.txt18:03:19.703928 times({tms_utime=27, tms_stime=18, tms_cutime=0, tms_cstime=0})
2015-08-31 09:41:36 1307 1
原创 linux个人操作习惯
编辑~/.bashrc文件加入以下内容,定义别名# .bashrc # User specific aliases and functionsalias rm='rm -i'alias cp='cp -i'alias mv='mv -i'alias cls='clear' #DOS下的清屏命令,也可以用Ctrl+L,简单快速
2015-08-31 09:27:09 873 1
原创 使用操作系统命令来trace监听
strace tnsping prodstrace tnsping prod 2>&1 | lessstrace -eopen tnsping prod 2>&1 | grep '= -1'strace tnsping prod 2>&1 >/dev/null | grep -E '^stat|^open'strace -e trace=access,open,s
2015-08-31 09:21:11 1132 1
原创 国外优秀的数据库实用工具介绍
给大家介绍几个有关数据库的好用的工具,都是国外的Oracle大师写的,并且在Github上开源了edb360https://github.com/carlos-sierra/edb360eadamhttps://github.com/carlos-sierra/eadamsqld360https://github.com/mauropagano/sqld360ashma
2015-08-07 10:45:40 1192
翻译 What causes Cardinality to be wrong?
What causes Cardinality to be wrong?1>Data Skews2>Multiple single column predicates on a table --->>>解决方案为收集扩展统计信息3>A function wrapped where clause predicate4>No statistics or Stale St
2015-08-03 20:14:33 619
原创 orachk现在软件里面都已经内置了
orachk现在oracle database 11.2.0.4+ 12.1.0.2+都已经内置了,$ORACLE_HOME/suptool/下面就有[oracle@rh64 ~]$ cd $ORACLE_HOME/suptools[oracle@rh64 suptools]$ ls -ltrtotal 8drwxr-xr-x 3 oracle oinstall 4096 Ja
2015-07-27 15:52:35 1491
原创 在Oracle数据库中使用NFS,如何调优?
MOS上有好多文章,基本上都跑不了下面三点:Setup can make a big difference1. Network topology and load2. NFS mount options(选择合适的挂载选项)3. TCP configuration(配置合适的MTU,TCP window size,TCP congestion window sizes)
2015-07-23 10:07:45 1122
原创 11g RAC打最新的11.2.0.4.7补丁记录
20760982--->>>DB PSU 11.2.0.4.7 (INCLUDES CPUJUL2015)--->>>Both DB Homes and Grid Home20831122--->>>OCW PSU 11.2.0.4.7--->>>Both DB Homes and Grid Home20299019--->>>ACFS PSU 11.2.0.4.7--->>>Only G
2015-07-21 14:21:59 2464
原创 oracle 12c单实例数据库打12.1.0.2.4补丁记录
操作系统版本:[oracle@oel11 OPatch]$ lsb_release -aLSB Version: :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-i
2015-07-21 10:11:23 2269
原创 单机oracle数据库打最新11.2.0.4.7记录
[oracle@rh64 soft]$ opatch lsinvOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/db11g/product/1
2015-07-21 09:40:56 1569
原创 update慢如何处理?
update慢: 1.表的pctfree参数设置? 2.执行计划用索引还是全表扫? 3.SQL语句写法问题? 4.update慢还是commit慢? 5.更新多少条数据? 6.表是否频繁update造成碎片过多? 7.考虑使用merge? 8.应用问题? 9.数据库参数设置?
2015-07-10 19:05:52 4872
原创 goldengate一些参数整理
manager参数:AUTOSTART:指定在mgr启动时自动启动那些进程.AUTOSTART ER *AUTOSTART extract extsz AUTORESTART:指定在mgr可以定时重启那些进程。可以在网络中断等故障恢复后自动重起,避免人工干预.AUTORESTART ER *, WAITMINUTES 5, RETRIES 3
2015-06-23 10:59:35 6221
原创 OGG常见问题处理
1403:ORA-01403: No data found在执行PL/SQL块、存储过程、函数、触发器等,如果需要进行操作的记录没有查询到,则会返回1403的错误Goldengate中的1403在目标段复制进程中,godengate从日志中解析出sql语句,根据sql语句的where条件,在目标段的库中匹配不出相应的记录1403错误原因:1. 附加日志相
2015-06-23 10:56:07 3593
原创 DSI301: Advanced Server Support Skills
DSI3系列比较老了,分为下面几个:DSI301: Advanced Server Support SkillsDSI302: Data ManagementDSI303: Database Backup and RecoveryDSI304: Query ManagementDSI305: Database TuningDSI306: Very Large Databas
2015-06-23 10:49:00 1682
转载 Scripts:ash_gcwait_to_obj.sql
set lines 100 pages 100undef event col object_name format A32col object_type format A20col owner format A20col cnt format 999999999with ash_gc as (select * from (select /*+ materialize
2015-06-17 16:14:44 911
原创 Orapub System Monitor
老外编写的一个工具,貌似现在用处不大了,随着每个人工作经验的增长,都会形成自己的一套知识库,一套脚本.在此分享下.找个老的,有想要研究的拿去.SQL> @osmi.sqlOraPub Online Institute - What any-where any-device any-time training should be!OraPub System Monitor
2015-06-17 16:01:30 1508
原创 CBO估计执行计划需要参考的三项
EstimatorThe estimator determines the overall cost of a given execution plan. The estimator generates three different types of measures to achieve this goal:SelectivityThis measure represe
2015-05-06 14:29:09 780
原创 9 Adding and Deleting Nodes and Instances
9 Adding and Deleting Nodes and InstancesVerifying the New Node Meets the Prerequisites for InstallationAfter you have configured the new nodes, you should use cluvfy to verify that all the re
2015-05-05 09:48:49 788
原创 8 Monitoring Performance and Troubleshooting
8 Monitoring Performance and TroubleshootingThe Global Cache Block Access Latency chart shows data for two different types of data block requests: current and consistent-read (CR) blocks. When you u
2015-05-04 16:46:26 907
原创 7 Managing Database Workload Using Services
7 Managing Database Workload Using ServicesNote:A database service can only be offered on a single network.Caution:By default, any named user may create a server pool. To restrict the oper
2015-05-04 13:21:45 980
原创 6 Administering Backup and Recovery
Oracle® Database 2 Day + Real Application Clusters Guide11g Release 2 (11.2)E17264-136 Administering Backup and RecoveryOverview of Oracle RAC Database Backup and RecoveryNote:For
2015-05-01 15:28:39 827
原创 About Oracle Cluster Registry
About Oracle Cluster RegistryOracle Cluster Registry (OCR) is a file that contains information about the cluster node list and instance-to-node mapping information. OCR also contains information
2015-05-01 14:47:48 701
原创 About Modifying the SERVICE_NAMES Parameter for Oracle RAC
About Modifying the SERVICE_NAMES Parameter for Oracle RACThe SERVICE_NAMES initialization parameter specifies one or more names by which clients can connect to the instance. The instance regist
2015-04-28 16:17:43 665
原创 /tmp/.oracle,/var/tmp/.oracle如果删除了,该怎么办?
在官方文档有如下的描述:3 Installing Oracle Grid Infrastructure and Oracle Real Application ClustersCaution:After installation is complete, do not remove manually or run cron jobs that remove /tmp/.orac
2015-04-28 15:56:03 1986
原创 Linux下使用strace的例子
strace参数如下:-t 输出结果精确到秒-tt 输出结果精确到微妙-ttt 精确到微妙,而且时间表示为unix时间戳 -T 记录每个系统调用花费的时间,可以看看哪个系统调用时间长-s 1024 显示系统调用参数时,对于字符串显示的长度, 默认是32,如果字符串参数很长,很多信息显示不出来-o filename 把跟踪结果输出到文件-p pid 可以跟踪
2015-04-28 15:14:59 971
原创 Preparing Your Cluster
Oracle® Database 2 Day + Real Application Clusters Guide11g Release 2 (11.2)E17264-132 Preparing Your ClusterAbout Shared StorageNote:If you choose not to use Oracle ASM for storing yo
2015-04-28 13:04:58 1041
转载 DRM 简介
原文地址:https://blogs.oracle.com/Database4CN/entry/drm_%E7%AE%80%E4%BB%8BDRM 简介By Allen Gao-Oracle on 二月 22, 2013首先,我们对和DRM 相关的一些概念进行介绍。Buffer: 对于RAC 数据库,当一个数据块被读入到buffer cache后
2015-04-26 11:17:33 662
原创 关于新参数DB_UNRECOVERABLE_SCN_TRACKING
DB_UNRECOVERABLE_SCN_TRACKING这个参数是从11.2.0.2才有的,看官方文档介绍如下:Default valuetrueModifiableALTER SESSION, ALTER SYSTEMRange of valuestrue | falseBasicN
2015-04-26 10:32:27 1520
原创 11.2.0.4.6 PSU升级成功
上周给自己的虚拟机11.2.0.4.5打.6的PSU没想到我在一个节点把之前opatch 备份的目录给删除了,结果就打不上补丁了。记住啊$GRID_HOME和$ORACLE_HOME下的.patch_storage目录可千万不能删除了,否则就无法打上补丁了。今天有时间,想折腾一下,查看了下,幸好2节点都没有 把目录删除,SCP过来,什么都没有修改,直接OPatch就成功了,特此纪念下。Metali
2015-04-25 18:44:43 1717
转载 Prerequisite Check "CheckRollbackable" On Auto-rollback Patches Failed (文档 ID 1331900.1)
In this Document Symptoms Cause Solution ReferencesAPPLIES TO:Oracle Universal Installer - Version 10.2.0.1 and laterInfor
2015-04-19 20:41:51 1561
转载 How To Avoid Disk Full Issues Because OPatch Backups Take Big Amount Of Disk Space. (文档 ID 550522.1)
In this Document Goal Solution 1.) If the filesystem gets full in the middle of applying a patch, what is the process to recover? 2.) Can
2015-04-19 20:33:54 2275
转载 Can You Delete $ORACLE_HOME/.patch_storage Directory ? (文档 ID 403218.1)
今天给自己虚拟机打最新的11.2.0.4.6的GI/DB的PSU补丁,碰到坑了,之前虚拟机空间不足,我把.patch_storage给清了,结果就打补丁报错,特此纪念下!In this Document Goal Solution ReferencesAPPLIES TO
2015-04-19 20:21:16 1150
Orapub System Monitor
2015-06-17
Oracle Core:Essential.Internals.for.DBAs.and.Developers.Jonathan.Lewis
2012-08-13
Using.Oracle.Solutions.on.Linux.for.System.z.2008
2012-08-04
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人