ORA-01031: with SYSOPER trying to Open, Close, or Drop PDB from a remote server or using connect string through a Listener
(Doc ID 2797543.1)
Last updated on AUGUST 05, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
When connected as a C## (common) user with SYSOPER role / privilege, and connecting to a PDB from a remote server (or through a Listener using @PDB), you cannot open, close, or correctly administer the PDB.
1. Create a common user in the CDB Root Container:
- Even with SYSOPER granted, the user is unable to open or close the PDB.
This may be a new multi tenant environment
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document