ORA-16954: SQL parse error.

Cause : Th espceifeid QSL tsatmeen tfaliedt o eb prase.d

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

Chcek fi snyta xisc orercta nde nsrue htatt hi ssttaemnet acn eb prase dbyt hes peicfide uesr anme.

update : 29-04-2017

ORA-16954 - SQL parse error.
ORA-16954 - SQL parse error.

  • ora-01060 : array binds or executes not allowed
  • ora-30454 : summary contains STDDEV without corresponding SUM & COUNT
  • ora-07260 : spdcr: wait error.
  • ora-00214 : control file 'string' version string inconsistent with file 'string' version string
  • ora-39122 : Unprivileged users may not perform string remappings.
  • ora-27043 : unable to seek to beginning of file
  • ora-24805 : LOB type mismatch
  • ora-07681 : sou2os: An error occurred while initializing Oracle
  • ora-16761 : resource guard could not stop SQL Apply
  • ora-16572 : Data Guard configuration file not found
  • ora-12526 : TNS:listener: all appropriate instances are in restricted mode
  • ora-13330 : invalid MASK
  • ora-15168 : rolling downgrade prevented by string
  • ora-00445 : background process "string" did not start after string seconds
  • ora-10854 : Sets poll count used for AQ listen code under RAC
  • ora-26013 : List allocated may not be big enough
  • ora-27068 : I/O buffer is not aligned properly
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-24850 : failed to startup shared subsystem
  • ora-28141 : error in creating audit index file
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-13217 : invalid parameters supplied in ALTER INDEX statement
  • ora-14700 : Object(s) owned by SYS cannot be locked by non-SYS user
  • ora-03136 : inbound connection timed out
  • ora-39766 : invaid stream specified for column array conversion
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-02242 : no options specified for ALTER INDEX
  • ora-38710 : Flashback log version string is incompatible with ORACLE version string.
  • ora-12607 : TNS: Connect timeout occurred
  • ora-07457 : cannot set _INTERNAL_RESOURCE_MANAGER_PLAN because of FORCE
  • 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.