ITPub博客

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...

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...

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 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 [ID 739618.1] Modified 10-APR-2011 Type PROBLEM Status PUBLISHED In this Document Symptoms Cause Solution...

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,...

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.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] Modified 14-MAY-2008 Type PROBLEM Status PUBLISHED In this Document Symptoms Cause Solution ...

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...

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...

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...

[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 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...

解决挂载旧硬盘后无法识别lvmvgscan    找到VolGroup00vgchange -a y VolGroup00 激活ex:[root@rac1 dev]# vgscan  Reading all physical volumes.  This may take a while...  /dev...

http://movie.yeshj.com/movie/32083/?page=1### http://www.douban.com/group/topic/5201806/

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文件的解压#gunzip 文件名.cpio.gz#cpio -idmv  <文件名.cpio-- cpio - copy files to and from archives

http://www.anysql.net/doc/upgrade10r2.html

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...