ITPub博客

ASM database administrator (osdba) group ASM instance administrator operator(osoper) group ASM instance administrator (osasm) group [@more@]

谨慎删除归档日志，原因有二， 第一，首先查看v$recover_files 没有任何记录。否则不能删除归档日志 第二，若有dg环境，确认归档日志已经传递到dg的目的端，否则，禁止删除源端的归档日志。[@more@]

Oracle DataPump Quick Start [ID 413965.1][@more@]

CRS 10gR2/ 11gR1/ 11gR2 Diagnostic Collection Guide [ID 330358.1][@more@]

Remote Diagnostic Agent (RDA) 4 - Getting Started [ID 314422.1][@more@]

摘自：Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions [Video] [ID 553337.1]Restrictions:1. Tables with a LONG column are not supported in an Export Data Pump job with NETWORK_LINK parameter. An ORA-31679 error will be generated and the export will move on to the next table. See also section 8.11. "ORA-31679 (Table data object "aaa"."bbb" has long columns, and longs can not be loaded/unloaded using a networ

Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.1 - Release: 9.2 to 11.2Oracle Universal Installer - Version: 10.1.0.2 to 11.2.0.1 [Release: 10.1 to 11.2]Information in this document applies to any platform. Goal The goal of this note is to provide links to various Metalink notes regarding how to clone Oracle RDBMS installations using the Oracle Universal Installer (OUI) NOTE: These notes should only be used for cloning single-instance (non-RAC) homes.

Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2 - Release: 9.2 to 11.2Information in this document applies to any platform. Goal How to install an Oracle database in a 2-node active/passive environment without using RAC. Solution The set up of an active/passive failover system is fairly straightforward.It consists of the following main parts: Install an Oracle Home locally on cluster node A.Install an identical Oracle Home locally on cluster node B.The

How To Setup ASM (11.2) On An Active/Passive Cluster (Non-RAC). [ID 1296124.1] [@more@]

How To Setup ASM (10.2 & 11.1) On An Active/Passive Cluster (Non-RAC). [ID 1319050.1][@more@]

Requirements for Installing Oracle 11gR1 RDBMS on Solaris 10 SPARC 64-bit [ID 743042.1][@more@]

Requirements for Installing Oracle 11gR2 RDBMS on Solaris 10 SPARC [ID 964976.1][@more@]

Real Application Clusters Multiple instances must have the same value.DB_FILES specifies the maximum number of database files that can be opened for this database. The maximum valid value is the maximum number of files, subject to operating system constraint, that will ever be specified for the database, including files to be added by ADD DATAFILE statements. If you increase the value of DB_FILES, then you must shut down and restart all instances accessing the database before the new

Purpose In this article we will demonstrate how to set up the Openfiler based server as an iSCSI storage device. We will then show how to use that iSCSI storage with an Oracle 10gR2 database with Real Application Clusters option. Openfiler (http://www.openfiler.com) is a powerful, intuitive browser-based network storage software distribution. Openfiler delivers file-based Network Attached Storage (NAS) and block-based Storage Area Networking (SAN) in a single framework. Openfiler

1. asmlib包的格式： oracleasm-<kernel version>-<ASMLib version>oracleasmliboracleasm-support2.asmlib的安装检查[root@rac1 ~]# rpm -q oracleasm-`uname -r`package oracleasm-2.6.18-194.1.AXS3 is not installed2.asmlib的状态检查[root@rac1 ~]# service oracleasm statusChecking if ASM is loaded: yesChecking if /dev/oracleasm is mounted: yes# service oracleasm startInitializing the Oracle ASMLib driver: [ OK ]Scanning the system for Oracle ASMLib disks: [ OK ]up2date -i oracleasm-`uname

# rpm -qa |grep oracleasm# rpm -e oracleasmlib-2.0.2-1[@more@]

rhel 5.5 下安装11gR2时关于ntp的一点：若是不使用rhel自己的ntp服务，请在停止ntp服务后，务必进行如下的操作：# rm /etc/ntp.confor, mv /etc/ntp.conf to /etc/ntp.conf.org.否则，在grid infrastructure安装时，会提示你ntp服务没启动。。。 [@more@]

ssh 和secure crt 里看 /etc/hosts看168和l68，感觉还是secure crt的显示比ssh的显示要更明显一些，还是secure crt好。。。另外，ssh进行记录log时，有时候log会终止记录你敲入的命令，这样让人很不爽啊。[@more@]

配置oracleasm失败：[root@rac1 ~]# /etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets ('[]'). Hitting <ENTER> without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface [grid]: Default

白鳝-shenzhen(62565) 2011-11-10 15:30:13 就像以前RESIZE 文件，我们不建议RESIZE文件，而是直接ADD文件，一旦RESIZE过程出问题，那么文件就损坏了[@more@]