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
Related To: 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.
Posted by Patrick Hamou on 2017:09:28 19:14:43