oracle 10G rac + asm
网络地址规划: | 192.168.1.171 rac1 rac1.oracle.com 192.168.1.172 rac1-vip 192.168.1.173 rac2 rac2.oracle.com 192.168.1.174 rac...
技术文章列表
512 篇oracle 10g dataguard 切换测试
oracle 10g dataguard 测试 1、备库只读打开 备库现在是mount状态，不能查询数据。可以把它open read only;如果read only，备库就只能查询，并且不再应用日志。 备库操作： SQL> reco...
ora11g rac slient on rhel 7
oracle.install.crs.config.networkInterfaceList=bond0:10.174.80.0:1
ORA-16433,ORA-01173恢复
ORA-15075
May 31, 2011 [2 Comments](https://desaitaral.wordpress.com/2011/05/31/ora-15075/#comments) We faced issue with ASM 2 Wee...
ORA-15040, ORA-15066, ORA-15042 when ASM disk is not present in all nodes of a Rac Cluster. Adding a disk to the Diskgro
Symptoms 10.2.0.2 and below 10.2.0.3 and above Cause 10.2.0.2 and below 10.2.0.3 and above Solution 10.2.0.2 and below 1...
ORA-600 各个参数含义说明
一. ORA-600 概述 ORA-600 是一个非常头疼的一个错误。比如： ORA-00600:internal error code, arguments: [4194], [43], [46], [], [], [], [], [] ...
ORA-01194: file 1 needs more recovery to be consistent
Method 1: Start the database in mount state SQL> startup mount; Recover the database. SQL> recover database; If yo...
ORA-01190报错
ORA-01190这个错误比较常见，特别在没有正规DBA运维的环境中比较常见， 先看看ORACLE官方是怎么解决这个报错的 SQL> !oerr ora 01190 01190, 00000, “control file or dat...
ORA-01173的模拟与故障处理_1
www.htz.pwwww.htz.pw www.htz.pw www.htz.pw www.htz.pwwww.htz.pwwww.htz.pw www.htz.pw www.htz.pwwww.htz.pwwww.htz.pwwww.h...
ORA-01173的模拟与故障处理
下面的测试来至于一位网友，他们生产数据库异常，在drop表空间，重建控制文件后，报下面的错误： Sat Jul 19 00:45:47 2014SMON: enabling cache recoverySat Jul 19 00:45:47...
ORA-01102: cannot mount database in EXCLUSIVE mode
ora-01031:insufficient privileges
注意多个数据库实例时候，set ORACLE_SID='', 1、检查sqlnet.ora（WINDOWS下位于%ORACLE_HOME%NETWORKADMIN目录）是否包含这句：SQLNET.AUTHENTICATI...
ORA-00600: internal error code, arguments: [SKGMINVALID]
ORA-00600: internal error code, arguments: [6006] 一例
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...