- 博客(11)
- 收藏
- 关注
原创 rename diskgroup name
概述:数据库没有开启归档,当前环境12.1。votedg(normal)迁移到dg_vote(external),把votedg下的磁盘添加到dg_vote中,并干掉votedg因为只创建了votedg磁盘组,cdb,pdb也创建在上面,过程还是比较复杂,因为数据库很多文件都放在votedg上,不同的文件有不同的迁移方式。迁移目标:数据文件,临时数据文件,undo,redo,密码文件(as...
2018-11-22 14:35:59 550
原创 12c新特性——密码文件的管理
当前环境12.1.0.2。12c中asm和db密码文件都放在了asm中管理。11g的db密码文件在本地。pwmove移动asm密码文件时成功ASMCMD> pwmove --asm +VOTEDG/orapwasm +DG_VOTE/orapwasmmoving +VOTEDG/orapwasm -> +DG_VOTE/orapwasm pwmove db密码文件...
2018-11-21 15:35:35 1938
原创 迁移控制文件,redo file,tempfile
$ ls (全在软件目录下面/u01,没有在数据盘下面/oradata)control01.ctl redo01.log redo02.log redo03.log temp01.dbf /u01空间不够,计划迁移 redo,control,temp文件到/oradata下/dev/oracle_lv 16.00 0.53 97% ...
2018-11-20 11:29:12 351
原创 一次导入hang住的处理记录--statement suspended
Tue Nov 20 04:37:47 2018statement in resumable session 'SYS.SYS_IMPORT_SCHEMA_06.1' was suspended due to ORA-01652: unable to extend temp segment by 128 in tablespace TEMP告警日志报错如上。...
2018-11-20 10:15:08 417
原创 RAC 12.1 静默安装手册--linux7.5
此篇相当于是我的安装记录,也是我的安装手册以前总是装库总是零零散散的,word,官方文档搜来搜去,还是写成txt,还是txt好!1.#vi /etc/sysconfig/network --linux6上#NETWORKING=yes#HOSTNAME=test12c1vi /etc/hostname linux7上hostname test12c1vi /etc/...
2018-11-19 15:15:10 624
原创 [WARNING] - My Oracle Support Username/Email Address Not Specified
./runInstaller静默安装12c db软件时报错如下[oracle@test12c1 database]$ tail -f nohup.outStarting Oracle Universal Installer...Checking Temp space: must be greater than 500 MB. Actual 9367 MB PassedChec...
2018-11-19 11:24:13 6377
原创 PRKC-1024 : Invalid netmask
gi静默安装过程中报错,vip安装失败2018/11/15 16:45:37 CLSRSC-343: Successfully started Oracle Clusterware stackPRKC-1024 : Invalid netmask: ens1922018/11/15 16:45:49 CLSRSC-180: An error occurred while executin...
2018-11-15 18:15:16 1468 1
原创 INS-41812:OSOPER and OSASM are the same
[grid@test12c1 grid]$ ./runInstaller -responseFile /oracle/soft/grid/response/grid_install.rsp -silent -ignorePrereq -showProgressStarting Oracle Universal Installer...Checking Temp space: must be ...
2018-11-14 14:42:34 556
原创 EXP-00002 EXP-00000 compress压缩比惊人
exp报错如下:EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00...
2018-11-12 15:18:08 588
原创 expdp:ORA-31693 ORA-29913 ORA-29275
expdp报错:ORA-31693: Table data object "LZL"."TAB1" failed to load/unload and is being skipped due to error:ORA-29913: error in executing ODCIEXTTABLEPOPULATE calloutORA-29275: partial multibyte c...
2018-11-12 14:29:22 3264
原创 impdp遇到ORA-02374 ORA-12899 ORA-02372
impdp导入时遇到报错ORA-02374: conversion error loading table "UCR_PARAM"."SEC_OP_AUTHOR_ATTACH"ORA-12899: value too large for column GRANT_TYPE (actual: 3, maximum: 1)ORA-02372: data for row: GRANT_TYPE...
2018-11-12 10:14:15 9147
事务的历史与SSI-PostgreSQL数据库技术峰会成都站分享
2023-06-21
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人