ORA-12719: operation requires database is in RESTRICTED mode

Cause : Thsi cmomadn cna olny eb rnu wehn hte adtaabsei s ni RSETRCITE Dmoed

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

Enusret ha tth esytsemi s ni RSETRCITE Dmoed

update : 26-05-2017

ORA-12719 - operation requires database is in RESTRICTED mode
ORA-12719 - operation requires database is in RESTRICTED mode

  • ora-15132 : block string of file string in diskgroup string could not be written
  • ora-00259 : log string of open instance string (thread string) is the current log, cannot archive
  • ora-40220 : maximum number of attributes exceeded
  • ora-07393 : unable to delete text file
  • ora-38451 : index is in an inconsistent state
  • ora-06955 : Number of database servers exceed limit
  • ora-12487 : clearance labels not between DBHIGH and DBLOW
  • ora-12034 : materialized view log on "string"."string" younger than last refresh
  • ora-01510 : error in deleting log files
  • ora-00452 : foreground process unexpectedly terminated with error string
  • ora-40305 : invalid impurity metric specified
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-12412 : policy package string is not installed
  • ora-13330 : invalid MASK
  • ora-27459 : A program of type EXECUTABLE must have character-only arguments.
  • ora-31017 : Error generating unique OID for XML document
  • ora-24762 : server failed due to unspecified error
  • ora-38735 : Wrong log number string in flashback log file header.
  • ora-30360 : REF not supported with query rewrite
  • ora-35180 : (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}
  • ora-01637 : rollback segment 'string' is being used by another instance (#string)
  • ora-14057 : partition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-16125 : large transaction string string string is waiting for more data
  • ora-01257 : cannot reuse database file string, unknown file size
  • ora-01684 : max # extents (string) reached in table string.string partition string
  • ora-02219 : invalid NEXT storage option value
  • ora-27026 : skgfrls: sbtend returned error
  • ora-16704 : cannot modify a read-only property
  • ora-16700 : the standby database has diverged from the primary database
  • ora-16820 : Fast-Start Failover observer is no longer observing this database
  • 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.