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 : 30-05-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-27038 : created file already exists
  • ora-19558 : error de-allocating device
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-22310 : ALTER TYPE error. Refer to table "string"."string" for errors
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-36844 : (XSLMGEN14) Dimension string.string!string is missing a string property value
  • ora-32012 : failure in processing system parameters from restored SPFILE
  • ora-00232 : snapshot control file is nonexistent, corrupt, or unreadable
  • ora-08183 : Flashback cannot be enabled in the middle of a transaction
  • ora-04089 : cannot create triggers on objects owned by SYS
  • ora-26527 : local store callback init phase failed for 'string.string'
  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-16951 : Too many bind variables supplied for this SQL statement.
  • ora-09708 : soacon: failed to bind socket to port.
  • ora-16029 : cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations
  • ora-30388 : name of the rewrite equivalence is not specified
  • ora-30392 : the checksum analysis for the rewrite equivalence failed
  • ora-31161 : element or attribute "string" cannot be stored out of line
  • ora-38956 : Target platform string not cross platform compliant
  • ora-09918 : Unable to get user privileges from SQL*Net
  • ora-31046 : Incorrect argument(s) specified in the operator
  • ora-06539 : target of OPEN must be a query
  • ora-25442 : too many column values for table alias: string
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-16613 : initialization in progress for database
  • ora-19245 : XQ0025 - duplicate attribute name string
  • ora-14042 : partition bound may not be specified for a partition being moved, modified or rebuilt
  • ora-01591 : lock held by in-doubt distributed transaction string
  • ora-13504 : No SYSAUX datafile clause specified
  • ora-03263 : cannot drop the first file of tablespace string
  • 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.