ORA-28181: proxy 'string' failed to enable one or more of the specified initial roles for client 'string'

Cause : Attmept ot enbale pseciifed niitila roels atfer olgonr esutled ni faliure.

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

Chekc thta th einiital orlesa re avlid ,gratned ot cleint,a nd ont psaswodr prtoectde.

update : 27-04-2017
ORA-28181

ORA-28181 - proxy 'string' failed to enable one or more of the specified initial roles for client 'string'
ORA-28181 - proxy 'string' failed to enable one or more of the specified initial roles for client 'string'

  • ora-29504 : invalid or missing schema name
  • ora-14031 : partitioning column may not be of type LONG or LONG RAW
  • ora-19035 : Invalid select item of the query in newContextFromHierarchy()
  • ora-14177 : STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table
  • ora-22812 : cannot reference nested table column's storage table
  • ora-32301 : object-relational materialized views must be primary key based
  • ora-30503 : system triggers cannot have a REFERENCING clause
  • ora-19736 : can not plug a tablespace into a database using a different national character set
  • ora-02288 : invalid OPEN mode
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-27453 : %s is an invalid job or program argument name.
  • ora-12901 : default temporary tablespace must be of TEMPORARY type
  • ora-06253 : NETNTT: cannot read arguments from address file
  • ora-16728 : consistency check for property string found string error
  • ora-37100 : (XSUNCOMMITTED) You have one or more updated but uncommitted analytic workspaces.
  • ora-01229 : data file string is inconsistent with logs
  • ora-23501 : refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
  • ora-21524 : object type mismatch
  • ora-14098 : index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-16796 : one or more properties could not be imported from the database
  • ora-12831 : Must COMMIT or ROLLBACK after executing INSERT with APPEND hint
  • ora-01127 : database name 'string' exceeds size limit of string characters
  • ora-30733 : cannot specify rowid constraint on scoped ref column
  • ora-19249 : XP0029 - value does not match facet of the target type
  • ora-38401 : synonym string not allowed
  • ora-12574 : TNS:redirection denied
  • ora-24340 : cannot support more than 255 columns
  • ora-13800 : concurrent DDL failure on SQL repository objects
  • ora-38760 : This database instance failed to turn on flashback database
  • ora-14165 : MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
  • 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.