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 : 28-05-2017
ORA-23470

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

  • ora-02361 : error while attempting to allocate number bytes of memory
  • ora-25300 : Cannot drop buffer for queue with buffered subscribers
  • ora-17501 : logical block size string is invalid
  • ora-29301 : wrong DBMS_PITR package function/procedure order
  • ora-31689 : illegal value for base worker id, string
  • ora-02151 : invalid tablespace name: string
  • ora-33290 : (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.
  • ora-15026 : disk 'string' is not an ASM disk
  • ora-31425 : subscription does not exist
  • ora-22333 : cannot reset type "string"."string" due to invalid dependent types and tables
  • ora-38721 : Invalid file number.
  • ora-24325 : this OCI operation is not currently allowed
  • ora-31211 : DBMS_LDAP: PL/SQL - Invalid LDAP entry dn.
  • ora-29951 : warning in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-08268 : create_ora_addr: cannot close nameserver
  • ora-23454 : flavor string not defined for object group "string"."string"
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-30558 : internal error [string] in function based index
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-23473 : replication RPC processing for "string"."string" is disabled
  • ora-00319 : log string of thread string has incorrect log reset status
  • ora-14116 : partition bound of partition "string" is too long
  • ora-07268 : szguns: getpwuid error.
  • ora-29971 : Specified table name not found or does not have any registrations
  • ora-13005 : recursive HHCODE function error
  • ora-22899 : cannot specify both scope and rowid constraint on ref column
  • ora-27156 : request for process information failed
  • ora-00088 : command cannot be executed by shared server
  • ora-14329 : domain index [sub]partitions cannot be renamed in this clause
  • ora-08436 : raw data has invalid sign digit
  • 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.