DML RETURNING INTO Clause
From:http://www.oracle-base.com/articles/misc/dml_returning_into_clause.phpDML RETURNING INTO ClauseThe RETURNING INTO clause allows us to return column values for rows affected ...
cisco与h3c的syslog配置
H3C:[H3C]info-center enable[H3C]info-center loghost 1.1.1.1[H3C]info-center loghost source Vlan-interface 17[H3C]info-center timestamp log date[H3C]info-center switch-on all ...
oracle HA Features
http://www.oracle.com/technology/deploy/availability/index.html
learn AWK from oracle.com
From:http://www.oracle.com/technology/pub/articles/dulaney_awk.htmlLinux SysadminAWK: The Linux Administrators' Wisdom KitBy Emmett DulaneyLearning Linux? This introduction to the ...
Basic Enterprise Manager Troubleshooting
From:http://www.oracle-base.com/articles/misc/BasicEnterpriseManagerTroubleshooting.phpBasic Enterprise Manager TroubleshootingThe web-based Enterprise Manager tool was introduced in Oracle 10...
ASM using ASMLib and Raw Devices
From:http://www.oracle-base.com/articles/10g/ASMUsingASMLibAndRawDevices.phpASM using ASMLib and Raw DevicesIntroductionPartition the DisksASMLib InstallationRaw Device SetupASM CreationDataba...
Tuning and Optimizing Red Hat Enterprise Linux for Oracle 9i and 10g Databases
From:http://www.puschitz.com/TuningLinuxForOracle.shtml#UsingBlockDevicesForOracle10gRelease2InRHEL4This article is a step by step guide for tuning and optimizing Red Hat Enterprise Linux on x...
转:ASM Disk Crash - CASE STUDY
ASM Disk Crash - CASE STUDY Posted On Sunday, April 12, 2009 at at 5:00 AM by Anup Kumar Srivastav Case: (All Disks in a failgroup are lost after a disk/LUN failure)RedundancyNORMAL...
How to find Oracle DB Components version
select * from v$version perl $ORACLE_HOME /OPatch/opatch.pl versionlsnrctl version
DBMS_METADATA.GET_DLL学习
set pagesize 0 set long 90000 set feedback off set echo off--table 's ddlSELECT DBMS_METADATA.GET_DDL('TABLE', U.TABLE_NAME) FROM ...
转:H3C S9500交换机OSPF故障问题处理方法
故障处理步骤1)步骤1确认接口地址配置是否正确,接口网段是否包含在OSPF的network命令配置的网段内,ping对端接口地址是否能够ping通,两边的网络接口类型是否配置一致。如果确认配置正常,请转步...
转:ORA-15186: ASMLIB error function = [asm_open], error = [1],
From:http://space.itpub.net/471666/viewspace-406996ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]参考 Metalink Note:398622.1Subject:ORA-1...
转:Oracle 10g Release 2 CSS parameters
From:http://space.itpub.net/471666/viewspace-543090Oracle 10g Release 2 CSS parametersOracle Database 10g Release 2 CSS (Cluster Synchronization Service) parameters:With different patch-s...
backup backupset
From:http://space.itpub.net/283894/viewspace-366146
转:DB安装升级及RAC安装升级,增删节点
http://www.pythian.com/news/1035/oracle-silent-mode-part-110-installation-of-102-and-111-databases
RAC+ASM在异机上恢复的过程(from eygle)
From:http://www.eygle.com/digest/2009/02/rman_oracle10g_rac.html使用RMAN恢复Oracle 10g RAC库至异机主RAC库:2个节点 rac1(192.168.218.168),rac2(192.168.218.168) 采用ASM+RAW备机 standby(192.168.2...
FROM ASM Migrating to FILE SYSTEM Using RMAN(三)
From:http://space.itpub.net/?uid-7199859-action-viewspace-itemid-374367有时候我们从文件系统迁移到了ASM存储后 因为某些原因,需要重新用回到文件系统 以下步骤就是操作方法:[oracle@localhost orc...
Migrating to ASM Using RMAN(二)
From:http://space.itpub.net/7199859/viewspace-374304Migrating to ASM Using RMAN (实践具体操作过程)[oracle@localhost orcl]$ export ORACLE_SID=orcl[oracle@localhost orcl]$ sqlplus / ...
Migrating to ASM Using RMAN(一)
From:http://space.itpub.net/?uid-7199859-action-viewspace-itemid-374303Migrating to ASM Using RMAN (理论)The following method shows how a primary database can be migrated to ASM from...
Convert a Single Instance Database to Oracle RAC 10g on RHEL3
From:http://www.oracle.com/technology/pub/articles/chan_sing2rac_install.html