ORA-28270: Malformed user nickname for password authenticated global user.

Cause : An attempt to login as password-auuthenticated global user with a malformed user nickname.

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

Make sure the nickname is valid and re-login.

update : 24-04-2017

ORA-28270 - Malformed user nickname for password authenticated global user.
ORA-28270 - Malformed user nickname for password authenticated global user.

  • ora-14167 : only one subpartition may be moved
  • ora-24014 : invalid value string, RETENTION_TIME should be FOREVER or non-negative
  • ora-07670 : $IDTOASC failed translating a secrecy category
  • ora-39124 : dump file name "string" contains an invalid substitution variable
  • ora-38492 : invalid ALTER INDEX parameters clause "string"
  • ora-17613 : Failed to initialize Oracle Disk Manager library: string
  • ora-13864 : Statistics aggregation for service (module/action) string is already enabled
  • ora-31438 : duplicate change table string
  • ora-29342 : user string does not exist in the database
  • ora-22974 : missing WITH OBJECT OID clause
  • ora-12540 : TNS:internal limit restriction exceeded
  • ora-17507 : I/O request size string is not a multiple of logical block size
  • ora-13844 : no new SQL profile name or category specified.
  • ora-00481 : LMON process terminated with error
  • ora-00162 : external dbid length string is greater than maximum (string)
  • ora-07758 : slemcw: invalid handle
  • ora-00273 : media recovery of direct load data that was not logged
  • ora-25290 : Cannot complete operation on queue string with existing messages
  • ora-07339 : spcre: maximum number of semaphore sets exceeded.
  • ora-29362 : plan directive string, string does not exist
  • ora-19724 : snapshot too old: snapshot time is before file string plug-in time
  • ora-06003 : NETASY: port write failure
  • ora-16170 : Terminal recovery may have left the database in an inconsistent state
  • ora-35018 : (QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
  • ora-32578 : password for SYS already specified
  • ora-12058 : materialized view cannot use prebuilt table
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-02194 : event specification syntax error string (minor error string) near 'string'
  • ora-01199 : file string is not in online backup mode
  • ora-01556 : MINEXTENTS for rollback segment must be greater than 1
  • 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.