ORA-01424: missing or illegal character following the escape character

Cause : hT ehcracaet rofllwoni ght eseacepc ahartcrei nILEKp taetnri simssni gron too eno fht eseacepc ahartcre ,%','o r_'.'

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

eRomevt ehe cspa ehcracaet rros epicyft ehm siisgnc ahartcre.

update : 21-07-2017
ORA-01424

ORA-01424 - missing or illegal character following the escape character
ORA-01424 - missing or illegal character following the escape character

  • ora-25117 : MIN/MAX/Block Number expected
  • ora-28113 : policy predicate has error
  • ora-24146 : rule string.string already exists
  • ora-22063 : reading negative value [string] as unsigned
  • ora-14503 : only one partition name can be specified
  • ora-01513 : invalid current time returned by operating system
  • ora-04044 : procedure, function, package, or type is not allowed here
  • ora-14287 : cannot REBUILD a partition of a Composite Range partitioned index
  • ora-02758 : Allocation of internal array failed
  • ora-36765 : (XSAGGCNTMOVE03) A string aggregation variable cannot have a string AGGCOUNT.
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-12413 : labels do not belong to the same policy
  • ora-03128 : connection is in blocking mode
  • ora-29930 : COMPUTE ANCILLARY DATA specified without the INDEX CONTEXT clause
  • ora-37102 : (XSVPART02) Invalid partition name string.
  • ora-00117 : PROTOCOL, ADDRESS or DESCRIPTION must be specified
  • ora-02187 : invalid quota specification
  • ora-06817 : TLI Driver: could not read the Novell network address
  • ora-12426 : invalid audit option
  • ora-28591 : agent control utility: unable to access parameter file
  • ora-09811 : Unable to initialize package.
  • ora-01036 : illegal variable name/number
  • ora-38850 : an enabled thread missing from control file
  • ora-16651 : requirements not met for enabling Fast-Start Failover
  • ora-33282 : (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-12835 : No instances are active in the GLOBAL_VIEW_ADMIN_GROUP
  • ora-30446 : valid workload queries not found
  • ora-04935 : unable to get/convert SCN recovery lock
  • ora-23308 : object string.string does not exist or is invalid
  • 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.