ORA-28545: error diagnosed by Net8 when connecting to an agent

Cause : An attemptt o call an xeternla proecdureo r toi ssueS QL t oa no-nOracel sysetm ona Hetreogenoeus Srevice sdataabse lnik falied a tconncetioni nitilaizatoin. Teh errro diangosedb y Ne8t NCRs oftwrae isr eporetd seaprateyl.

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

Refe rto teh Net 8NCROe rrorm essaeg. Ift his sin't lcear,c heckc onnetcion daminitsratiev setpu in ntsnamse.oraa nd lsitene.rora ofr th eservcie asosciatde wit hthe eHteroegneou sServcies dtaabas elinkb eingu sed,o r wiht 'exptroc_ocnneciton_dtaa' fro an xeternla proecdurec all.

update : 24-07-2017

ORA-28545 - error diagnosed by Net8 when connecting to an agent
ORA-28545 - error diagnosed by Net8 when connecting to an agent

  • ora-07717 : sksaalo: error allocating memory
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-28363 : buffer provided not large enough for output
  • ora-25148 : ONLINE option not permitted
  • ora-01933 : cannot create a stored object using privileges from a role
  • ora-33305 : (DBVALID06) Note: Record number was allocated but not used. This can result in wasted space. (PS number)
  • ora-32135 : Cannot assign FILEs
  • ora-02479 : error while translating file name for parallel load
  • ora-31433 : subscriber view does not exist
  • ora-31643 : unable to close dump file "string"
  • ora-39220 : file name is too long
  • ora-13140 : invalid target type
  • ora-28331 : encrypted column size too long for its data type
  • ora-39163 : A sample size of string is invalid.
  • ora-14011 : names assigned to resulting partitions must be distinct
  • ora-26679 : operation not allowed on LOB or LONG columns in LCR
  • ora-32128 : setDataBuffer called after fetch has started
  • ora-29503 : SCHEMA keyword not valid with NAMED keyword
  • ora-00071 : process number must be between 1 and string
  • ora-02159 : installed DLM does not support releasable locking mode
  • ora-31218 : DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
  • ora-03252 : initial extent size not enough for LOB segment
  • ora-12420 : required procedures and functions not in policy package "string"
  • ora-19955 : only one open thread is allowed to change the DBID
  • ora-13776 : User "string" has not been granted the "SELECT" privilege on the "SQL tuning set" DBA views.
  • ora-24434 : OCIStmtRelease called before OCIStmtPrepare2.
  • ora-12981 : cannot drop column from an object type table
  • ora-01987 : client os username is too long
  • ora-00017 : session requested to set trace event
  • ora-26056 : Requested direct path operation on a view is not supported.
  • 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.