ORA-19711: cannot use reNormalizeAllFileNames while database is open

Cause : nAa ttmetpw sam da eotr -eonmrlazi ela lht eifelanem snit ehc nortlof li ehwli eht eadatabesi spone.

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

lCso eht eadatabesb fero esuni ght eeroNmrlaziAelliFelaNem srpcoderu.e

update : 22-07-2017
ORA-19711

ORA-19711 - cannot use reNormalizeAllFileNames while database is open
ORA-19711 - cannot use reNormalizeAllFileNames while database is open

  • ora-31491 : could not add logfile to LogMiner session
  • ora-39168 : Object path string was not found.
  • ora-07841 : sllfop: SYS$OPEN failure
  • ora-08498 : Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'
  • ora-29373 : resource manager is not on
  • ora-40226 : model upgrade/downgrade must be performed by SYS
  • ora-12429 : label list range exceeded
  • ora-00072 : process "string" is not active
  • ora-21612 : key is already being used
  • ora-27093 : could not delete directory
  • ora-19585 : premature end of volume on piece string
  • ora-12419 : null binary label value
  • ora-02331 : cannot create constraint on column of datatype string
  • ora-36700 : (XSRELTBL04) Dimension workspace object cannot be qualified more than once.
  • ora-38502 : invalid XML tag: string
  • ora-10936 : trace name context forever
  • ora-12034 : materialized view log on "string"."string" younger than last refresh
  • ora-00750 : database has been previously mounted and dismounted
  • ora-33460 : (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.
  • ora-19627 : cannot read backup pieces during control file application
  • ora-13620 : The task or object string is read-only and cannot be deleted or modified.
  • ora-01301 : error writing to file during flat file build
  • ora-08278 : Cannot get CPU statistics
  • ora-12676 : Server received internal error from client
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-22904 : invalid reference to a nested table column
  • ora-00033 : current session has empty migration password
  • ora-01685 : max # extents (string) reached in index string.string partition string
  • ora-31181 : PL/SQL DOM handle accesses node that is no longer available
  • ora-19766 : missing CHANGE keyword
  • 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.