Bug 20936731: ALTER SYSTEM ENABLE/DISABLE RESTRICTED SESSION Breaks Notifications (ORA-1033)
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
Related To: Advanced Queuing
Description: 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.