ITPub博客

ORA-00600: internal error code, arguments: [kkocxj : pjpCtx], [], [], [], [], [], [], [] SymptomsORA-00600 [kkocxj : pjpCtx] error is reported when running a complex query.CauseBug 7014646: ...

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=193023897622639&type=DOCUMENT&id=850963.1&displayIndex=7&_afrWindowMode=0&_adf.ctrl-state=ooltnvwxr_74 Applies to: O...

“ORA-1652: unable to extend temp segment”       临时表空间被资源中的多个会话共享，并且quotas不能限制每个用户使用的临时表空间数量，当临时表空间被填充满时，任何尝试获得...

ORA-02396: exceeded maximum idle time, please connect again

诊断并解决ORA-04031 错误当我们在共享池中试图分配大片的连续内存失败的时候，Oracle首先清除池中当前没使用的所有对象，使空闲内存块合并。如果仍然没有足够大单个的大块内存满足请求,就会产生ORA-04031 错误...

< 518:ORA-00308: cannot open archived log '/arch_log1/CDWQ/CDWQ_1_907600_574942170.dbf'< 519:ORA-27041: unable to open fileOracle Alert Log Is Reporting Archive Log Status Is Not Available For Logs Th...

Errors in file /u01/app/oracle/admin/XXXXX/bdump/xxxxxx_j000_8892588.trc:ORA-12012: error on auto execute of job 1ORA-00001: unique constraint (PERFSTAT.STATS$UNDOSTAT_PK) violatedORA-06512: at "PERFS...

 oerr ora 111401114, 00000, "IO error writing block to file %s (block # %s)"// *Cause:  The device on which the file resides is probably offline. If the //    &nb...

 oerr ora 1254712547, 00000, "TNS:lost contact"// *Cause: Partner has unexpectedly gone away, usually during process// startup.// *Action: Investigate partner application for abnormal ter...

/oracle > oerr ora 1250012500, 00000, "TNS:listener failed to start a dedicated server process"// *Cause:  The process of starting up a dedicated server process failed.// The executable could...

ERROR:ORA-09925: Unable to create audit trail fileIBM AIX RISC System/6000 Error: 13: Permission deniedAdditional information: 9925ORA-09925: Unable to create audit trail fileIBM AIX RISC ...

SymptomWhen trying to load on table that has a blob column type the job fails with this Oracle error:ORA-24333: zero iteration countEnvironment    * Oracle 11.2G Client  &nbsp...

　　产生原因：ORACLE临时段表空间不足，因为ORACLE总是尽量分配连续空间，一旦没有足够的可分配空间或者分配不连续就会出现上述的现象。　　解决方法：我们知道由于ORACLE将表空间作为逻辑结构-单元，而表空间...

1，利用$ORACLE_HOME/rdbms/admin下的utlrp.sql脚本编译.一般都是在迁移或者升级之后运行该脚本.2，dbms_utility.compile_schema（）3，select 'ALTER '||OBJECT_TYPE||' '||OBJECT_NAME||' COMPILE;' FROM DBA_...

SQL>   SELECT dbms_metadata.get_ddl('TABLESPACE','TEMP') FROM dual;ERROR:ORA-06502: PL/SQL: numeric or value errorLPX-00210: expected '<' instead of 'n'ORA-06512: at "SYS.UTL_XML", line 0ORA...

       DBMS_OUTPUT.PUT_LINE(substr(v_CreateUser,1,255));       DBMS_OUTPUT.PUT_LINE(substr(v_CreateUser,256));

ORA-03136: inbound connection timed outCause: Inbound connection was timed out by the server because userauthentication was not completed within the given time specified bySQLNET.INBOUND_CONNECT_TIME...

ORA-01555: snapshot too old: rollback segment number string with name "string"too smallCause: rollback records needed by a reader for consistent read are overwritten byother writersAction: If in Autom...

ORA-12514: TNS:listener does not currently know of service requested in connectdescriptorCause: The listener received a request to establish a connection to a database orother service. The connect des...

处理报表时出错。 (rsProcessingAborted) 对数据集“sc_company_all”执行查询失败。 (rsErrorExecutingCommand) ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","DBMS_...