-
编辑 删除
How to change IP of machine running Oracle GI
#@# Check the config of crs and disable itdb-ora1:/#/oracrs/product/11gR2/grid/bin/crsctl config crs; -- Run with Root on One NodesCRS-4622: Oracle High Availability Services autostart is enabled.db-ora1:/#/oracrs/product/11gR2/grid/bin/crsctl disable crs; -- Run w...
-
编辑 删除
如何在Linux中使用rawdevice(裸设备)---入门级
声明： 此文仅仅只是为了方便初学者理解rawdevice的使用过程，请勿用于生产环境。// 查看当前lv的配置情况[root@projectm rules.d]# lvs LV VG Attr LSize Origin Snap% Move Log Copy...
-
编辑 删除
How to purge recycle bin
If you decide that you are never going to restore an item from the recycle bin, you canuse the PURGE statement to remove the items and their associated objects from therecycle bin and release their storage space. You need the same privileges as if you weredro...
-
编辑 删除
Oracle 12c GI v$asm_diskgroup returns no row
The Problem: After Oracle 12c GI and DB having been installed, I execute dbca with oracle user. When I try to choose ASM DG, it returned an empty diskgroups list. All the status of \CRS resource is online.Diagnostic:Check status of diskgroupSQL> selec...
-
编辑 删除
手工建库所需要执行的脚本
SQL> conn / as sysdbaSQL> @?/rdbms/admin/catalog.sql ; -- 数据字典视图SQL> @?/rdbms/admin/catproc.sql ; -- 存储过程包）SQL> @?/rdbms/admin/catblock.sql ; -- 锁相关的视图SQL> @?/rdbms/admin/catoctk.sql ; ...
-
编辑 删除
ORA-01555: Snapshot too old
Ahh, the infamous "Snapshot too old - Rooback segment too small" error. While this problem cannot be elimated, it's occurrence can be minimized. You have to remember that Oracle is designed to present a 'read-consistent' view of the data as it existed at the time a query was issued. Sce...
-
编辑 删除
Cleaning up huge crfclust.bdb in Grid home
Details: Problem: The Home directory of User grid become hugePath: /app/oracle/11.2.0.4/grid/crf/db/db-node01Key Word: CRF --> CHM(Cluster Health Monitor)Files: one *...
-
编辑 删除
About A Migration Using DataPump
Source Server: local-ip: 10.10.10.11,10.10.10.12 virt-ip: 10.10.10.13,10.10.10.14 scan-ip: 10.10.10.15 DB: db-rac01, db-rac02 Running Oracle GI, DB 11.2.0.4 on AIX 6.1L Schemas: 'FJZKXT','FJZP','LOTTERY','FJYDIM','FJIHOME','SECKILL','FJYDWSC' Target Sever: local-ip: 10.10.10.21,10.10.10.22 virt-ip: 10.10.10.23,10.10.10.24 scan-ip: 10.10.10.25 DB: db-rac
-
编辑 删除
关于手工建库中『set default bigfile tablespace』的思考
开门见山： 一次偶然的机会看到以下语句： CREATE DATABASE ORCL USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle SET DEFA...
