查询频繁commit的SQL语句: set linesize 1000 column sid format 99999 column program format a20 column machine format a20 column logon_time format date column wait_class format a10 colu…
安装Oracle19c RAC执行runcluvfy.sh验证报错: [grid@server01 grid]$ ./runcluvfy.sh stage -pre crsinst -n server01,server02 -method root Verifying User Equivalence ...FAILED server02: PRV…
DNS服务器安装与配置 一、配置YUM [root@dns ~]# mkdir /opt/yum [root@dns ~]# cp -r /run/media/admin/CentOS\ 7\ x86_64/* /opt/yum/ [root@dns ~]# cat > /etc/yum.repos.d/CentOS-Base.repo &l…
SQL> drop diskgroup data including contents; drop diskgroup data including contents * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-15073: diskgroup DATA is mounted by…
Oracle PSU/CPU/RU补丁下载 1.Opatch 登录support.orcle.com或者直接打开 https://updates.oracle.com/download/6880880.html 或搜索Document 293369.1 2.常用补丁下载 Quick Reference to Patch Numbers for Da…
批量杀Oracle进程 Linux系统下杀进程: ps -ef|grep LOCAL=NO|grep -v grep|grep ORACLE_SID |cut -c 9-15|xargs kill -9 ps -ef|grep LOCAL=NO | grep -v grep|grep ORACLE_SID | awk '{print $2…
Oracle19c (Active) Data Guard 安装 一、DataGuard概述 1.Primary Database An Oracle Data Guard configuration contains one production database, also referred to as the primary database…
expdp导出数据慢的问题 Oracle11g生产库遇到expdp导出数据非常慢,通过AWR报告查看等待事件:Streams AQ: enqueue blocked on low memory Expdp and event ‘Streams AQ: enqueue blocked on low memory’Categories:OracleOu…
这篇文章受密码保护,输入密码才能阅读
Oracle12c安装 安装前介质准备 软件 版本 安装包 Centos 7.6 CentOS-7-x86_64-DVD-1810.iso Oracle12c 12.2.0.1 linuxx64_12201_database.zip Rlwrap 0.37 rlwrap-0.37-1.el6.x86_64.rpm 一、关闭防火墙 systemctl…