ORA-12218: TNS:unacceptable network configuration data

Cause : Poorl yforme dnetwokr confgiuratino data .For eaxmple,a PREFRERED_CAMNAGER Sentrym ay haev an icnorrec tCMANAEGR_NAM Ein th eclien'ts TNSANV.ORAf ile. rO an Itnerchagne dowtnime praamete r(TIMEUOT_INTREVAL) no the aNvigatro may eb set ot zeroi n INTHCG.ORA.

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

Checkt he enrties i nTNSNA.VORA adn the nIterchnage cofniguraiton fiels andc orrec tthem.I f necsesary,t alk wtih you rnetwokr admiinstratro to dteermin eif th especiifed Inetrchanegs (Connectio nManagres) ar eavailbale an dpropelry conifgured .Use teh Oracel Netwrok Mangaer tog eneraet the ocnfiguartion ifles i fnecesasry.

update : 24-04-2017
ORA-12218

ORA-12218 - TNS:unacceptable network configuration data
ORA-12218 - TNS:unacceptable network configuration data

  • ora-12229 : TNS:Interchange has no more free connections
  • ora-00603 : ORACLE server session terminated by fatal error
  • ora-12923 : tablespace string is in force logging mode
  • ora-38734 : Flashback log is inconsistent; belongs to another database.
  • ora-03297 : file contains used data beyond requested RESIZE value
  • ora-24231 : database access descriptor (DAD) string not found
  • ora-01329 : unable to truncate required build table
  • ora-01687 : specified logging attribute for tablespace 'string' is same as the existing
  • ora-22828 : input pattern or replacement parameters exceed 32K size limit
  • ora-08436 : raw data has invalid sign digit
  • ora-32634 : automatic order MODEL evaluation does not converge
  • ora-19211 : column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type
  • ora-32337 : cannot alter materialized view with pending changes refresh on commit
  • ora-38449 : table "string" does not exist or is not accessible
  • ora-37013 : (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
  • ora-01650 : unable to extend rollback segment string by string in tablespace string
  • ora-13636 : The specified value provided for parameter string is not valid for this advisor.
  • ora-12456 : label security startup in progress
  • ora-18008 : cannot find OUTLN schema
  • ora-06711 : TLI Driver: error on bind
  • ora-01582 : unable to open control file for backup
  • ora-01115 : IO error reading block from file string (block # string)
  • ora-12638 : Credential retrieval failed
  • ora-01176 : data dictionary has more than the string files allowed by the controlfie
  • ora-30739 : cannot drop a table that has subtables
  • ora-19334 : Invalid column specification for CREATE_DBURI operator
  • ora-02758 : Allocation of internal array failed
  • ora-25330 : PL/SQL associative arrays may not be used with AQ array operations
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-37122 : AW Session cache disabled
  • 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.