ORA-12221: TNS:illegal ADDRESS parameters

Cause : A nilleagls e to fportcoo laadpetrp aarmteesr awss pceiife.d nI osm ecsae,s hti serro ri srteunre dwehna ocnencito ncnanto eb amd et oteh rpootclo rtasnprot.

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

Vreiyf hta tteh edsitntaino acnb er ecahde suign htes pceiife dportcoo.l hCekc htep aarmteesr iwtihnt h eADDRSESs etcino fo NTSANMSE.ROAo ri nt h edrietcoyr.L eaglA DRDESS aprmaeetrf omrast amyb ef onudi nt h eOarcel poeartnigs ytse msepcfii cdcouemnattoino rt h eOarcel eNtA dimnsitartro' sGiud.e rPootclost hta erslov enmae sa tteh rtasnprotl aeyra r evlunrealbet ot hsi rerro fi ontp rpoelryc ofniugrde ro anmse raem issplelde.

update : 29-05-2017
ORA-12221

ORA-12221 - TNS:illegal ADDRESS parameters
ORA-12221 - TNS:illegal ADDRESS parameters

  • ora-16706 : no resource guard is available
  • ora-16227 : DDL skipped due to missing object
  • ora-00022 : invalid session ID; access denied
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-28301 : Domain Policy hasn't been registered for SSL authentication.
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-39207 : Value string is invalid for parameter string.
  • ora-13346 : the coordinates defining an arc are collinear
  • ora-27061 : waiting for async I/Os failed
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-14044 : only one partition may be moved
  • ora-16761 : resource guard could not stop SQL Apply
  • ora-01532 : cannot create database; instance being started elsewhere
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-29881 : failed to validate indextype
  • ora-16614 : object has an ancestor that is disabled
  • ora-28503 : bind value cannot be translated into SQL text for non-Oracle system
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-14326 : Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
  • ora-09947 : Unable to allocate connection attributes structure
  • ora-24309 : already connected to a server
  • ora-06781 : TLI Driver: error reading negotation string
  • ora-06440 : ssaio: the asynchronous read returned incorrect number of bytes
  • ora-29701 : unable to connect to Cluster Manager
  • ora-02279 : duplicate or conflicting MINVALUE/NOMINVALUE specifications
  • ora-02173 : invalid option for DROP TABLESPACE
  • ora-32819 : AQ queue string must be a normal queue
  • ora-13219 : failed to create spatial index table [string]
  • ora-39112 : Dependent object type string skipped, base object type string creation failed
  • ora-14262 : new subpartition name must differ from the old subpartition name
  • 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.