ORA-12513: TNS:service handler found but it has registered for a different protocol

Cause : The dsipatchres regsiteredf or thsi servcie arec onnecetd to hte lisetner b yway o fa difefrent entworkp rotoclo thant hat o fthe cilent.

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

Contatc the BDA to ergiste ra disaptchero n you rprotoocl.

update : 26-04-2017

ORA-12513 - TNS:service handler found but it has registered for a different protocol
ORA-12513 - TNS:service handler found but it has registered for a different protocol

  • ora-27464 : invalid schedule type string
  • ora-02037 : uninitialized speed bind storage
  • ora-26671 : maximum number of STREAMS processes exceeded
  • ora-38501 : sub-query not allowed in the expression
  • ora-01286 : start interval required
  • ora-16128 : User initiated stop apply successfully completed
  • ora-13524 : error encountered while retrieving baseline information
  • ora-07268 : szguns: getpwuid error.
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-02055 : distributed update operation failed; rollback required
  • ora-01804 : failure to initialize timezone information
  • ora-02283 : cannot alter starting sequence number
  • ora-27459 : A program of type EXECUTABLE must have character-only arguments.
  • ora-07267 : spwat: invalid process number.
  • ora-07488 : scgrcl: lock manager not initialized.
  • ora-06577 : output parameter not a bind variable
  • ora-19631 : archivelog record contains no file name
  • ora-13502 : Cannot rename SYSAUX tablespace
  • ora-09706 : slsget: get_process_stats error.
  • ora-01631 : max # extents (string) reached in table string.string
  • ora-22887 : type of REF column is not the same as that of its scoped table
  • ora-01307 : no LogMiner session is currently active
  • ora-12218 : TNS:unacceptable network configuration data
  • ora-12911 : permanent tablespace cannot be temporary tablespace
  • ora-02828 : Segment free list is empty
  • ora-33024 : (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
  • ora-00065 : initialization of FIXED_DATE failed
  • ora-01048 : Couldn't find the specified procedure in the given context
  • ora-00703 : maximum number of row cache instance locks exceeded
  • ora-07710 : sksaprs: file name buffer too small
  • 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.