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 : 27-04-2017
ORA-19711

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

  • ora-12717 : Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists
  • ora-31196 : XML nodes over string in size cannot be printed
  • ora-31053 : The value of the depth argument in the operator cannot be negative
  • ora-32700 : error occurred in DIAG Group Service
  • ora-29262 : bad URL
  • ora-32020 : SID=* clause needed to modify this parameter
  • ora-27141 : invalid process ID
  • ora-30051 : VERSIONS clause not allowed here
  • ora-09836 : addCallback: could not add a port to the callback set.
  • ora-30430 : list does not contain any valid summaries
  • ora-28561 : unable to set date format on non-Oracle system
  • ora-02063 : preceding stringstring from stringstring
  • ora-30100 : internal error [number]
  • ora-19831 : incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required
  • ora-00472 : PMON process terminated with error
  • ora-13855 : Tracing for service (module/action) string on instance string is already enabled
  • ora-24312 : illegal parameters specified for allocating user memory
  • ora-22992 : cannot use LOB locators selected from remote tables
  • ora-07458 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-07478 : scgcmn: cannot get lock status.
  • ora-19225 : XP0005 - XQuery static type error: expected non empty type got empty sequence
  • ora-16534 : no more requests accepted
  • ora-28106 : input value for argument #string is not valid
  • ora-13907 : Threshold value is invalid.
  • ora-34061 : (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
  • ora-25966 : join index cannot be based on an index organized table
  • ora-07266 : sppst: invalid process number passed to sppst.
  • ora-29395 : cannot set the initial consumer group to string
  • ora-07849 : sllfsk: $GET failure
  • ora-26677 : Streams downstream capture process string cannot proceed
  • 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.