ORA-28028: could not authenticate remote server

Cause : During the course of opening a privileged database link, the remote server was not securely identified using the network security service. Additional errors should follow.

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

Consult the network security service documentation on how to properly configure the remote server.

update : 17-08-2017

ORA-28028 - could not authenticate remote server
ORA-28028 - could not authenticate remote server

  • ora-39087 : directory name string is invalid
  • ora-13197 : element string.string.string is out of range
  • ora-01529 : error closing file 'string'
  • ora-06701 : TLI Driver: incorrect number of bytes written
  • ora-10648 : Tablespace SYSAUX is not offline
  • ora-07754 : slemcf: fwrite failure
  • ora-14078 : you may not drop the highest partition of a GLOBAL index
  • ora-25466 : data not specified for variable name: string
  • ora-38498 : invalid stored attribute for the index object : string
  • ora-06122 : NETTCP: setup failure
  • ora-16612 : string value too long for attribute "string"
  • ora-19718 : length for command id longer than string
  • ora-37153 : unknown exception caught: (case string)
  • ora-37005 : (AWLISTALL03) number readers
  • ora-33218 : (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
  • ora-12620 : TNS:requested characteristic not available
  • ora-13632 : The user cancelled the current operation.
  • ora-09924 : Can't spawn process - core dump directory not created properly
  • ora-10920 : Cannot offline tablespace belonging to default temporary tablespace group
  • ora-23357 : the propagator does not exist
  • ora-02058 : no prepared transaction found with ID string
  • ora-29336 : Internal error [string] [string] from DBMS_PLUGTS
  • ora-26663 : error queue for apply process string must be empty
  • ora-27502 : IPC error deleting OSD context
  • ora-29387 : no top-plans found in the pending area
  • ora-30111 : no closing quote for value 'string'
  • ora-03112 : a server linked as single-task cannot use SQL*Net
  • ora-29289 : directory access denied
  • ora-12661 : Protocol authentication to be used
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • 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.