ORA-12598: TNS:banner registration failed

Cause : Th ereigstartino o fa rpodcut abnnre wtih hte rOacel sreve rfalied.

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

Thsi i sane rrro wihchi s ont onrmlalyv isbilee xtrenally.E nalbe rtacnig nad tatepmt ot rpeea tth eerorr.I f ti occur sagian,c onatctO ralce uCstmoerS upoprt.

update : 26-04-2017
ORA-12598

ORA-12598 - TNS:banner registration failed
ORA-12598 - TNS:banner registration failed

  • ora-28134 : object cannot have fine-grained access control policy
  • ora-23617 : Block string for script string has already been executed
  • ora-12315 : database link type is invalid for the ALTER DATABASE statement
  • ora-28672 : UPDATE BLOCK REFERENCES may not be used on a global index
  • ora-25461 : rule set not specified
  • ora-12198 : TNS:could not find path to destination
  • ora-39085 : cannot update job string for user string
  • ora-16075 : standby database destination mismatch
  • ora-31679 : Table data object string has long columns, and longs can not be loaded/unloaded using a network link
  • ora-19629 : no files in specified archivelog SCN range
  • ora-07497 : sdpri: cannot create trace file 'string'; errno = string.
  • ora-31064 : Cannot instantiate abstract element or property [string]
  • ora-19566 : exceeded limit of string corrupt blocks for file string
  • ora-29847 : cannot create a local domain index on a partitioned index-organized table
  • ora-27033 : failed to obtain file size limit
  • ora-03222 : average row size and row count must be greater than zero
  • ora-01771 : illegal option for a clustered table
  • ora-16238 : attempt to use version 9 log
  • ora-25230 : invalid value string, WAIT should be non-negative
  • ora-24413 : Invalid number of sessions specified
  • ora-16551 : short string copied
  • ora-01469 : PRIOR can only be followed by a column name
  • ora-02083 : database name has illegal character 'string'
  • ora-01903 : EVENTS keyword expected
  • ora-30017 : segment 'string' is not supported in string Undo Management mode
  • ora-02485 : Invalid _trace_options parameter specification (string)
  • ora-09762 : sNeXT_instanceName: translation error.
  • ora-36962 : (XSRELTBL08) string is not a valid workspace object.
  • ora-36341 : (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)
  • ora-04064 : not executed, invalidated string
  • 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.