1、通过“MATERIALIZED”视图，监管远程数据变化，更新本地数据    a、创建数据库连接：    -- Drop existing database link &nb...

[root@rac1 桌面]# su - grid上一次登录：二 6月 14 09:46:51 CST 2016pts/0 上[grid@rac1 ~]$ asmcmdASMCMD> du    显示...

[root@rac1 桌面]# su - grid[grid@rac1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 13 10:23:48 2...

Oracle Restart enable database creation requries Default listener configured and running in Grid Infrastructure home，Use NE...

出现这种错误是因为主机名和/etc/hosts 文件不一致，只需要把主机名和其IP 写入/etc/hosts 文件。注意名字不能有下划线修改network 文件之外，再使用hostname 命令指定一下主机名，就不用重启OS了。1. 修改/etc...

CRS-4124: Oracle High Availability Services startup failed.CRS-4000: Command Start failed, or completed with errors.ohasd f...

Centos7 x86_64+oracle 11.2.0.4+asm(GI standalone)Running Oracle 11g root.sh script...The following environment variabl...

统计表空间总大小语法如下：SELECT TABLESPACE_NAME,SUM(TOTAL) TOTAL FROM TABLESPACE_TOTAL GROUP BY TABL...