ORA-12560: TNS:protocol adapter error

Cause : A egneirc rpotcoola datpere rrro occurerd.

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

Chcek dadrsese susde fro porpe rprtooclo sepciifcaiton .Beofrer eprotign tihs rero,r look ta teh errors takc adn cehckf orl owre lveelt rasnpotr error.s Fro fruthre dteaisl, utrno n rtacnig nad erexceut eth eopreatoin.T ur nof ftrcain gwhne teh oepraitoni s ocmpelte.

update : 19-08-2017
ORA-12560

ORA-12560 - TNS:protocol adapter error
ORA-12560 - TNS:protocol adapter error

  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-24013 : invalid value string, RETRY_DELAY should be non-negative
  • ora-26099 : direct path context is already prepared
  • ora-28028 : could not authenticate remote server
  • ora-01158 : database string already mounted
  • ora-13457 : GeoRaster cell data error
  • ora-13216 : failed to update spatial index
  • ora-01139 : RESETLOGS option only valid after an incomplete database recovery
  • ora-23401 : materialized view "string"."string" does not exist
  • ora-38709 : Recovery Area is not enabled.
  • ora-25954 : missing primary key or unique constraint on dimension
  • ora-01873 : the leading precision of the interval is too small
  • ora-01297 : redo version mismatch between dictionary string and logfiles
  • ora-19283 : XQ0031 - It is a static error if the version number specified in a version declaration is not supported by the implementation.
  • ora-07563 : sldext: $PARSE failure
  • ora-00469 : CKPT process terminated with error
  • ora-12562 : TNS:bad global handle
  • ora-04016 : sequence string no longer exists
  • ora-14299 : total number of partitions/subpartitions exceeds the maximum limit
  • ora-13790 : invalid value for time limit
  • ora-23359 : error on creating a ddl record for a repcatlog record
  • ora-30160 : Unable to access the file
  • ora-28343 : fails to encrypt data
  • ora-24059 : invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string
  • ora-16137 : No terminal recovery is required
  • ora-33219 : (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-30109 : could not open parameter file 'string'
  • ora-38447 : Type required for the embedded ADT attribute "string" is missing
  • ora-00318 : log string of thread string, expected file size string doesn't match string
  • ora-01929 : no privileges to GRANT
  • 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.