Run the duplicate at a time when there is no concurrent operation. Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions abou

Run the duplicate at a time when there is no concurrent operation. Please note: The above is a su

Run the duplicate at a time when there is no concurrent operation. Please note: The above is a su

Titleimage

Posted by Patrick Hamou on 2017:09:28 19:14:43

CONTENT: overview of bug 20936731

This note gives a brief overview of bug 20936731. 
The content was last updated on: 17-FEB-2017.

Affects: Oracle Server (Rdbms)

Product (Component): Oracle Server (Rdbms)

Range of versions believed to be affected: Versions BELOW 12.2

Versions confirmed as being affected: 

  • 12.1.0.2 (Server Patch Set)
  • 12.1.0.1 (Base Release)

Platforms affected: Generic (all / most platforms affected)

Fixed: 20936731

The fix for 20936731 is first included in

  • 12.2.0.1 (Base Release)
  • 12.1.0.2.170117 (Jan 2017) Database Patch Set Update (DB PSU)
  • 12.1.0.2.170117 (Jan 2017) Database Proactive Bundle Patch
  • 12.1.0.2.160531 (May 2016) Bundle Patch for Windows Platforms


Interim patches may be available for earlier versions - click here to check.

Symptoms: ORA-1033

ORA-1033

Related To: Advanced Queuing

Advanced Queuing

Description: ALTER SYSTEM ENABLE/DISABLE RESTRICTED SESSION breaks notifications (ORA-1033)

ALTER SYSTEM ENABLE/DISABLE RESTRICTED SESSION breaks notifications (ORA-1033)

 

eg:

 alter system enable restricted session;

 grant restricted session to <user>;

 (run a shell script)

 alter system disable restricted session;

 revoke restricted session from <user>;

After that, PL/SQL Asynchronous Notifications stop working.

Rediscovery Notes

 The Alert log shows evidence of the disable restricted session and an ORA-1033.

 eg:

   ALTER SYSTEM disable restricted session;

   Starting background process AQPC

   ...

   Stopping all emon processes

   Stopping EMNC

   Tue Apr 21 07:41:47 2015

   ORA-1033 during publish to emon channel

   Tue Apr 21 07:41:57 2015

   Stopping all emon processes

   Stopping EMNC

 

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

 

Return to Blog