ITPub博客

ORA-04021错误分析[@more@]ORA-04021 等待锁定对象时超时。1.查找死锁的sessionselect b.sid,b.serial#,b.machine,b.terminal,b.program,b.process,b.status from v$lock a , v$session b where a.SID = b.SID得到死锁session的SID，SERIAL#2.杀掉sessionalter system kill session 'sid,serial#';

ORA-27100错误分析[@more@]今天由于对数据库摧残过度。。。所以遭到了ORACLE大哥的反抗。。。告诉我ORA-27100：shared memory realm already exists 一下就给我整麻了。。。数据库起不来了。。。ORA很生气，后果很严重。。。到网上一顿狂搜终于发现了解决办法。。。这个问题我个人认为是Spfile的损坏或者说是配置不当造成的。。。解决的步骤很简单。。。1。删除Spfile文件，默认是在ORACLE_HOME$的database目录下。2。重起一下机器，看有个帖子说UNIX下可以不用重起，但没有关于Windows的，我试了半天也没试出来。3。用pfile文件启动数据库

ORA-01950错误分析[@more@]    1.用户没有resource权限。     2.在修改了用户的表空间后，在用户中创建表时会出现以下的错误：ORA-01950: 表空间'HDNHG'中无权限     这个时候就要给修改了表空间的用户重新分配权限如：grant connect,resource to username;     再切换到该用户下创建表OK了。。     3.总的来说这个错误是由于对表空间操作的权限不足造成的,所以这个时候就可以检查出错之前对于所操作的表空间有哪些权限可能被revok

解答者：Md.Noor Alam [@more@]出处  http://www.orafaq.com/forum/mv/msg/38297/0/40/0/There is solution for TNS write packet failure error . follow these setps to resolve the issue1) Uninstall the TCP/IP2) Export the registry3) remove all the winsock entry from registry4) restart the PC5) install TCP/IP6) Try to connect to database if you get diffrent error (other than TNS write packet error ) then7) Uninstall and reinstall the SQLThis steps will resolve the TNS write packet failure error ..这

解答者：tolywang[@more@]在应用程序中插入oracle大字段的时候出现如下提示:ORA-01691: unable to extend lob segment xxx.SYS_LOB0000030895C00010$$ by 2048 in tablespace xxx ORA-06512: at "xxx.storeprocedure", line 86 ORA-06512: at line 1 ORA-01691 unable to extend lob segment string.string by string in tablespace stringCause: Failed to allocate an extent for LOB segment in tablespace.Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.Prob

 摘自：YCXW的博克 [@more@]原文地址： http://blog.csdn.net/ycxw/archive/2004/12/20/223324.aspx一 环境： 1 平台： HP,2G内存 windows 2k advServer sp3 + oracle 817 独占模式 2 内存分配相关参数 ..processes................=.350 ..shared_pool_size.........=.314572800..large_pool_size..........=.614400 ..java_pool_size...........=.0 ..db_block_buffers.........=.67372..db_block_size............=.16384 ..log_buffer...............=.163840 ..log_checkpoint_interval..=.10000 ..sort_area_size...........=.

作者:guoge[@more@]今天在对9i数据库做export时，出现如下错误：E:>exp system/manager file=backbill.dmp owner=backbillExport: Release 9.2.0.4.0 - Production on Thu Nov 18 14:42:11 2004Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.4.0 - ProductionExport done in US7ASCII character set and AL16UTF16 NCHAR character setAbout

摘自CSDN   主要解答者:lzp_lrp         提交人:zhangdatou[@more@]ORA-01090  shutdown  in  progress  -  connection  is  not  permitted   Cause:  The  SHUTDOWN  command  was  used  to  shut  down  a  running  Oracle  instance,  disallowing    any  connects  to  Oracle.     Action:  Wait  

解决办法未明确，可以点击链接做些参考。[@more@]http://www.itpub.net/showthread.php?s=&threadid=300963

ORA-07445错误分析[@more@]ORA-07445错误1:ORA-07445: exception encountered: core dump ORA-07445错误1->解决思路1oracle的BUG，在初始化文件里面设置参数event = "10262 trace name context forever, level 1024000"重启.ORA-07445错误2:ORA-07445: exception encountered: core dump [kkojnp()+15097] [SIGSEGV] [Address not mapped to object] [0x2] [] []ORA-07445错误2->解绝思路2解绝思路2->作者:xzh2000含row_number()的SQL产生03113/07445错误解决2法今天业务系统突然报了很多错,发现全是一个SQL产生的,这个

ORA-00205错误分析[@more@]Cause: The system could not find a controlfile of the specified name and size.Action: Check that ALL controlfiles are online and that they are the same files that the system created at cold start time.查看初始化参数里面指定的控制文件路径，系统找不到控制文件了！补充：http://blog.csdn.net/lunar2000/archive/2004/08/01/57707.aspx

作者:cn_chenfeng[@more@]ORACLE联机日志文件丢失或损坏的处理方法     选择自 cn_chenfeng 的 Blog  ORACLE联机日志文件丢失或损坏的处理方法     经验总结：联机日志分为当前联机日志和非当前联机日志，非当前联机日志的损坏是比较简单的，一般通过clear命令就可以解决问题。损坏非当前联机日志：1、启动数据库，遇到ORA-00312 or ORA-00313错误，如:ORA-00313: open failed for members of log group 4 of thread 1ORA-00312: online log 3 thread 1: '/opt/oracle/db04/oradata/ORCL/redo03.

http://www.itpub.net/296640.html[@more@]http://www.itpub.net/296640.html

suresh的意见！ [@more@]http://www.easywebtech.com/oracle/con_err.html ORA-12154: TNS:could not resolve service nameFirst open the tnsnames.ora file and check the settingseg-CHECK1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =CHECK2)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = CHECK3)))IN THE ABOVE GIVEN SCRIPTCHECK1---> Data Source Name u r Connecting from the front endCHECK2---> Server name to which u r connectingCHECK3---> Service name/SID of the Data base u r conn

ORA-00920错误分析[@more@]ora-00920 invalid relational operator 仔细检查你所写的SQL语句。

ORA-27123错误分析[@more@]编译内核，取消huge TBS这个选项，这是在linux2.6.x里面才会发生的，在2.4.x是没有问题的。 LINUX 內核參數SHMMAXSEMMSLSEMMNSSEMOPMSEMMNI要修改的SHMMAX=1/2RAMROOT用戶下ECHO 1234 >SHMMAX

ORA-00600错误分析[@more@]ORA-600大全http://dco-proxima.dco.pima.edu/oracle/bug/index/pr000512.htmORA-600错误1->解决思路ORA-00600: internal error code, arguments: [ksmovrflow], [kkznxddl.begin], [], [], [], [], [], []晚上测试实体化视图复制，测试环境中的master site是Oracle10g，MV site是Oracle9201，当在MV site上创建快速刷新的实体化视图时，报ORA-600错误。SQL> CREATE MATERIALIZED VIEW KAMUS.ACCOUNT2004 REFRESH FAST WITH PRIMARY KEY  AS SELECT * FROM   KAMUS.ACCOUNT2004@orcl;CREAT

http://blog.itpub.net/post/11/3772 本文作者：husthxd [@more@]本文作者：husthxd 通过sql跟踪解决ORA-00942错误一例通过sql跟踪解决ORA-00942错误一例  做完数据库移植后准备做应用程序的测试，应用程序登陆发现’表或视图不存在的错误’，该session出错后即disconnect，不能通过跟踪session来获取出错信息，应用程序开发商也不会提供源代码供分析，在这种情况下可以通过用alter system set sql_trace=true scope=memory;命令跟踪整个实例来获得必要的信息。设置跟踪后，重新登陆产生跟踪文件，用tkprof分析跟踪后，发现如下内容：

http://blog.itpub.net/post/11/4616 本文作者：husthxd [@more@]本文作者：husthxd ORACLE Bug导致的ORA-04031: BUG Description Workaround Fixed <Bug:1397603> ORA-4031 / SGA memory leak of PERMANENT memory occurs for buffer handles. _db_handles_cached = 0 8172, 901 <Bug:1640583> ORA-4031 due to leak / cache buffer chain contention from AND-EQUAL access  Not available 8171, 901  Bug:1318267      Not Public INSERT AS SELECT statements may not be shared when they

http://blog.itpub.net/post/330/2618 [@more@]http://blog.itpub.net/post/330/2618