ITPub博客

  上次遇到一个案例：在客户现场11.2.0.4版本运行utlrp.sql 编译脚本时，出现以下错误:ORA-12801: error signaled in parallel query server P237ORA-12853: insufficient memory for PX buffers: current 84352K, max needed 13280400KORA-04031: unable to allocate 65560 bytes of shared memory (“large poo...

Invisible Columns in Oracle Database 12cIntroductionIn Oracle Database 12c, table columns can be defined as invisible either during its creation with the CREATE TABLE command or by modifying existing table columns via the ALTER TABLE statement. By default, table columns are always visi...

SQL> CREATE TABLESPACE test DATAFILE '/bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/oradata/T12cB3/test.dbf' SIZE 50MEXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO;  2    3Tablespace created.SQL> select file_name, status, online_status from dba_data_files;FILE_NA...

下面是一个例子% rman target sys/oracle@t12ccdb log recover_table5.log RMAN> RECOVER TABLE SMEDS."RECTEST" OF PLUGGABLE DATABASE T12CPDB1          UNTIL SEQUENCE 64 thread 1          AUXILIARY DESTINAT...

我们在装好oracle 11GR2 grid集群时，可以去查看设置好的网络配置信息，比如公网和私网配置等用oifcfg getif显示如下:en4  192.168.0.0  global  cluster_interconnecten5  192.169.0.0  global  cluster_interconnecten6  100.100.32.0  globa...

oracle 11.2.0.3 adg 做完switch over后，处理备库时，这个时候备库数据库相关系统进程还在的<br />需要shutdown immediate,然后再启用到mount状态，恢复日志模式<br /><br />而在<br />oracle 11.2.0.4 adg 做完switch over后，处理备库时，这个时候备库数据库相关系统进程是没有的<br />不需要再运行shutdown immedi...

环境 adg+ogg&nbsp; 数据库版本 11.2.0.4&nbsp; ogg版本 <span style="color:#1F497D;" lang="EN-US">11.2.1.0.27</span><br />1:主库 配置有ogg，有抽取进程<br />2: 备库 adg<br /><br />目标：<br />&nbsp; 测试 adg switch over对ogg数据同步有没影响<br /><br />测试如下:<br /><p style="text-indent:20.0000...

<h3 class="sect2">Deprecation of Non-CDB Architecture</h3><p>The non-CDB architecture is deprecated in Oracle Database 12<span class="italic">c</span>, and may be desupported and unavailable in a release after Oracle Database 12<span class="italic">c</span> Release 2. Oracle recommends use of ...

&nbsp; 以下更改监听默认端口只针对11gR2 grid rac环境<br />1:&nbsp;srvctl config listener<br /><br /><br />&nbsp;&nbsp;&nbsp; 如要改成1529<br />2:srvctl modify listener -l LISTENER -p "TCP:&lt;new-listener-port&gt;"<br />&nbsp;&nbsp; <br />&nbsp;&nbsp; srvctl modify listener -l LISTENER -p "TCP...

To modify SCAN listener port<br /><br />As grid user:<br /><br />1. Modify SCAN listener port:<br /><br />$GRID_HOME/bin/srvctl modify scan_listener -p &lt;new-SCAN-port&gt;<br /><br />Update 11gR2 database init.ora parameter: alter system set remote_listener='&lt;SCAN-name&gt;:&lt;new-port-...

<span style="color:#000000;font-family:微软雅黑, 'MS Sans Serif', sans-serif;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:auto;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:auto;word-spacing:...

<span id="kmPgTpl:r1:0:ol22" class="xq" style="font-weight:bold;color:Black;font-size:130%;">Row Movement Common Questions and Problems on Partitioned Tables<br /><span id="kmPgTpl:r1:ot71" class="kmContent" style="font-size:small;color:Black;"><h3 class="km">1. What is Row Movement?</h3><p>...

<span id="kmPgTpl:r1:ot71" class="kmContent" style="font-size:small;color:Black;"><div class="kmcodeblock" style="width:95%;"><p>以下这些视图都会记录&nbsp; <span id="kmPgTpl:r1:ot71" class="kmContent" style="font-size:small;color:Black;">pins/locks</span><br />DBA_KGLLOCK : one row for each l...

环境： IBM AIX<br /><br />SQL&gt; startup<br />ORA-27125: unable to create shared memory segment<br />IBM AIX RISC System/6000 Error: 1: Not owner<br /><br />经检查是与设置lock_sga=true有关，改为false就可以解决这个问题<br /><br />以下是设置为true的解决方法：<br />&nbsp;&nbsp;&nbsp; Set v_pi...

&nbsp; <br />&nbsp;&nbsp;&nbsp; 在oracle 12c 搭建adg要注意密码文件的存放方式，<br /><br />&nbsp;&nbsp; 如果是密码文件存放在asm磁盘组中，则一定要asmcmd pwcopy 命令拷贝密码文件到备库<br /><br /><br />以下是文档说明<p style="box-sizing:border-box;margin-right:0px;margin-bottom:1.25rem;margin-lef...

安装环境oracle 12.1.0.2 + aix 7.1 在做安装检查时，提示以下报错ERROR: PRVE-10167 : I/O Completion Ports (IOCP) device status did not match the required value on node "tst12cdb2". [Expected = "Available"; Found = "Defined"] PRVE-10167 : I/O Completion Ports (IOCP) device status did not match t...

目前研究方向oracle big data

  今天在笔记本电脑上安装一套 oracle 11g for windows 数据库创建监听时提示 未能创建监听服务，创建数据库也是提示DIM-00014 Cannot open the Windows NT Service ControlManagerO/S-Error: (OS 5) 拒绝访问通过检查发现我是用administrator创建的用户来运行的，虽然都属于administrator和ora-dba组但创建...

oracle 12c 支持级联 standby dataguard