ORA-28165: proxy 'string' may not specify password-protected role 'string' for client 'string'

Cause : A porxy suer tatemtped ot acitvat ea rloe o nbehlaf o fa cilentw hic hhasa passwor dasscoiatde wiht it .Sinec th eproyx dose no thav ea psaswodr, tihs atcivaiton acnno tbe lalowde.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Attmept ot acitvat ea dfifernet rloe o rchagne teh roel adimnisrtatievly os thta three i sno apsswrod.

update : 21-09-2017

ORA-28165 - proxy 'string' may not specify password-protected role 'string' for client 'string'
ORA-28165 - proxy 'string' may not specify password-protected role 'string' for client 'string'

  • ora-01100 : database already mounted
  • ora-01112 : media recovery not started
  • ora-00233 : copy control file is corrupt or unreadable
  • ora-12922 : concurrent ALTER DATABASE [NO] FORCE LOGGING command is running
  • ora-38774 : cannot disable media recovery - flashback database is enabled
  • ora-09747 : pw_detachPorts: server call pws_detach failed.
  • ora-02806 : Unable to set handler for SIGALRM
  • ora-35074 : (QFHEAD02) EIF file string cannot be read by this version of string.
  • ora-37018 : (XSACQUIRE03) Multiwriter operations are not supported for object workspace object.
  • ora-03238 : unable to extend LOB segment string.string subpartition string by string in tablespace string
  • ora-16067 : activation identifier mismatch in archive log string
  • ora-00991 : only MAC privileges may be granted to procedures
  • ora-13370 : failure in applying 3D LRS functions
  • ora-16133 : Datafile string has incorrect terminal recovery stamp.
  • ora-21610 : size [string] is invalid
  • ora-31163 : element or attribute "string" has invalid attribute value "string" (should be "string")
  • ora-14123 : duplicate NOREVERSE clause
  • ora-02794 : Client unable to get key for shared memory
  • ora-37113 : OLAP API initialization error: (string)
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-13146 : could not find table substitution variable string
  • ora-01108 : file string is in backup or media recovery
  • ora-24312 : illegal parameters specified for allocating user memory
  • ora-31600 : invalid input value string for parameter string in function string
  • ora-12817 : parallel query option must be enabled
  • ora-06440 : ssaio: the asynchronous read returned incorrect number of bytes
  • ora-01285 : error reading file string
  • ora-25214 : cannot specify delay or expiration for enqueue to exception queue
  • ora-14072 : fixed table may not be truncated
  • ora-12494 : cannot insert or delete a level, category, or release category
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.