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 : 23-09-2017

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

  • ora-14080 : partition cannot be split along the specified high bound
  • ora-16627 : operation disallowed since no standby databases would remain to support protection mode
  • ora-02767 : Less than one request descriptor was allocated per server
  • ora-12982 : cannot drop column from a nested table
  • ora-30046 : Undo tablespace string not found in control file.
  • ora-02001 : user SYS is not permitted to create indexes with freelist groups
  • ora-22908 : reference to NULL table value
  • ora-04054 : database link string does not exist
  • ora-08005 : specified row does not exist
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-19686 : SPFILE not restored due to string
  • ora-31526 : could not find source table string.string for CDC change table string.string
  • ora-24909 : call in progress. Current operation cancelled
  • ora-00307 : requested INSTANCE_NUMBER out of range, maximum is string
  • ora-02791 : Unable to open file for use with asynchronous I/O
  • ora-25228 : timeout or end-of-fetch during message dequeue from string.string
  • ora-32626 : illegal bounds or increment in MODEL FOR loop
  • ora-13844 : no new SQL profile name or category specified.
  • ora-01104 : number of control files (string) does not equal string
  • ora-15199 : Internal ASM tracing event number 15199
  • ora-22057 : bad integer length [string]
  • ora-39121 : Table string can't be replaced, data will be skipped. Failing error is: string
  • ora-13352 : the coordinates do not describe a circle
  • ora-28040 : No matching authentication protocol
  • ora-31432 : invalid source table
  • ora-26511 : master table 'string.string' not found
  • ora-12996 : cannot drop system-generated virtual column
  • ora-02208 : duplicate MAXTRANS option specification
  • ora-04073 : column list not valid for this trigger type
  • ora-39029 : worker string with process name "string" prematurely terminated
  • 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.