随笔分类 - oracle
摘要：环境： OS:Centos 6.9 db:11.2.0.4 ogg:21C 1.解压su - oracleunzip -d <PATCH_TOP_DIR> p17030189_112040_Generic.zip 2.检查是否有冲突 [oracle@localhost 17030189]$cd <P
阅读全文
摘要：环境: OS:Centos 7 DB:21C 导出报错 expdp c##goldengate/goldengate@tnspdb1 tables=hxl.tb_test dumpfile=tb_test.dmp FLASHBACK_SCN=4990304 parallel=5 directory=
阅读全文
摘要：环境OS:Centos 6.9ogg版本:21C 问题 [oracle@localhost goldengate21c]$ ./ggsci ./ggsci: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /goldenga
阅读全文
摘要：环境:OS:Centos 6.9DB:11.2.0.4 前提条件:1.新库的ORACLE_HOME、ORACLE_BASE环境变量跟原库保持一致2.新库需要创建好oralce账号和相应的组3.新库安装好相应的系统补丁和环境 1.检查Oracle补丁状态 [oracle@localhost 19023
阅读全文
摘要：环境: OS:Centos 7 客户端:11.2.0.4 1.下载客户端的包[root@localhost 11g_client]# ls -1oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpmoracle-instantclient11.2
阅读全文
摘要：环境:OS:Centos 7DB:19.3.0.0 1. 备份profile.xml从Oracle 11.2 GI开始，私有网络配置不仅仅存在ocr中，还存在gpnp profile中，所以首先需要备份profile.xml两个节点都要进行备份[grid@rac01 peer]$ cd /u01/g
阅读全文
摘要：环境： DB:19.3.0.0 1.创建冗余磁盘组create diskgroup failtest normal redundancyfailgroup failg1 disk '/dev/mapper/testdisk01' name f1failgroup failg2 disk '/dev/
阅读全文
摘要：SQL> create diskgroup VOTEDISK normal redundancy 2 failgroup failvotedisk1 disk '/dev/mapper/votedisk' name fail1 3 failgroup failvotedisk2 disk '/dev
阅读全文
摘要：环境:OS:Centos 7db:19.3.0.0 --检查状态,在两个节点上执行[root@rac01 rules.d]# /u01/grid/grid_home/19.3.0.0/bin/tfactl status[root@rac02 rules.d]# /u01/grid/grid_home
阅读全文
摘要：环境:OS:Centos 7DB:19.3.0.0 2节点RAC 1.查看scan的配置信息[grid@rac01 ~]$ srvctl config scanSCAN name: rac-scan, Network: 1Subnet IPv4: 192.168.56.0/255.255.255.0
阅读全文
摘要：环境:OS:Centos 7DB:19.3.0.0 2节点组成的RAC 1.添加监听器在其中一个节点上操作su - grid[grid@rac01 ~]$ srvctl add listener -l mylistener -p 15222.查看添加的资源[grid@rac01 ~]$ crsctl
阅读全文
摘要：环境: OS:Centos 7 DB:19.3.0.0 1.获取ocr列表 asmcmd.sh #!/bin/bash asmcmd<<EOF ls -lt +OCR/rac-cluster/OCRBACKUP exit EOF 2.下载最新的ocr文件 download_ocr.sh #!/bin
阅读全文
摘要：环境: OS:Centos 7 DB:19.3.0.0 1.查看当前ocr的备份目录 [grid@rac01 ~]$ ocrconfig -showbackuplocThe Oracle Cluster Registry backup location is [+OCR]. 2.更改目录 [root
阅读全文
摘要：环境 DB:19.3.0.0 OS:Centos 7 1.查看当前的监听配置在其中一个节点上执行,我这里是在节点1上执行[grid@rac01 ~]$ srvctl config listener -l listenerName: LISTENERType: Database ListenerNet
阅读全文
摘要：环境: DB:19.3.0.0 在节点1上操作将rac01的vip漂移到rac02[grid@rac01 ~]$srvctl relocate vip -vip rac01 -node rac02 -f -v 这个时候rac01的vip已经漂移到了节点2 漂移回来(rac02漂移到rac01)[gr
阅读全文
摘要：从节点1漂移到节点2,这里的i参数是scan号,如scan1,scan2srvctl relocate scan -i 1 -n rac02 从节点2漂移到节点1srvctl relocate scan -i 1 -n rac01 [grid@rac01 ~]$ srvctl status scan
阅读全文
摘要：1.€ [oracle@lenovo sqlload]$ more tb_sqlload_test.ctl Load DATA INFILE '/tmp/tb_sqlload_test.txt' truncate into table tb_sqlload_test FIELDS TERMINATE
阅读全文
摘要：[oracle@lenovo sqlload]$ more data_info.ctl Load DATA INFILE '/tmp/data_info.txt' truncate into table data_info_varchar_sdr FIELDS TERMINATED BY "|" T
阅读全文
摘要：环境： OS:Centos 6 ogg:123014 ######################################ogg 12c for oracle########################################## 安装过程是在oracle账号下进行的。 1.将安
阅读全文
摘要：SQL> select client_name,status from dba_autotask_client; CLIENT_NAME STATUS auto optimizer stats collection ENABLEDauto space advisor ENABLEDsql tunin
阅读全文
浙公网安备 33010602011771号