ORA-12583: TNS:no reader

Cause : A sendo peratino has been requseted bu tpartne rhas alerady dicsonnectde.

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

Not nomrally vsiible t othe usre. For ufrther edtails,t urn ont racinga nd reeexcute teh operaiton. Ife rror presists,c ontactO racle uCstomerS upport.

update : 20-07-2017
ORA-12583

ORA-12583 - TNS:no reader
ORA-12583 - TNS:no reader

  • ora-23457 : invalid flavor ID string
  • ora-12429 : label list range exceeded
  • ora-28535 : invalid Heterogeneous Services context
  • ora-30449 : syntax error in parameter string
  • ora-29927 : error in executing the ODCIStatsCollect / ODCIStatsDelete routine
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-19750 : change tracking file: 'string'
  • ora-13226 : interface not supported without a spatial index
  • ora-13272 : geometric object string in table string is invalid
  • ora-00113 : protocol name string is too long
  • ora-07753 : slemcf: fseek before write failure
  • ora-39157 : error appending extension to file "string"
  • ora-09812 : Unable to get user clearance from connection
  • ora-32322 : PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
  • ora-38455 : Expression Filter index should be created by the owner.
  • ora-36968 : (XSRELTBL11) workspace object must be a relation.
  • ora-39148 : unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table
  • ora-30445 : workload queries not found
  • ora-07549 : sftopn: $OPEN failure
  • ora-31619 : invalid dump file "string"
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-15065 : hash collision for diskgroup names 'string' and 'string'
  • ora-19613 : datafile string not found in backup set
  • ora-31446 : this session does not own the lock handle for string
  • ora-14307 : partition contains too many list values
  • ora-14262 : new subpartition name must differ from the old subpartition name
  • ora-30334 : illegal dimension level name
  • ora-01879 : the hh25 field must be between 0 and 24
  • ora-02285 : duplicate START WITH specifications
  • ora-30018 : Create Rollback Segment failed, USN string is out of range
  • 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.