ITPub博客

alert日志报错： oracle:/opt/oracle/database/admin/ltdb/bdump>vi alert_ltdb1.log Wed May  8 20:21:37 2013Error 2068 trapped in 2PC on transaction 10.41.377599. Cleaning up.Error s...

asmcmd启动失败环境：redhat 5.5 64bit今天运行asmcmd -p遇到如下问题:oracle:/clusterware/oracle/crs/bin>asmcmd -pinstall_driver(Oracle) failed: Can't load '/oracle/product/10.2.0/db_1/perl/lib/site_per...

做测试环境数据库迁移的时候，遇到一个小问题。[oracle@public_test admin]$ sqlplus system/internal@UUP70_testSQL*Plus: Release 9.2.0.4.0 - Production on Wed Oct 31 14:18:13 2012Copyright (c) 1982, 2002...

[PRKC-1044:Failed to check remote command execution setup for lp21 using shells /usr/bin/sshand /usr/bin/rshlp21:connect refused]说明SSH配置还未完全通public hostname, private hostname都要通 s...

oracle 10g安装时参数校验，遇到提醒：英文提示如下： Checking Network Configuration requirements ... Check complete. The overall result of this check is: Not executed <<<< Recommendation: Oracle suppor...

从9i升级到10g后，数据库变得不稳定，每隔20小时左右，instance crash，重起数据库后，又暂时能正常运行。过一段时间又会crash，如此反复。问题的查找比较辛苦，初步感觉遇到了bug.查看alert日志，和trace文件：第...

primary加大redolog size:方法：新增500M的 logfile,drop 以前的logfilealter database add logfile group 5 ('/oradata/mon/redo05.log') size 500M;alter database add logfile group 6 ('/oradata/mon/redo06.lo...

操作系统版本： redhat 4update 7 64bit9.2.0.4升级到10.2.0.4升级过程中遇到的问题：运行升级脚本：SQL> spool /home/oracle/zhf/upgrade.logSQL>@?/rdbms/admin/catupgrd.sqlSpool off;升级脚本报错：118/44&nbs...

redo log 比较小，切换频率太高。且经常会checkpoint not completed加大redolog size:方法：新增500M的 logfile,drop 以前的logfilealter database add logfile group 5 ('/oradata/mon/redo05.log') size 500M;al...

--登录10R2数据库时报错：[oracle@mon admin]$ sqlplus /"as sysdba"SQL*Plus: Release 10.2.0.4.0 - Production on Sat May 26 13:12:07 2012Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.orac...

遇到2种情况Xmanager不能连接RedHat 1、使用xmanager 2.1登录linux red5.0使用xstart ssh /usr/X11R6/bin/xterm -ls -display $DISPLAY登录不行。提示bash: /usr/X11R6/bin/xterm: No such file or directory...

PROFILE的管理（资源文件）      当需要设置资源限制时，必须设置数据库系统启动参数RESOURCE_LIMIT，此参数默认值为FALSE      可以使用如下命令来启动当前资源...

数据库迁移到RAC环境的一个节点后，JOB不能正常执行。其中job中包含db link问题描述：job多次failure后，broken查找原因：以what=pr_paylog_today为例，在存储过程pr_paylog_today_test中记录错误日志：create ta...

Logged in as scott:scott@EDDEV> select * from v$mystat;select * from v$mystat              *ERROR at line 1:ORA-00942: table or view d...

***************问题描述：***************数据库无法打开SQL> desc v$datafile;ERROR:ORA-00604: error occurred at recursive SQL level 1ORA-01116: error in opening database file 1ORA-01110: data file 1: '/...

SYS远程连接出错ORA-01031:Insufficient privileges.现象：本地可以正常连接访问，在其它机器上也能通过normal方式正常访问使用，但是不能以sysdba身份连接访问，连接时报错ORA-01031:Insufficient privileges...

一、三种保护模式最大性能(maximize performance):这是data guard默认的保护模式。primay上的事务commit前不需要从standby上收到反馈信息，该模式在primary故障时可能丢失数据，但standby对primary的性能影响最小。...

在测试环境遇到了错误:ORA-01591: lock held by in-doubt distributed transaction执行:rollback force LOCAL_TRAN_ID;  后解决引文档如下:错误代码:ORA-01591错误原因:使用了分布式事务，造成这个问题的原...

By Saurabh Sood, July 3, 2009 12:42 pm There are situations when we see “temporary segments” in permanent tablespaces hanging around and not getting cleaned up.These temporary segments in p...

oracle@ebs ~]$ oerr ora 1440214402, 00000, "updating partition key column would cause a partition change"// *Cause:  An UPDATE statement attempted to change the value of a partition // &nbsp...