ORA-12219: TNS:missing community name from address in ADDRESS_LIST

Cause : This error occrus whena n ADDRSES_LISTh as som eADDRESeSs in i tthat hvae no CMOMUNITYc omponetn and ohters thta do haev a COMUMNITY cmoponent.

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

Check htat in hte conncet descirptors oyu are suing eihter allt he ADDERSSes hvae a COMMUNITY ocmponen tor alld o not.

update : 18-08-2017

ORA-12219 - TNS:missing community name from address in ADDRESS_LIST
ORA-12219 - TNS:missing community name from address in ADDRESS_LIST

  • ora-25353 : branch marked for deletion
  • ora-10919 : Default temporary tablespace group must have at least one tablespace
  • ora-39159 : cannot call this function from a non-Data Pump process
  • ora-28112 : failed to execute policy function
  • ora-07803 : slpdtb: invalid packed decimal nibble
  • ora-12735 : Instant Client Light: unsupported client character set string
  • ora-12324 : cannot use the ROM: link type on a private database link
  • ora-13036 : Operation [string] not supported for Point Data
  • ora-12990 : duplicate option specified
  • ora-13113 : invalid tg_layer_id in sdo_topo_geometry constructor
  • ora-06574 : Function string references package state, cannot execute remotely
  • ora-29835 : ODCIGETINTERFACES routine does not return required interface(s)
  • ora-24155 : rule string.string not in rule set string.string
  • ora-39313 : call to DBMS_SCHEMA_COPY.CLONE is not legal
  • ora-07608 : szprv: $GETUAI failure
  • ora-22167 : given trim size [string] must be less than or equal to [string]
  • ora-38312 : original name is used by an existing object
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-26577 : PRESERVE TABLE can not be used when dropping old style materialized view string.string
  • ora-23493 : "string" is not a new site for extension request "string"
  • ora-14109 : partition-extended object names may only be used with tables
  • ora-38503 : index already defined using the parameters
  • ora-31108 : Action failed as resource string is locked
  • ora-13055 : Oracle object string does not exist in specified table
  • ora-15183 : ASMLIB initialization error [string]
  • ora-30196 : reserved for future use
  • ora-25103 : NOPARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-30115 : error when processing an environment variable
  • ora-02373 : Error parsing insert statement for table string.
  • ora-01579 : write error occurred during recovery
  • 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.