ora-01031:insufficient privileges
注意多个数据库实例时候，set ORACLE_SID='', 1、检查sqlnet.ora（WINDOWS下位于%ORACLE_HOME%NETWORKADMIN目录）是否包含这句：SQLNET.AUTHENTICATI...
技术文章列表
402 篇Ora-00600 [18062] During Database Startup
Oracle Server – Enterprise Edition – Version: 11.2.0.2.0 and later [Release: 11.2 and later ]Information in ...
Optimize Oracle SQL*Loader (sqlldr) Performance
> > > > > > > > > > > Advanced Oracle Utilities > SQL*Loader Option | Elapsed Time (...
Optimize Oracle import performance
| | **Optimize Oracle import (imp) performance** Don Burleson | see here[Oracle export (expdp) performance speed](http:/...
Online Index Rebuild fails with ORA-08106: cannot create journal table
Before investigation few things to remember about online index rebuild It will do a full table scan on the base table. A...
OGG复制进程延迟不断增长
# 某在线系统使用OGG做了同步复制用于二期业务生产使用。有同事过来说复制进程有点异常 跟他去了终端旁边，发现确实有个rps1进程延迟有点高。看着进程状态是RUNNING，但是根据我维护六年ogg来看，有可能是假象，那么怎么判断呢？1，查看...
OGG_GoldenGate日常监控
!1756814744621-2b73f94c-b576-4c01-a8e7-94c769a7f3cd.png一、摘要 — 对GoldenGate实例进行监控，可以公国简单高效的方式GGSCI命令进行监控，并查看返回的信息，判断...
OGG replicat出现ORA-01403 错误NO data found-darren__chan-ITPUB博客
分类： Oracle OGG replicat出现ORA-01403 错误NO data found 今天OGG出现表数据不同步，入库端接收update和delete语句时出现ORA-01403 错误NO data found 一直同步，排...
OGG ddl触发器 导致所有user不能ddl操作 – 厚积薄发-Survival – 博客频道 – CSDN.NET
[ OGG ddl触发器 导致所有user不能ddl操作 ](http://blog.csdn.net/lmocm/article/details/42971773) . 标签： [ogg](http://www.csdn.net/tag/...
mysql 5.6优化,性能提升6倍 ,mysql5.6占用内存大，通过state优化
http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html1. 连接请求的变量：## 1) max_connections 2) back_log 3)...
Moving Your 11.2 Database to a new Diskgroup in ASM
Introduction: I have been assigned with a new challenge with 11.2 Oracle On RedHat Linux with Grid Infrastructure and AS...
Mounting ASM Diskgroup Fails With ORA-15063 Error and Resolving With KFED
I want to share a situation that happened to me recently. I closed my database running on ASM and also ASM instance succ...
Monitoring Restore_Recovery Progress 1335910.1
Goal Solution RMAN Log Alert.log Restore Operation Recovery Operation User Managed Recovery Log Operating System Utiliti...
Modifying SCAN Configuration in Oracle 11g Release 2 RAC
The original name was "ol6-112-scan" and I want to rename it to "ol6-112-scan2". Check the new name ...
MOATS: The Mother of All Tuning Scripts!
MOATS (original) by Adrian Billington & Tanel: https://github.com/oracle-developer/moats MOATS 2.0 (RAC-aware) by Si...
Migration using cross platform transportable tablespace [XTTS] and Cross platform incremental backup
DBMS_FILE_TRANSFER method RMAN backup method Pre-requisites for using "XTTS+Cross platform incremental backup"...
Master Note: Troubleshooting Oracle Tablespace Management (文档 ID 1522807.1)
Master Note: Overview of Oracle Tablespace Management (文档 ID 1493350.1)
log file sync 等待超高一例子
这是3月份某客户的情况，原因是服务器硬件故障后进行更换之后，业务翻译偶尔出现提交缓慢的情况。我们先来看下awr的情况。 ![1756815056504-213c2183-b13a-4349-b842-315a29b43769.jpg ](h...
log file sync总结
?/*2015年1月22日*/ log file sync等待时间发生在redo log从log buffer写入到log file期间。下面对log file sync做个详细的解释。 何时发生日志写入：1.commit或者rollbac...