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 : 28-06-2017
ORA-28028

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

  • ora-30353 : expression not supported for query rewrite
  • ora-13624 : The task string is executing and cannot be deleted or modified.
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-25311 : %s not supported for non-persistent queue
  • ora-01125 : cannot disable media recovery - file string has online backup set
  • ora-07275 : unable to send signal to process
  • ora-14450 : attempt to access a transactional temp table already in use
  • ora-01534 : rollback segment 'string' doesn't exist
  • ora-30370 : set operators are not supported in this context
  • ora-13529 : Error occurred when flushing AWR table group
  • ora-36206 : (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-30964 : The XML Index was not usable.
  • ora-24395 : cannot reinitialize non-existent pool
  • ora-16781 : the status of redo transport service for a database is unknown
  • ora-39785 : SQL expressions returning ADT objects are not allowed in direct path
  • ora-24128 : partition name specified for a non-partitioned object
  • ora-02292 : integrity constraint (string.string) violated - child record found
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-25158 : Cannot specify RELY for foreign key if the associated primary key is NORELY
  • ora-25114 : invalid file number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-12084 : must use ALTER MATERIALIZED VIEW to alter "string"."string"
  • ora-29397 : cannot grant/revoke switch privilege for string
  • ora-12915 : Cannot alter dictionary managed tablespace to read write
  • ora-01118 : cannot add any more database files: limit of string exceeded
  • ora-16406 : Primary and standby database software version mismatch
  • ora-29537 : class or resource cannot be created or dropped directly
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-16731 : error executing dbms_logstdby.unskip_txn procedure
  • ora-32643 : invalid use of window function in MODEL rule
  • 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.