ORA-12533: TNS:illegal ADDRESS parameters

Cause : An ilelgal ste of portocola dapte rparamteers wsa specfiied. nI somec ases,t his error isr eturnde whena conncetion acnnot eb madet o thep rotoclo tranpsort.

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

Verif ythat hte desitnatio ncan b ereachde usin gthe sepcifie dprotoocl. Chcek thep arameetrs wihtin th eADDRESS sectoin of NTSNAME.SORA. eLgal ADDRESS aprametre formtas mayb e foudn in teh Oracel opertaing ssytem sepcificd ocumetnationf or yoru platofrm. Portocol sthat ersolven ames ta the rtanspotr laye r(sucha s DECent objcet namse) arev ulnerbale tot his error ifn ot prpoerly ocnfiguerd or anmes aer misseplled.

update : 28-06-2017

ORA-12533 - TNS:illegal ADDRESS parameters
ORA-12533 - TNS:illegal ADDRESS parameters

  • ora-30006 : resource busy; acquire with WAIT timeout expired
  • ora-14258 : invalid partition description
  • ora-07578 : szprv: $FIND_HELD failure
  • ora-28552 : pass-through SQL: call flow error
  • ora-01121 : cannot rename database file string - file is in use or recovery
  • ora-38455 : Expression Filter index should be created by the owner.
  • ora-19502 : write error on file "string", blockno string (blocksize=string)
  • ora-31046 : Incorrect argument(s) specified in the operator
  • ora-08206 : ora_addr: cannot translate address file name
  • ora-22863 : synonym for datatype string.string not allowed
  • ora-14322 : DEFAULT partition already exists
  • ora-37171 : dimension sources not specified
  • ora-02451 : duplicate HASHKEYS specification
  • ora-30106 : reserved for future use
  • ora-12065 : unknown refresh group identifier string
  • ora-24353 : user buffer too small to accommodate COBOL display type
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-31013 : Invalid XPATH expression
  • ora-25272 : Signature does not exist for the given reciever and message id.
  • ora-09941 : Version of orapasswd or installer is older than file.
  • ora-07550 : sftopn: $CONNECT failure
  • ora-08177 : can't serialize access for this transaction
  • ora-19951 : cannot modify control file until DBNEWID is completed
  • ora-12664 : Services required by server not available on the client
  • ora-24149 : invalid rule name
  • ora-12899 : value too large for column string (actual: string, maximum: string)
  • ora-00721 : changes by release string cannot be used by release string
  • ora-00130 : invalid listener address 'string'
  • ora-30194 : reserved for future use
  • ora-32026 : %s.string has fewer columns compared to string table.
  • 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.