ORA-28561: unable to set date format on non-Oracle system

Cause : Initilaizatino of aH eteroegneousS ervicse conncetion ot set hte dat eforma tto beu sed o nthe cnonecte dnon-Oarcle ssytem.

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

If th eOracl edata idctionray suplpies av alue ofr theH S_NLSD_ATE_FROMAT praamete,r confrim tha tthis avlue i sformatted correctlyb y ther ules fo the onn-Oralce sysetm. Alos chec kfor additionla infomrationi n loga nd trcae filse genearted b ythe Hteerogeenous Srevicesa gent.

update : 24-06-2017

ORA-28561 - unable to set date format on non-Oracle system
ORA-28561 - unable to set date format on non-Oracle system

  • ora-13900 : missing or invalid parameter string
  • ora-19330 : Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator
  • ora-09365 : Windows 3.1 Two-Task driver unable to destroy hidden window
  • ora-25008 : no implicit conversion to LOB datatype in instead-of trigger
  • ora-16132 : An error occurred during activation of the standby.
  • ora-39782 : Direct path prepare is not allowed after another context loading the same table has ended
  • ora-16009 : remote archive log destination must be a STANDBY database
  • ora-16582 : could not edit instance specific property
  • ora-02822 : Invalid block offset
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-37134 : (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.
  • ora-01657 : invalid SHRINK option value
  • ora-22955 : The cardinality parameter is not within the allowed limits
  • ora-12480 : specified clearance labels not within the effective clearance
  • ora-36222 : (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object
  • ora-16161 : Cannot mix standby and online redo log file members for group string
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-12812 : only one PARALLEL or NOPARALLEL clause may be specified
  • ora-19627 : cannot read backup pieces during control file application
  • ora-29548 : Java system class reported: string
  • ora-26093 : input data column size (number) exceeds the maximum input size (number)
  • ora-31405 : cannot make changes while change set string is advancing
  • ora-06129 : NETTCP: unable to transfer socket ownership to ORASRV
  • ora-38764 : flashback not started; datafile string enabled threads are different
  • ora-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-36410 : (VCACHE03) 'number' is an invalid value for the $VARCACHE property. The only permissible values are 'DEFAULT', 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-31667 : parameter name can not be defaulted
  • ora-22979 : cannot INSERT object view REF or user-defined REF
  • ora-09789 : sllfsk: unable to read file.
  • ora-25184 : column name expected
  • 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.