好了，ORACLE问当中就要求这么多参数，但是还有一个参数你要是不调会走弯路的，那就是： maxdsiz ，含义为Max Data Segment Size For 32-bit Processes (Bytes)。至于maxdsiz_64bit 要不要调，随你了，因为它的DEFAULT值正好是1G。 maxdsiz 67108864 / 280000000 （建议不要低于256M） maxdsiz_64bit 1073741824 / 1200000000 （建议不要低于1G，也就是DEFAULT值） 如果你不调MAXDSIZ，安装完成后作连接就会出现下面的错误： Error...
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso...
[oracle@pie bin]$ make -f $ORACLE_HOME/ctx/lib/ins_ctx.mk install gcc -o ctxload -L/opt/ora9/product/9.2/ctx/lib/ -L/opt/ora9/product/9.2/lib/ -L/opt/ora9/product/9.2/lib/stubs/ -o ctxload -L/opt/ora9/product/9.2/ctx/lib/ -L/opt/ora9/product/9.2/lib/ -L/opt/ora9/product/9.2/lib/stubs/ /opt/ora9/product/9.2/ctx/lib/sdrz.o -lctxs9 -lctx9 -lzx9 -lgx9 -lctx9 -lzx9 -lgx9 /opt/ora9/product/9.2/rdbms/li...
$ isql -Usa -P -i ins_syn_sql 这个命令运行完以后就提示如下啦： :em02: 发现错误了： Msg 1105, Level 17, State 1: Procedure ' sp_syntax', line 220: can't allocate space for object 'sysprocedures' in database 'master' because the 'system' segment is full. if you ran out of space in syslogs, dump the transaction log. otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the ...
As we all know, the *INLR must be set on in order to shut down a program. That does not necessarily mean the program must terminate. Or, in other words, that the program must close all its files and release itself from memory. If you have a program that is used often in the call stack, for performance reasons you may wish to keep the program "hot" or active. You may have a central work with styl...
最近在在搭建一个oracle 11gR2的环境，Oracle版本是11.2.0.2，在vSphere 5.0之上的Windows Server 2008 R上安装，安装之前的先决条件检查都通过。从starting网格基础结构配置开始，都失败了，消息提示： [ins-20802] 网格基础结构配置失败，详细资料里面似乎也没什么有用的参考。 在安装过程中，因为需要Windows AD域，所以将两个节点的Windows 2008都配置成AD域控制器，DNS指向节点1.在DNS中添加了公网地址，私网地址，虚拟地址和...
Setting up Oracle Golden Gate between 2 Oracle instances (asynchronous)
By itkunn
Quick installation guide.
Oracle GoldenGate version is 10.4 for RHEL 5 and Oracle Databases version is 10.2.0.3 (unpatched 10.2 because our live DB has the same patchlevel)
Requirements:
2 databases GGSRC (source) and GGDEST (destination)
Identical schemas in databases we want to r...
