ORA-00129: listener address validation failed 'string'

Cause : An error was encountered while validating the listener address.

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

Resolve error or contact your ORACLE representative.

update : 17-08-2017
ORA-00129

ORA-00129 - listener address validation failed 'string'
ORA-00129 - listener address validation failed 'string'

  • ora-30111 : no closing quote for value 'string'
  • ora-24313 : user already authenticated
  • ora-01585 : error identifying backup file string
  • ora-31436 : duplicate change source string
  • ora-12495 : cannot disable an enabled level, category, or release category
  • ora-13377 : invalid combination of elements with orientation
  • ora-27542 : Failed to unprepare a buffer prepared for remote update
  • ora-01173 : data dictionary indicates missing data file from system tablespace
  • ora-14603 : [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables
  • ora-01319 : Invalid Logminer session attribute
  • ora-37078 : (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-16084 : an apply engine is already running
  • ora-16822 : new primary database not yet ready for standby database reinstatement
  • ora-00353 : log corruption near block string change string time string
  • ora-01515 : error dropping log group string: no such log
  • ora-29358 : resource plan string does not exist
  • ora-23610 : internal dbms_streams_tablespaces error: [string] [string] [string] [string]
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-24201 : duplicate publisher, publisher already added to the queue
  • ora-28101 : policy already exists
  • ora-24180 : invalid transformation expression, the transformation expression does not evaluate to the target type/attribute
  • ora-24052 : cannot propagate object type payloads with LOB attributes to an 8.0 release
  • ora-29351 : can not transport system, sysaux, or temporary tablespace 'string'
  • ora-00383 : DEFAULT cache for blocksize string cannot be reduced to zero
  • ora-01615 : instance string (thread string) is mounted - cannot disable
  • ora-38782 : cannot flashback database to non-guaranteed restore point 'string'
  • ora-36763 : (XSAGGCNTMOVE01) Aggregation variable workspace object cannot have itself as an AGGCOUNT.
  • ora-01948 : identifier's name length (string) exceeds maximum (string)
  • ora-07671 : $IDTOASC failed translating an integrity category
  • 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.