ORA-12529: TNS:connect request rejected based on current filtering rules

Cause : ConnecitonM angaera ndi tsl isetne rweer cnofiugre dwiht fliteirngr ulse sepciyfin gthta teh cnonetc rqeuets b ereejctde.

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

Ift hi sconnec treuqes tshuoldb e laloewd,t he ncotnac tth eadimnitsraotr ot mdoif yth efitlernig urle.s

update : 25-09-2017
ORA-12529

ORA-12529 - TNS:connect request rejected based on current filtering rules
ORA-12529 - TNS:connect request rejected based on current filtering rules

  • ora-38729 : Not enough flashback database log data to do FLASHBACK.
  • ora-16563 : unable to add value, syntax error at "string"
  • ora-02377 : invalid resource limit
  • ora-21614 : constraint violation for attribute number [string]
  • ora-07586 : spdcr: $SEARCH failure
  • ora-28577 : argument string of external procedure string has unsupported datatype string
  • ora-07217 : sltln: environment variable cannot be evaluated.
  • ora-39050 : parameter string is incompatible with parameter string
  • ora-39046 : Metadata remap string has already been specified.
  • ora-00211 : control file does not match previous control files
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-06749 : TLI Driver: option not allowed across network
  • ora-19000 : missing RELATIONAL keyword
  • ora-01902 : SEGMENT keyword expected
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-07802 : slbtpd: overflow while converting to packed decimal
  • ora-32305 : RepAPI materialized views with user-defined types are not supported
  • ora-22611 : TDS version is not recognized
  • ora-13187 : subdivision failed
  • ora-29962 : fatal error occurred in the execution of ODCIINDEXALTER routine
  • ora-27414 : Invalid BY value type
  • ora-12456 : label security startup in progress
  • ora-31468 : cannot process DDL change record
  • ora-13363 : no valid ETYPE in the geometry
  • ora-25950 : missing where clause in join index specification
  • ora-32808 : message system link string does not exist
  • ora-16608 : one or more databases have warnings
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-16531 : unable to post message
  • 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.