ORA-12222: TNS:no support is available for the protocol indicated

Cause : The protocol requested in the ADDRESS portion of the connect descriptor identified through the net service name is not available. If the supplied ADDRESS is typographically correct then support for that protocol is not installed.

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

Install support for the protocol or correct typographical error, as appropriate. Note: if the supplied address was derived from resolving the net service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA) or in the directory server.

update : 24-07-2017

ORA-12222 - TNS:no support is available for the protocol indicated
ORA-12222 - TNS:no support is available for the protocol indicated

  • ora-01224 : group number in header string does not match GROUP string
  • ora-30442 : can not find the definition for filter string
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-36176 : (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE.
  • ora-16734 : error executing dbms_logstdby.skip_error procedure
  • ora-00229 : operation disallowed: already hold snapshot control file enqueue
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-30551 : The index depends on a package/type body which does not exist
  • ora-00322 : log string of thread string is not current copy
  • ora-02801 : Operations timed out
  • ora-23425 : invalid materialized view identifier string
  • ora-12992 : cannot drop parent key column
  • ora-00253 : character limit string exceeded by archive destination string string
  • ora-08468 : mask option string is not supported
  • ora-14629 : cannot drop the only subpartition of a partition
  • ora-02256 : number of referencing columns must match referenced columns
  • ora-19580 : %s conversation not active
  • ora-09984 : SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
  • ora-39126 : Worker unexpected fatal error in string [string] string
  • ora-15114 : missing or invalid ASM file name
  • ora-16656 : higher DRC UID sequence number detected
  • ora-23363 : mismatch of mview base table "string" at master and mview site
  • ora-06439 : ssaio: the asynchronous write returned incorrect number of bytes
  • ora-22616 : image is not of Oracle 8.1 format
  • ora-21606 : can not free this object
  • ora-03275 : duplicate DEALLOCATE option specification
  • ora-01438 : value larger than specified precision allowed for this column
  • ora-38304 : missing or invalid user name
  • ora-23344 : constraint (string.string) does not exist
  • ora-01023 : Cursor context not found (Invalid cursor number)
  • 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.