ArcerZhang`s Technology Blog

摘要： 实验目的：实验数据库数据移植实验环境： 源数据库:两个节点的RAC数据库，数据库版本11203 目标数据库：单实例数据库，版本11203要求：源数据库schema所在表空间为USERS,移植到目标数据库后调整为新表空间APP_FGPS1、实验准备 1.1、倒出数据库[oracle@rac1 mydump]$ expdp ARCER/ARCER dumpfile=fgps.dmp directory=dmp_dir logfile=fgps.log Export: Release 11.2.0.1.0 - Production on Tue Jul 9 15:31:31 2013Copyr... 阅读全文

摘要： 参考视频:[bbk4992]袁宝华 第十二章 - 数据移植实验步骤:1、test user---create table --- emp12、test user---create index --- emp13、create direcotry --- test_dir --- grant4、show directory5、expdp --- emp1expdp test/test DUMPFILE=emp1.dmp DIRECTORY=test_dir tables=emp1 logfile=emp1.logView Code 6、man-made destroy accidentsdrop 阅读全文

摘要： ORA-39006: internal error ORA-39068: invalid master table data in row with PROCESS_ORDER=-3 ORA-01658:unable to create INITIAL extent for segment in tablespace CC_TBLSPORA-39097: Data Pump job encountered unexpected error -1658導出數據時，DATADUMP在導出schema下創建並使用默認名'SYS_EXPORT_SCHEMA_01’作為JOB名。在導出數據之前， 阅读全文

摘要： http://www.cnblogs.com/killkill/archive/2010/12/20/1911172.html以上语句有可能会遇到如下错误：?1234alter database commit to switchover to physical standby*ERROR at line 1:ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected 这是由于一些连接还没有释放所致的，将前端应用关闭后如果还出现这种情况，可以用以下语句确认一下有哪些连接： 阅读全文

摘要： 1、查看磁盘情况[root@11gdg ~]# fdisk -lDisk /dev/sda: 21.5 GB, 21474836480 bytes255 heads, 63 sectors/track, 2610 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesSector size (logical/physical): 512 bytes / 512 bytesI/O size (minimum/optimal): 512 bytes / 512 bytesDisk identifier: 0x00078a4a Devi.. 阅读全文

摘要： http://www.it165.net/os/html/201206/2436.html 阅读全文

摘要： 执行/runcluvfy.sh stage -pre crsinst -n 11grac1,11grac2 -fixup -verbose出错误点：Checking consistency of file "/etc/resolv.conf" across nodesChecking the file "/etc/resolv.conf" to make sure only one of domain and search entries is definedFile "/etc/resolv.conf" does not have 阅读全文

摘要： PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 16191.Fri Jul 05 14:18:27 2013Error 1031 received logging on to the standbyPING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.Fri Jul 05 14:22:09 2013在解决这个问题的时候，尝试过很多办法；老师讲的，网上查的；都不管用；后来自己摸索出了 阅读全文

摘要： Repository base is listed more than once in the configurationRepository updates is listed more than once in the configurationRepository addons is listed more than once in the configurationRepository extras is listed more than once in the configurationRepository centosplus is listed more than once in 阅读全文

摘要： 1、概述和说明单实例数据库.只需安装grid、oracle software、不需要安装oracle database.2、安装前准备工作preusers.sh#!/usr/bin/bashgroupadd -g 1000 oinstallgroupadd -g 1200 asmadmingroupadd -g 1201 asmdbagroupadd -g 1202 asmopergroupadd -g 1300 dbagroupadd -g 1301 operuseradd -u 1100 -g oinstall -G dba,asmadmin,asmdba,asmoper -d /home 阅读全文