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

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

  • ora-36768 : (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.
  • ora-13503 : Creating SYSAUX tablespace with invalid attributes
  • ora-28234 : key length too short
  • ora-39782 : Direct path prepare is not allowed after another context loading the same table has ended
  • ora-30438 : unable to access named pipe 'string'
  • ora-02875 : smpini: Unable to get shared memory for PGA
  • ora-30395 : dimension options require the COMPATIBLE parameter to be string or greater
  • ora-04016 : sequence string no longer exists
  • ora-38102 : Invalid column in the INSERT WHERE Clause: string
  • ora-21709 : cannot refresh an object that has been modified
  • ora-25288 : AQ HTTP propagation encountered error, status-code number, string
  • ora-24776 : cannot start a new transaction
  • ora-16551 : short string copied
  • ora-16538 : no match on requested item
  • ora-13127 : failed to generate target partition
  • ora-32100 : operation invalid on transient object
  • ora-09967 : unable to create or open lock file
  • ora-30338 : illegal dimension hierachy name
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • ora-28337 : the specified index may not be defined on an encrypted column
  • ora-06138 : NETTCP: error during connection handshake
  • ora-36912 : (XSAGDNGL48) In AGGMAP workspace object, MODEL workspace object cannot be simultaneous.
  • ora-10584 : Can not invoke parallel recovery for test recovery
  • ora-19914 : unable to encrypt backup
  • ora-01484 : arrays can only be bound to PL/SQL statements
  • ora-39212 : installation error: XSL stylesheets not loaded correctly
  • ora-30044 : 'Retention' can only specified for undo tablespace
  • ora-26575 : remote database does not support replication parallel propagation
  • ora-39138 : Insufficient privileges to load data not in your schema
  • 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.