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 : 28-07-2017
ORA-12218

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

  • ora-38722 : ON or OFF expected.
  • ora-31455 : nothing to ALTER
  • ora-34342 : (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.
  • ora-10655 : Segment can be shrunk
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-01514 : error in log specification: no such log
  • ora-32032 : free temporary object number not available
  • ora-08231 : smscre: unable to attach to SGA
  • ora-00300 : illegal redo log block size string specified - exceeds limit of string
  • ora-39078 : unable to dequeue message for agent string from queue "string"
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-19024 : Cursor expression must be named
  • ora-38785 : Media recovery must be enabled for guaranteed restore point.
  • ora-29859 : error occurred in the execution of ODCIINDEXTRUNCATE routine
  • ora-00152 : current session does not match requested session
  • ora-13483 : insufficient memory for the specified GeoRaster data
  • ora-32155 : Anydata not specified
  • ora-24029 : operation not allowed on a single-consumer queue
  • ora-31481 : change source string is not a HotLog change source
  • ora-31534 : Change Data Capture string publisher string is missing DBA role
  • ora-40272 : apply rules prohibited for this model mode
  • ora-16059 : Log file is empty or invalid next available block
  • ora-19379 : invalid time_limit or repeat_interval
  • ora-25247 : %s is not a recipient of specified message
  • ora-23447 : missing user parameter value
  • ora-12090 : cannot online redefine table "string"."string"
  • ora-30088 : datetime/interval precision is out of range
  • ora-10930 : trace name context forever
  • ora-23514 : invalid or incorrect number of arguments
  • ora-01513 : invalid current time returned by operating system
  • 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.