ITPub博客

一位做.net的同事，项目上需要通过vs2008访问oracle数据库，安装oracle客户端，配置tns后，<br />通过VS2008连接oracle时报错：<br /><br /><img src="/attachment/201508/28/27571661_1440729436e90J.png" width="700" height="531.0633213859" alt="" /><br />通过检查ORACLE客户端和TNS均没有配置错，且环境变量也没...

<p align="left" style="margin:10px auto;font-size:14px;color:#403226;font-family:verdana, 'ms song', 宋体, Arial, 微软雅黑, Helvetica, sans-serif;line-height:18pt;white-space:normal;background-color:white;"><span style="margin:0px;padding:0px;font-family:宋体;letter-spacing:0.4pt;font-size:12pt;"...

RMAN的CONFIGURE配置和FORMAT字符串格式化

lpad

sql执行计划

? DBA必知的170张Oracle常用动态性能表介绍

查看自动sql调优作业，优化sql访问路径

理解透明应用程序故障转移 (TAF) 和快速连接故障转移 (FCF) (文档 ID 1602113.1)

故障排除："log file sync"等待 (文档 ID 1626301.1)

oem无法访问

awr

rman

oracle RAC service

<p class="MsoNormal">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<a href="/blog/downLoad/fileid/42910" target="_blank"><img src="/image/default/fj.png" align="middle" />1、sql server 2008安装.doc<br /></a><br />&nbsp;&nbsp; SQL&nbsp;SERV...

goldengate

Oracle常见性能问题分析处理手册V1.doc1、消耗CPU资源最多的SQL语句查询3

<p style="margin-left:0.0000pt;text-indent:0.0000pt;background:#FFFFFF;">1、查看<span>mysql</span><span>版本</span></p><p style="background:#FFFFFF;">mysql&nbsp;-h&nbsp;localhost&nbsp;-u&nbsp;root&nbsp;-p<br />方法一：<span>status;</span><br />方法二：<span>select&nbsp;version();</span></p...

<p><a href="/blog/downLoad/fileid/42908" target="_blank"><img src="/image/default/fj.png" align="middle" />mysql安装.doc<br /><br /><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Linux<span>安装</span><span>mysql</span></p><p>&nbsp;</p><p>1.&nbsp;查看操作系统版本信...

物理DG角色转换 failover0、更改保护模式，如果备库处于MAXIMUM PROTECTION模式，需要切换为   MAXIMUM PERFORMANCE模式alter database set standby database to maximize performance;1、检查归档文件是否连续select thread#,low_sequence#,high_sequence# from v$archive_gap;复制没有同步的归档文...

物理DG角色转换 switchover1、转换前准备工作，a、检查各初始化参数，检查和转换相关的参数是否正确配置主库参数*.standby_file_management='auto'*.fal_server='liu_sgdb'*.fal_client='liu_dgdb'*.LOG_FILE_NAME_CONVERT='/oradata/dgdb/dgdb','/oradata/dgdb/dgdb'*.DB_FILE_NAME_CONVERT='/oradata/dgdb/...