ORA-65040: operation not allowed from within a pluggable database
Oracle Database Tips by Donald BurlesonApril 21, 2015
Question: I am getting the ORA-xxxx error when attempting to change my SYSTEM password in Oracle 12c:
ERROR:
ORA-28001: the password has expired
Changing password for system
New password:
Retype new password:
ERROR:
ORA-65040: operation not allowed from within a pluggable database
Answer: The oerr utility shows this for the ORA-65040 error:
ORA-65040: operation not allowed from within a pluggable database
Cause: An operation was attempted that can only be performed in the root container.
Action: Switch to the root container to perform the operation
You can switch to the root container in one of these ways:
SQL> conn / as sysdba
Connected.
Get Complete Oracle Tuning Details
The landmark book "Oracle
Tuning: The Definitive Reference Third Edition" has been
updated with over 800 pages of expert performance tuning tips.
It's packed with scripts and tools to hypercharge Oracle performance and you can buy it for 40% off directly from the publishers.
ERROR:
ORA-28001: the password has expired
Changing password for system
New password:
Retype new password:
ERROR:
ORA-65040: operation not allowed from within a pluggable database
Answer: The oerr utility shows this for the ORA-65040 error:
ORA-65040: operation not allowed from within a pluggable database
Cause: An operation was attempted that can only be performed in the root container.
Action: Switch to the root container to perform the operation
You can switch to the root container in one of these ways:
SQL> conn / as sysdba
Connected.
|
|
Get Complete Oracle Tuning Details
The landmark book "Oracle Tuning: The Definitive Reference Third Edition" has been updated with over 800 pages of expert performance tuning tips. It's packed with scripts and tools to hypercharge Oracle performance and you can buy it for 40% off directly from the publishers. |