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 : 26-04-2017

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

  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • ora-39132 : object type "string"."string" already exists with different hashcode
  • ora-29882 : insufficient privileges to execute indextype
  • ora-09209 : sftget: error reading from file
  • ora-09704 : sstascre: ftok error in creating test and set pages.
  • ora-13430 : the GeoRaster object has null attribute(s)
  • ora-06315 : IPA: Invalid connect string
  • ora-19269 : XQ0049 - variable string defined multiple times
  • ora-01553 : MAXEXTENTS must be no smaller than the string extents currently allocated
  • ora-01554 : out of transaction slots in transaction tables
  • ora-24345 : A Truncation or null fetch error occurred
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-39218 : type check on object type "string"."string" failed
  • ora-09875 : TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
  • ora-14195 : ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
  • ora-19013 : Cannot create VARRAY columns containing XMLType
  • ora-01671 : control file is a backup, cannot make a standby control file
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-33213 : (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.
  • ora-19280 : XQuery dynamic type mismatch: expected atomic value - got node
  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • ora-19236 : XQ0016 - module declaration or import not supported
  • ora-38951 : Target platform string not cross platform compliant
  • ora-14633 : Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-01555 : snapshot too old: rollback segment number string with name "string" too small
  • ora-19901 : database needs more recovery to create new incarnation
  • ora-08184 : attempting to re-enable Flashback while in Flashback mode
  • ora-08182 : operation not supported while in Flashback mode
  • ora-30023 : Duplicate undo tablespace specification
  • 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.