12 2023 档案
摘要:1.查看当前的虚拟机 C:\Users\Administrator>cd C:\Program Files\Oracle\VirtualBox C:\Program Files\Oracle\VirtualBox>VBoxManage.exe list vms "12C-rac01-ogg" {0f
阅读全文
摘要:环境:OS:Centos 7 1.想要对虚拟网卡virbr0网卡进行操作,首先要安装kvm虚拟化管理命令;yum -y install libvirt virt-install qemu-kvm2. 删除默认网络defaultvirsh net-destroy default 3. 取消定义网络de
阅读全文
摘要:环境: OS:Centos 7 虚拟机:virtual box 1.重新生成各网卡uuid[root@rac02 network-scripts]# uuidgen enp0s8854a8d63-52ba-4dcc-8131-1fb5d98e054a [root@rac02 network-scri
阅读全文
摘要:环境: OS:Centos 7 1.top查看wa很高 avg-cpu: %user %nice %system %iowait %steal %idle top - 08:45:04 up 722 days, 17:33, 1 user, load average: 3.28, 3.12, 3.0
阅读全文
摘要:建议目的端执行(源端也可以执行) rman target sys/oracle@tnsora11g_source auxiliary sys/oracle@tnsora11g_target run{ allocate channel prmy1 type disk; allocate channel
阅读全文
摘要:Oracle 数据库官方文档地址: http://docs.oracle.com/en/database/
阅读全文
摘要:[oracle@lenovo scripts]$ more check_db_block_corruption.sh #!/bin/bash ##source /etc/profile export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
阅读全文
摘要:环境:主库:win2012 server从库:centos 6db:11.2.0.4 1.主库上创建表空间 create tablespace tps_win01 logging datafile 'c:\oracle\app\oradata\win11g\tps_win01.dbf' size 5
阅读全文
摘要:环境:OS:Centos 7DB:12.2.0.1源库:2节点RAC目的库:单节点 1.源库创建表空间 create tablespace tps_test logging datafile '+DATA' size 50m autoextend on next 10m maxsize 2048m
阅读全文
摘要:1.查看更新列表https://support.oracle.com/knowledge/Oracle%20Cloud/2521164_1.html 2.各补丁下载地址查询入口https://support.oracle.com/epmos/faces/PatchHome?_adf.ctrl-sta
阅读全文
摘要:环境:OS:Centos 7DB:12.2.0.1 当Oracle ASM实例查找初始化参数文件时,会从GPnP profile文件中查找 获取spfile文件 [grid@rac01 ~]$ cd $ORACLE_HOME/gpnp/rac01/profiles/peer [grid@rac01
阅读全文