ORA-23470: invalid status

Cause : Th esttauss holud eb DLEETDE, NISTLALIGN o rINTSALELD.A nyo thre sattu sisi nvlaid.

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

Chcek htatt hes peicfide sattu svaule si croretc.

update : 24-04-2017

ORA-23470 - invalid status
ORA-23470 - invalid status

  • ora-23412 : master table's primary key columns have changed
  • ora-15093 : buffer only contains string bytes, I/O requested is string bytes
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-16547 : cannot disable the primary database
  • ora-39124 : dump file name "string" contains an invalid substitution variable
  • ora-16057 : DGID from server not in Data Guard configuration
  • ora-16797 : database is not using a server parameter file
  • ora-00271 : there are no logs that need archiving
  • ora-09749 : pws_look_up: port lookup failure
  • ora-32102 : invalid OCI handle
  • ora-16524 : unsupported operation
  • ora-01182 : cannot create database file string - file is in use or recovery
  • ora-12726 : unmatched bracket in regular expression
  • ora-00601 : cleanup lock conflict
  • ora-29886 : feature not supported for domain indexes
  • ora-25134 : keyword TABLE expected
  • ora-16509 : the request timed out
  • ora-10578 : Can not allow corruption for managed standby database recovery
  • ora-12923 : tablespace string is in force logging mode
  • ora-13140 : invalid target type
  • ora-36200 : (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
  • ora-02471 : SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expression.
  • ora-01184 : logfile group string already exists
  • ora-09743 : smscre: could not attach shared memory.
  • ora-01023 : Cursor context not found (Invalid cursor number)
  • ora-01509 : specified name 'string' does not match actual 'string'
  • ora-00991 : only MAC privileges may be granted to procedures
  • ora-13184 : failed to initialize tessellation package
  • ora-23467 : flavor lacks object "string"."string"
  • ora-06251 : NETNTT: cannot translate address file name
  • 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.