http://www.orafaq.com/forum/t/21725/0/http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:588223421081Move doesnt support Long datatypes.You can either convert them to LOBs and t

问题描述主库DGDB:在非指定的目录创建表空间。从库DGDBST:则从库报错，MRP进程死掉。主库操作：create tablespace DGTSDATA datafile '/prod/oracle/oradata/DGDB/DGTSDATA.ora' size 10M autoextend on next 2M maxsize 100M;    --成功create

ORA-12547之oracle执行文件权限问题问题描述1，oracle账户可以进行sqlplus / as sysdba --成功2，oracle帐户可以进行sqlplus tivolirz/tivolirz --成功3，oracle账户可以进行sqlplus tivolirz/tivolirz@BIPROD --成功4，dba组的其他帐号sqlplus / as sysdb

环境：Linux 5.5 x86-64 + Oracle 11.2.0.3 RACalert日志Tue Jul 16 13:02:41 2013ORA-1652: unable to extend temp segment by 16 in tablespace                 APPS_TS_MEDIAFri Jul 26 13:03:06 2013ORA-1

原service_names为hdb经过修改Oracle Servcie Name设置成hdb.oracle.sannet.net注意:此时必须global_names=true,global_name完整域名为hdb.oracle.sannet.net会导致em无法正常登录.需要重建em1,确认已经开启监听 lsnrctl start2,删除em(2步)  a,删除em配置

生产库QA环境：Windows 2008 R2 + Oracle 11.2.0.2 Standard Edition安装完毕CPUJan2013（Patch23）之后，出现DB Control无法启动，其实正常的情况下，数据库补丁安装完毕，不会影响该服务。自动起报错如下：手动起报错如下：emctl start dbconsoleStarting Orac

10G DG 无法与主库进行数据库同步,归档日志已经传送过来,但无法启用MRP,所以主库的新数据无法同步.在备库手动启用MRP,alter日志提示有日志出现异常.SQL>recover managed standby database disconnect from session;Mon Jan 16 16:31:39 CST 2012ALTER DATABASE RECOVER

安装好CRS,Database,配置好Listener后,创建ASM实例,发现无法识别oracleasm创建的ASM卷DATA1,DATA2.查看/u01/app/oracle/admin/+ASM/bdump/alert_+ASM2.logTue Feb  7 21:16:18 2012Starting ORACLE instance (normal)Cannot determi

备份日志及删除步骤如下(在节点vmrac1上操作):a.RMAN> backup database plus archivelog;(完成成功的全备)Starting backup at 04-JAN-12current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archive log ba

Oracle 10g RAC的ASM实例有时需要通过第三方的客户端工具去连接，或者监控，但默认

故障描述a, Oracle 11.2.3 + Linux 6.2b,

错误日志 2013-0912 16:20:00 ###############alert_prod1.log###############Thu Sep 12 16:19:17 2013NOTE: ASMB terminatingErrors in file /prod/oracle/diag/rdbms/prod/prod2/trace/prod2_asmb_26138.trc:O

RMAN对进行数据库改名恢复的时候，报告ORA-19906: recovery target incarnation changed during recovery问题描述q1ebsdb.imc.com | TEST | /home/oratest > sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri J

在vmware workstation 8.0上安装Clusterware到最后第二步,出现了OCR不一致的情况.ERROR:OCR integrity results are inconsistent amongst the nodes.错误的检查状态如下[oracle@vmrac3 ~]$ ocrcheckStatus of Oracle Cluster Registry

主库alert日志Sat Aug 11 06:19:59 2012Errors in file /export/home/oracle/admin/SAMP/bdump/samp1_arc1_14945.trc:ORA-16401: archivelog rejected by RFS跟踪文件Oracle Database 10g Enterprise Edition Release 10

RMAN-08137: WARNING: archive log not deleted as it is still needed备份时出现下面这个错误需要考虑:Stream,Dataguard等在正在或还未使用归档日志的配置,记录一下.RMAN> backup full tag 'FULL' database2> include current controlfile format

记录一下ora-00600[1265]的bug环境:SunOS 64bit 10.2.0.4.0 RACalter记录Wed Aug 22 22:00:11 2012Errors in file /export/home/oracle/admin/VISDB/udump/visdb1_ora_23964.trc:ORA-00600: internal error code, argum

alert_ASM2.logWed Sep 05 03:32:56 2012IPC Send timeout detected.Sender: ospid 13720Receiver: inst 1 binc 22497 ospid 1431IPC Send timeout to 1.1 inc 56 for msg type 65518 from opid 10Wed Sep 05

记录一下ora-00600[17182]的bug环境:SunOS 64bit 10.2.0.4.0 RACalter记录Fri Aug 24 17:55:21 2012Errors in file /export/home/oracle/admin/SAMP/udump/samp3_ora_28722.trc:ORA-00600: internal error code, argume

ORA-609 - opiodr aborting process unknown ospid (18874448) as a result of ORA-609alert.log, trace, listener.log 日志# alert_wind.logThu Dec 20 08:51:32 2012*************************************

生产环境：AIX6.1-64 + Oracle11.2.0.2问题描述：当安装补丁后relink出现告警如下信息。WARNING:OUI-67215:...INFO:Start invoking 'make' at Sat Jun 01 15:14:50 CST 2013Sat Jun 01 15:14:50 CST 2013INFO:Finish invoking 'make'

https://support.oracle.com/CSP/main/article?cmd=show&type=BUG&id=6449148Bug 6449148: RMAN BACKUP WITH COMPRESSION FAILS ORA-19588 PROBLEM:--------Customer is attempting to backup archivelogs

环境：AIX64+Oracle11.2.2问题：ORA-04031Thu Jul 25 15:01:41 2013Errors in file /oracle/diag/rdbms/wind/wind/trace/wind_p046_23659006.trc (incident=216835):ORA-04031: unable to allocate 2048024 bytes o

Oracle Patch的分类a,临时补丁interim patch  该补丁也称一次性补丁one-off patch,是Oracle针对特定的bug而发行的临时补丁.  参见官方文档:http://docs.oracle.com/cd/B19306_01/em.102/b16227/oui8_opatch.htm#sthref448b,CPU(Critical Patch Upd