摘要: SharePlex是Quest公司的Oracle数据库复制解决方案,采用了基于Oracle日志的数据复制技术,可以利用极少的系统开支,实时复制数据到目标数据库,改善数据可用性。SharePlex是业界最成熟的高性能/高可用性数据复制解决方案。具有网络占用少、配置灵活、准实时复制等特点,可以解决关键... 阅读全文
posted @ 2015-04-01 16:42 dbaquan 阅读(1058) 评论(0) 推荐(0) 编辑
摘要: 如何调整Exadata DB节点文件系统大小http://www.dbaleet.org/how_to_resize_exadat_filesystem_on_db_node/此文整理自MOS文档How to Expand Exadata Compute Node File Systems (Doc... 阅读全文
posted @ 2015-01-28 22:06 dbaquan 阅读(474) 评论(0) 推荐(0) 编辑
摘要: 原文http://www.dbaleet.org/cach_write_policy_write-through_and_write-back/write-through和write-back这个概念在存储工程师眼里绝对不会陌生,而对于数据库管理员来说并却并不一定十分清楚。我说看到的数据库管理员与存... 阅读全文
posted @ 2015-01-28 21:47 dbaquan 阅读(6187) 评论(0) 推荐(0) 编辑
摘要: For some reason, I’ve been working on lots of Exadata V2 systems in the past few months. One of the issues that I’ve been coming across for these clie... 阅读全文
posted @ 2015-01-28 21:41 dbaquan 阅读(298) 评论(0) 推荐(0) 编辑
摘要: ORA-30012: undo tablespace 'UNDO_2' does not exist or of wrong typeI have 3 node RAC system. I am trying to convert from single to the RAC system. I h... 阅读全文
posted @ 2015-01-25 16:44 dbaquan 阅读(780) 评论(0) 推荐(0) 编辑
摘要: 在操作系统的运行过程中,管理员常常需要了解系统内存的使用情况,并以此为依据来指导对系统性能的调优,使系统和应用程序运行在最佳的状态。查看内存使用,我们最常用的命令是 vmstat、ps 和 svmon。使用 vmstat 命令确定内存使用情况vmstat 命令总结了系统中所有进程使用的总活动虚拟内存... 阅读全文
posted @ 2015-01-25 16:05 dbaquan 阅读(4364) 评论(0) 推荐(0) 编辑
摘要: Many Oracle DBA managing Exadata are not aware that Exadata documentation is available on every cell under/usr/share/doc/oracle/Exadata/docfolder. But... 阅读全文
posted @ 2015-01-22 22:04 dbaquan 阅读(180) 评论(0) 推荐(0) 编辑
摘要: The V2/X2 Exadata documentation is loaded on every cell server as part of the storage software. It is placed in the following directory:/opt/oracle/ce... 阅读全文
posted @ 2015-01-11 17:14 dbaquan 阅读(347) 评论(0) 推荐(0) 编辑
摘要: 故障现象:SQL> connect scott/scottERROR:ORA-01017: invalid username/password; logon deniedSQL> connect scott/scottERROR:ORA-28000: the account is locked表明:... 阅读全文
posted @ 2014-11-18 14:28 dbaquan 阅读(206) 评论(0) 推荐(0) 编辑
摘要: 三种方法都可以!!!1.解决方法:将C:/Program Files/Microsoft Visual Studio 6/Common/MSDev98/Bin下的mspdb60.dll文件拷贝到C:/Program Files/Microsoft Visual Studio 6/VC98/Bin目录... 阅读全文
posted @ 2014-11-14 13:20 dbaquan 阅读(4181) 评论(0) 推荐(0) 编辑