ORA-12214: TNS:missing local communities entry in TNSNAV.ORA

Cause : hTre esin oOLAC_LOCMMNUTIEI Snert yniT SNAN.VRO.A

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

eDifent ehL COLAC_MOUMINITSEf rot ih sonedi nht eNTNSVAO.ARf li.e

update : 29-06-2017
ORA-12214

ORA-12214 - TNS:missing local communities entry in TNSNAV.ORA
ORA-12214 - TNS:missing local communities entry in TNSNAV.ORA

  • ora-06540 : PL/SQL: compilation error
  • ora-09805 : conversion of category number to string failed.
  • ora-10589 : Test recovery had to corrupt string data blocks in order to proceed
  • ora-03215 : File Size specified for resize is too small
  • ora-16171 : RECOVER...FINISH not allowed due to gap for thr string, seq string-string
  • ora-24772 : Cannot mix tightly-coupled and loosely-coupled branches
  • ora-13837 : invalid HASH_VALUE
  • ora-02144 : no option specified for ALTER CLUSTER
  • ora-12657 : No algorithms installed
  • ora-25208 : RELATIVE_MSGID must be specified if SEQUENCE_DEVIATION is BEFORE
  • ora-22061 : invalid format text [string]
  • ora-07613 : $GETJPIW failed in retrieving the user's process label
  • ora-38425 : attribute set used for an index object may not be unassigned
  • ora-31021 : Element definition not found
  • ora-29286 : internal error
  • ora-30658 : attempt was made to create a temporary table with EXTERNAL organization
  • ora-31687 : error creating worker process string with worker id string
  • ora-31640 : unable to open dump file "string" for read
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-30359 : Query rewrite is not supported on SYS materialized views
  • ora-07212 : slcpu: times error, unable to get cpu time.
  • ora-02087 : object locked by another process in same transaction
  • ora-02208 : duplicate MAXTRANS option specification
  • ora-19286 : XP0017 - unable to resolve call to function - string
  • ora-31448 : invalid value for change_source
  • ora-07231 : slemcc: invalid file handle, seals do not match.
  • ora-09837 : addCallback: could not add allocate a callback link.
  • ora-38410 : schema extension not allowed for the table name
  • ora-09926 : Unable to set effective privilege set of the server
  • ora-37005 : (AWLISTALL03) number readers
  • 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.