ORA-28155: user 'string' specified as a proxy is actually a role

Cause : A user specified in an AUDIT BY ON BEHALF OF is actually a role.

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

Execute the statement again with a valid proxy user.

update : 25-09-2017

ORA-28155 - user 'string' specified as a proxy is actually a role
ORA-28155 - user 'string' specified as a proxy is actually a role

  • ora-37184 : illegal value string for ADVMODE
  • ora-26509 : null materialized view control structure
  • ora-25121 : MINIMUM EXTENT value greater than maximum extent size
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-01059 : parse expected before a bind or execute
  • ora-10701 : Dump direct loader index keys
  • ora-06559 : wrong datatype requested, string, actual datatype is string
  • ora-12205 : TNS:could not get failed addresses
  • ora-26054 : Direct Path Context prepared for a different mode than operation requested.
  • ora-34181 : (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-31494 : could not activate a LogMiner session
  • ora-15058 : disk 'string' belongs to an incompatible diskgroup
  • ora-36696 : (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.
  • ora-16218 : This database is already preparing to switch over.
  • ora-13068 : wrong table or column name in SDO_TOPO_GEOMETRY constructor
  • ora-06043 : NETDNT: message send failure
  • ora-40321 : invalid bin number, is zero or negative value
  • ora-27093 : could not delete directory
  • ora-14134 : indexes cannot use both DESC and REVERSE
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-06519 : active autonomous transaction detected and rolled back
  • ora-00303 : cannot process Parallel Redo
  • ora-12422 : max policies exceeded
  • ora-13505 : SYSAUX tablespace can not be made read only
  • ora-16507 : unrecognized request identifier
  • ora-02155 : invalid DEFAULT tablespace identifier
  • ora-26079 : file "string" is not part of table string.string
  • ora-10389 : parallel query server interrupt (cleanup)
  • ora-06401 : NETCMN: invalid driver designator
  • 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.