CentOS平台Oracle11gR2静默安装及静默建库系统环境:CentOS6.3 mini x64准备工作:1.设置好网络,安装常用软件2.准备好Oracle安装文件说明:以“#”开头的命令是使用root身份执行的,以“$”开头的命令是使用oracle身份执行的。关闭selinux#vim /etc/selinux/config*************************************...【阅读全文】
Installing Oracle10g in the Windows:Environment Variables:$ORACLE_BASE$ORACLE_HOME$ORACLE_SID$ORACLE_HOME/install/portlist.ini ?-- All the ports for oracle including db control home page and isqlplus$ORACLE_HOME/Apache/Apache/port.ini -- for oracle9i体系结构:Database: ControlFiles...【阅读全文】
When loading objects and data into the buffer cache of the instance there is a functionality which determines the best way to load for full scans. This functionality is called smallness logic and is driven by a hidden parameter called:_small_table_threshold.If the number of blocks to be read is lowe【阅读全文】
SQL> alter system set aq_tm_processes=10 scope=both; 指定队列监视进程个数,默认值为0,最大值为10
SQL> alter system set open_cursors=500 scope=both; 开启游标数
SQL> alter sy【阅读全文】
在rdel 4上安装Oracle 10g基本上很简单,只有安装文档来就可以成功的安装。但是Centos5.8,因为没有想过文档,所以可能会遇到一些问题。1. 问题一:在执行 .runInstall 时,报错:Exception in thread "main" java.lang.UnsatisfiedLinkError:
/usr/java/j2sdk1.4.2_19/jre/lib/i386/libawt.so: libXtst.so.6: cannot
open shared object file: No such file or directory
【阅读全文】
You cannot export any schema that contains dictionary metadata. This is a
restriction of export process.Schemas that exclusively contain
dictionary objects like SYS, CTXSYS, MDSYS and ORDSYS are never exported nor
imported. This is because these schemas are created when you install the related【阅读全文】