Remote Diagnostic Agent (RDA) 4 - Getting Started [ID 314422.1]
Remote Diagnostic Agent (RDA) 4 - Getting Started [ID 314422.1][@more@]
使用expdp 的NETWORK_LINK参数,实现在客户端形成导出文件时的几个限制:
摘自: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
Best Practices for failover during server failures [ID 1323472.1]
Applies to: Oracle GoldenGate - Version: 10.0.0.0 to 11.1.1.0.0 - Release: 10.0.0 to 11.1.1Information in this document applies to any platform. Goal This document attempts to explain the following high availability scenario and provides best practice suggestions: Simplified scenario: Machine A is primary, B is standby and C is replicated via GoldenGate to A. -Extract process run on C -Datapump process run on C -Replicat process run on A
How To Clone An Existing RDBMS Installation Using OUI [ID 300062.1]
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.
How To Install An Oracle Database In An Active/Passive Configuration Without RAC? [ID 734361.1]
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]
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]
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]
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]
Requirements for Installing Oracle 11gR2 RDBMS on Solaris 10 SPARC [ID 964976.1][@more@]
rhel 4 update4 的内核版本号
[oracle@standby bdump]$ uname -aLinux standby 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:32:02 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux[oracle@standby bdump]$ cat /etc/redhat-release Red Hat Enterprise Linux AS release 4 (Nahant Update 4)[@more@]
red hat enterprise linux(rhel) 3 、4、 5对应的asmlib包下载网址
red hat enterprise linux 3 、4、 5对应的asmlib包下载网址 http://www.oracle.com/us/solutions/midsize/rhel5-084877.html http://www.oracle.com/us/solutions/midsize/rhel4-092650.htmlhttp://www.oracle.com/us/solutions/midsize/rhel3-098888.html [@more@]
DB_FILES 初始化参数
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
linux下查看网卡是千M或者是百M的命令
linux下查看网卡是千M或者是百M的命令-ethtool[@more@]
Using Openfiler iSCSI with an Oracle RAC database on Linux [ID 371434.1]
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
oracle asmlib包相关
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
oracleasm命令查看
# rpm -qa |grep oracleasm# rpm -e oracleasmlib-2.0.2-1[@more@]
[转]解决系统CPU个数识别不正确的问题
http://blog.chinaunix.net/space.php?uid=2469966&do=blog&id=2595410感谢原作者解决系统CPU个数识别不正确的问题 (2010-04-19 17:09) 分类: LINUX系统管理 目前 服务器上配置的CPU是越来越多,并且,单个物理CPU中也包括了更多的核心。以Intel E5504为例,一个CPU就拥有4个核心,并发的速度得到明显的提高。其中,部分CPU还同时拥有超线程技术,这样,系统中识别出来的核心数量会更多。 要让系统正确的识别出所有可用的CPU核心,系统使用Linux kernel是个关键,例如使用smp或largesmp,打开kernel编译时的
rhel 5.5 下安装11gR2 Rac 的 Grid infrastructure 时关于ntp的一点强调
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
ssh 和secure crt 里看 /etc/hosts看168和l68,感觉还是secure crt的显示比ssh的显示要更明显一些,还是secure crt好。。。另外,ssh进行记录log时,有时候log会终止记录你敲入的命令,这样让人很不爽啊。[@more@]
oracleasm软件包的日志(log)路径
配置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