Useful docs encountered lately

Encountering ora-00955 when trying to create primary key on an imported table in 10g (Doc ID 292096.1)
Dropping constraints does not drop index simultaneously on
Error ORA-00955 may occur.


‘Apparent Deadlock’ Errors Occurring in Threadpoolworker (文档 ID 1163103.1)

||AP||2016-10-13 00:09:11:500||RMBSCM||bea||WARN||WEB-APP||com.mchange.v2.async.ThreadPoolAsynchronousRunner||run||com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1704f50a -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
||AP||2016-10-13 00:09:11:513||RMBSCM||bea||WARN||WEB-APP||com.mchange.v2.async.ThreadPoolAsynchronousRunner||run||com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1704f50a -- APPARENT DEADLOCK!!! Complete Status: 

||AP||2016-10-13 00:09:11:500||RMBSCM||bea||WARN||WEB-APP||com.mchange.v2.async.ThreadPoolAsynchronousRunner||run||com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1704f50a — APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
||AP||2016-10-13 00:09:11:513||RMBSCM||bea||WARN||WEB-APP||com.mchange.v2.async.ThreadPoolAsynchronousRunner||run||com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1704f50a — APPARENT DEADLOCK!!! Complete Status:


While creates a binary copy of the current controlfile, the copy that is created must reside on a shared location.

The issue happens only RAC environment: session 1 connect to inst 1 while session 2 connect to inst 2.


crsd stuck in intermediate state and crsd.log repeats “Master is not known” due to network issue (Doc ID 1587260.1)

11gR2 GI, on a two node cluster environment (node1 and node2), the first node can not join the cluster if the second node is started first. The resource ora.crsd on node1 remains in INTERMEDIATE state, and crsd.log is filled with messages like "Master is not known. Rejecting the command".

AWR shows incorrect cpu time in IBM AIX (Doc ID 1631769.1)

Certification Information for Oracle Database on Linux x86-64 (Doc ID 1304727.1)

Information Center: Leap Second Information for All Products – Database – Exadata – Middleware – Exalogic – Linux – Sun – Fusion – EBS – JDE – Siebel – Peoplesoft (Doc ID 2019397.2)

Streams Capture Aborting With ORA-26767 Due To Temp Tables Created By DBMS_COMPRESSION (Doc ID 1082323.1)

Troubleshooting Guide (TSG) – Ksvcreate: Process(xxxx) Creation Failed / ORA-00445: Background Process “xxxx” Did Not Start After n Seconds (Doc ID 1379200.1)

High SQL Version Counts – Script to determine reason(s) (Doc ID 438755.1)

Top SQL Statement Missing from DBA_HIST_SQLSTAT View (Doc ID 1424839.1)
FAQ: Regarding DBA_HIST_SQLSTAT Interpretation (Doc ID 471053.1)

Bug 10194190 – Solaris: Process spin and/or ASM and DB crash if RAC instance up for > 248 days

Roadmap of Oracle Database Patchset Releases (Doc ID 1360790.1)
Release Schedule of Current Database Releases (Doc ID 742060.1)


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s