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 : 30-05-2017
ORA-28270

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

  • ora-32514 : cannot dump multiple 'string' types: structure size is unknown
  • ora-12032 : cannot use rowid column from materialized view log on "string"."string"
  • ora-29892 : indextypes with array DML do not support the given data type
  • ora-00360 : not a logfile member: string
  • ora-29553 : class in use: string.string
  • ora-03261 : the tablespace string has only one file
  • ora-38853 : cannot mark instance string (redo thread string) as disabled
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-16521 : unable to create generic template id
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-29841 : invalid option for ALTER INDEXTYPE
  • ora-21524 : object type mismatch
  • ora-25461 : rule set not specified
  • ora-31608 : specified object of type string not found
  • ora-24338 : statement handle not executed
  • ora-38765 : Flashed back database cannot be opened read-only.
  • ora-19201 : Datatype not supported
  • ora-16585 : illegal operation on a primary site
  • ora-38762 : thread string redo log with scn string could not be found
  • ora-24067 : exceeded maximum number of subscribers for queue string
  • ora-31202 : DBMS_LDAP: LDAP client/server error: string
  • ora-27512 : IPC error posting a process
  • ora-30934 : 'string' (string node) cannot be inserted in parent 'string' (string node)
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-25289 : Buffer Already Exists
  • ora-06722 : TLI Driver: connection setup failure
  • ora-12076 : invalid threshold value
  • ora-39765 : stream must be reset before used in a column array conversion
  • ora-07747 : slemrd: $READ failure
  • ora-25350 : maximum number of concurrent transaction branches exceeded
  • 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.