ORA-06512: at "SYS.NAME_SECURITY" for Tablespace or User or Any DDLs like ALTER CREATE DROP RESET password
Last updated on MAY 21, 2015
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
When try to drop/create/alter tablespace gives tablespace related errors mentioned below with ORA-06512: at "SYS.NAME_SECURITY"
ORA-25153: Temporary Tablespace is Empty
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '+DATA_GRP1/weekcrte/tempfile/temp1'
Even when try to reset the password and login users could get the errors mentioned below with ORA-06512: at "SYS.NAME_SECURITY"
ORA-28001: the password has expired
ORA-06531: Reference to uninitialized collection
ORA-04063: package body "SYS.NAME_SECURITY" has errors
Followed <Note 1482694.1> Mitigation steps for CVE-2012-3132
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms