PARALLEL_EXECUTION_MESSAGE_SIZE
PARALLEL_EXECUTION_MESSAGE_SIZE specifies the size of messages for parallel execution (formerly referred to as parallel query, PDML, Parallel Recovery, replication).On most platforms, the d...
some suggestions for rac performance
1. If possible, please use CACHE + NOORDER for sequences on RAC:This setting has the least performance impact on RAC, and it is the default when creating a new sequence wihtout options. Each...
ORA-01931: cannot grant UNLIMITED TABLESPACE to a role on 10g
SQL> grant unlimited tablespace to dba_role;grant unlimited tablespace to dba_role*ERROR at line 1:ORA-01931: cannot grant UNLIMITED TABLESPACE to a roleThe Error ORA-01931: cannot grant UNLIM...
RMAN-06094 Datafile does not exist
RMAN-06094 Datafile does not exist Applies to:oracle server version 10.2.0.2 and later.Symptomeswhen trying to recover the database from an incremental backup,the following error is encounted.Star...
MRP0: Background Media Recovery terminated with error 1274
MRP0: Background Media Recovery terminated with error 1274 [ID 739618.1] Modified 10-APR-2011 Type PROBLEM Status PUBLISHED In this Document Symptoms Cause Solution...
set up a standby quickly by duplicate.
set up a standby quickly by duplicate.1.Create an Oracle Password File for the Auxiliary InstancePassword of user sys must be the same as primary side,so i copy the password file from primary,...
how to mount diskgroup automatically
edit pfile and append an entry like *.asm_diskgroups='DG01'startup asm by spfilecreate spfile from pfile='/dms01/app/oracle/dbs/init+ASM2.ora';srvctl start asm -n dms01done.
alias doesn't work on solaris
alias doesn't work on solaris.solaris10 use shell sh default,so alias doesn't work.we can change the shell to bash by edit /etc/passwd to make it effect.like :oracle:x:100:101::/dms01/app:/bin...
ORA-00600 [Kfgfinalize_2] While Mounting Diskgroups In Rac [ID 418063.1]
ORA-00600 [Kfgfinalize_2] While Mounting Diskgroups In Rac [ID 418063.1] Modified 14-MAY-2008 Type PROBLEM Status PUBLISHED In this Document Symptoms Cause Solution ...
rac installation on Solaris10 x86-64
Oracle Clusterware and Oracle Real Application ClustersInstallation Guide10g Release 2 (10.2) for Solaris10 x86-64 Operating System#In this article I'll describe the installation of Oracle Clusterware...
How I Resolved Performance Issues After Upgrading from 9i to 10g
In my previous organization, after upgrading the databases from Oracle 9i to 10g, we had a few performance issues. In Oracle 9i, some Queries used to give full reasults in few minutes but th...
xxxx
http://www.en8848.com.cn/yingyu/38/n-77238.html http://bbs.for68.com/forum-264-242/topic-354277.html http://www.enbaike.cn/view/13108.html http://www.ryedu.net/syy/hyyy/200805/707...
migrate
[root@rac1 ~]# uname -aLinux rac1 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:39:47 EDT 2008 i686 i686 i386 GNU/Linux[root@rac1 ~]# echo $HOSTTYPEi386SQL> archive log list;Database log mode &...
oracle db setting auto-bringup
oracle 9i db setting auto-bringup$ vi /etc/oratab *:/uxdb/ora9i/product/9.2:Nora9i:/uxdb/ora9i/product/9.2:Y--indicates database would be bought up at system boot time.[oracle@rac1 lib]$ dbstartDataba...
linux 激活vg
解决挂载旧硬盘后无法识别lvmvgscan 找到VolGroup00vgchange -a y VolGroup00 激活ex:[root@rac1 dev]# vgscan Reading all physical volumes. This may take a while... /dev...
xxx
http://movie.yeshj.com/movie/32083/?page=1### http://www.douban.com/group/topic/5201806/
oracle9i installation
installation environment[root@rac1 ~]# uname -aLinux rac1 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:39:47 EDT 2008 i686 i686 i386 GNU/Linux# User specific environment and startup programsPATH=$PATH:$HOME/b...
linux下.cpio.gz文件的解压
linux下.cpio.gz文件的解压#gunzip 文件名.cpio.gz#cpio -idmv <文件名.cpio-- cpio - copy files to and from archives
upgrade
http://www.anysql.net/doc/upgrade10r2.html
patch系列
Oracle Interim patches: A patch that is applied in between patchset releases with the Opatch utility. Interim patches are sometimes also referred to as patchset exceptions.Oracle Merge patch...