技术文章列表
512 篇VMware vSphere 5_6 创建RAC虚拟机共享磁盘
[日期：2017-05-17] | 来源：Linux社区 作者：seiang | [字体：[大](#) [中](#) [小](#)] | 今天搭建RAC环境，想要让RAC的共享磁盘使用存储设备的磁盘空间，所以在搭建vmware vspher...
vip漂移
crs_stat -p ora.node1.vip 2 停止相关的依赖比如监听 srvctl stop listener -n node1 3 漂移vip到另一个节点 crs_start ora.node1.vip -c node2 还有一...
Validate Network and Name Resolution Setup for the Clusterware and RAC
Purpose Scope Details A. Requirement B. Example of what we expect C. Syntax reference D. Multicast E. Runtime network is...
v$ Views for the Oracle DBA
# One key task of the Oracle database professional is to perform daily monitoring to ensure that the database environmen...
Using Sql Tuning Advisor – Sql Profile
Automatic Sql Tuning is a new capability of query optimizer introduced in 10g. In 10g, the enhanced Query Optimizer can ...
Using Rman to Migrate database from windows(11.2.0.1) to linux(11.2.0.3)
1 Verify following information on Winodow platform: SQL> select * from v$version;SQL> select platform_id, platform...
Upgrade 10gr2 RAC to 11gr2 RAC – Fung’s DBA World
April 06, 2014 本文演示了如何从10gr2 RAC升级至11gr2 RAC，示例中的10g版本为10.2.0.4，可以直接升级至11.2.0.4。11g升级路径如下： 直接升级路径：9.2.0.8 +，10.1.0.5+，10...
Unix下两种后台执行SQL脚本的方法
通常要单独在OS后台执行一个耗时的SQL脚本，采用如下两种方法： 方法一： 1、在其目录创建一个可执行脚本，如脚本名为 create_index.sh： $vi create_index.sh 2、编辑文件内容： sqlplus usern...
Troubleshooting Performance Issues
 reports show I/O wait events in the "Top 5 Wait/Timed Even...
Troubleshoot Grid Infrastructure Startup Issues (Doc ID 1050908.1)
Purpose Scope Details Start up sequence: Cluster status Case 1: OHASD does not start Case 2: OHASD Agents do not start C...
Tracking Oracle initialization parameter changes
— parm_mods.sql—- Shows all parameters (including hidden) that have been modified. — Uses the lag func...
trace文件分析工具之二
如何使用trca：必须进入 trca/run 目录里面 或者把 /home/oracle/software/trca/run 放到SQL_PATH环境变量里面： ASM无法启动的问题分析(二）… ASM无法启动的问题分析(一）&...
TRACE Oracle跟踪事件
一、Oracle跟踪事件 Oracle提供了一类命令，可以将Oracle各类内部结构中所包含的信息转储(dump)到跟踪文件中，以便用户能根据文件内容来解决各种故障。设置跟踪事件有两种方法，一种是在init.ora文件中设置事件，这样ope...
Tale of a platform migration Solaris 10 SPARC 10.2.0.5 to Linux 11.2.0.2.6
Define a self-contained set of tablespaces. In other words, the tablespaces you export from the source must not contain ...
Tablespace Growth Report
Author JP Vijaykumar Date Sept 8 2013 Modified Sept 14 2013 /* The period range for this report is dependent on the snap...
Tablespace Growth History and Forecast (12c and Above)
For 10g, 11g, you can use Tablespace Growth History and Forecast (10g, 11g) and Database Growth History and Forecast (10...
Tablespace growth
SELECT TO_CHAR (sp.begin_interval_time,'DD-MM-YYYY') days > , ts.tsname> , max(round((tsu.tablespace_siz...
SYSAUX表空间的重建试验_jinhb
2012-03-13 09:34阅读：2,007[http://www.itpub.net/forum.php?mod=viewthread&tid=1477610&highlight=sysaux]()