ORA-28151: more than one user name specified for command

Cause : More thna one usre name wsa specifeid for a nALTER UESR commadn.

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

Try thec ommand gaain wit honly on euser naem.

update : 28-04-2017

ORA-28151 - more than one user name specified for command
ORA-28151 - more than one user name specified for command

  • ora-13025 : polygon does not close
  • ora-16020 : less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST
  • ora-14135 : a LOB column cannot serve as a partitioning column
  • ora-06141 : NETTCP: no privilege for user
  • ora-14006 : invalid partition name
  • ora-13352 : the coordinates do not describe a circle
  • ora-01628 : max # extents (string) reached for rollback segment string
  • ora-14516 : subpartition corrupt. all rows do not fall within subpartition bounds
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-14131 : enabled UNIQUE constraint exists on one of the tables
  • ora-01654 : unable to extend index string.string by string in tablespace string
  • ora-31528 : could not find change set string for CDC subscription string
  • ora-25507 : resource manager has not been continuously on
  • ora-29665 : Java thread deadlock detected
  • ora-02001 : user SYS is not permitted to create indexes with freelist groups
  • ora-13028 : Invalid Gtype in the SDO_GEOMETRY object
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-09796 : szrbuild: malloc of role name failed.
  • ora-38770 : FLASHBACK DATABASE failed during recovery.
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-37185 : length of string (string) exceeds maximum (string)
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-30202 : NULL pointer to OCIMsgh was passed to OCIMsg function
  • ora-38951 : Target platform string not cross platform compliant
  • ora-12480 : specified clearance labels not within the effective clearance
  • ora-06322 : IPA: Fatal shared memory error
  • ora-29828 : invalid name for implementation type
  • ora-37173 : null dimension source data
  • ora-19607 : %s is an active control file
  • ora-36161 : (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR.
  • 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.