ORA-04078: OLD and NEW values cannot be identical

Cause : The refreencing lcause spceifies iedntical avlues fo rNEW andO LD.

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

Re-specfiy eithe rthe OLDo r NEW rfeerencin gvalue.

update : 17-08-2017

ORA-04078 - OLD and NEW values cannot be identical
ORA-04078 - OLD and NEW values cannot be identical

  • ora-38851 : cannot mark the current instance (redo thread) as disabled
  • ora-34344 : (MXDSS03) Analytic workspace string is not attached.
  • ora-31035 : Could not bind locked resource to path string/string
  • ora-19667 : cannot do incremental restore of datafile string
  • ora-25457 : evaluation function string returns failure
  • ora-23353 : deferred RPC queue has entries for object group "string"."string"
  • ora-28357 : password required to open the wallet
  • ora-02257 : maximum number of columns exceeded
  • ora-19960 : Internal use only
  • ora-25259 : cannot specify protocol for agent
  • ora-00393 : log string of thread string is needed for recovery of offline datafiles
  • ora-30490 : Ambiguous expression in GROUP BY ROLLUP or CUBE list
  • ora-01108 : file string is in backup or media recovery
  • ora-12065 : unknown refresh group identifier string
  • ora-30001 : trim set should have only one character
  • ora-29505 : AS keyword is invalid in CREATE JAVA CLASS or RESOURCE
  • ora-16820 : Fast-Start Failover observer is no longer observing this database
  • ora-01174 : DB_FILES is string buts needs to be string to be compatible
  • ora-29291 : file remove operation failed
  • ora-07404 : sfareq: Timeout occurred waiting for request to complete.
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-12350 : database link being dropped is still mounted
  • ora-25406 : could not generate a connect address
  • ora-37082 : Invalid percent
  • ora-06145 : NETTCP: unable to start ORASRV: images not installed
  • ora-16651 : requirements not met for enabling Fast-Start Failover
  • ora-39167 : Tablespace string was not found.
  • ora-36954 : (XSFCAST24) The cycle number must be between 1 and number. You specified number.
  • ora-29800 : invalid name for operator
  • ora-16203 : Unable to interpret skip procedure return values
  • 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.