11 2018 档案
摘要:CRS-4664: Node acdg successfully pinned.Adding Clusterware entries to inittabohasd failed to startFailed to start the Clusterware. Last 20 lines of th
阅读全文
摘要:解决办法 在makefile中添加链接libnnz11库的参数 修改$ORACLE_HOME/sysman/lib/ins_emagent.mk,将 $(MK_EMAGENT_NMECTL)修改为:$(MK_EMAGENT_NMECTL) -lnnz11 建议修改前备份原始文件 [oracle@ys
阅读全文
摘要:truncate table test reuse storage;alter table test deallocate unused keep 100G;alter table test deallocate unused keep 80G;alter table test deallocate
阅读全文
摘要:select * from (select * from (select * from (select u.name owner, o.name table_name, null partition_name, null subpartition_name, m.inserts, m.updates
阅读全文
摘要:执行计划 SQL> grant dba to scott; Grant succeeded. SQL> conn scott/scott Connected. 创建测试表test SQL> create table test as select * fromdba_objects; Table cr
阅读全文
摘要:一、修改系统相关参数 1.修改主机名 vi /etc/hostname 临时方案 hostname rac1 2.关闭防火墙:systemctl status firewalldsystemctl stop firewalldsystemctl disable firewalld 3.关闭 seli
阅读全文