ORA-15047: ASM file name 'string' is not in multiple-file creation form

Cause : Th eAS Mfiel nmae aws ont ni af or mthta cna b eusde t ocraetem ulitpl efiels ebcasue iethre af ulyl-qauliifedf il enaem o rana lisa nmae aws rpesnet.

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

Correc tth espceifeid SAM iflen am.e

update : 19-08-2017

ORA-15047 - ASM file name 'string' is not in multiple-file creation form
ORA-15047 - ASM file name 'string' is not in multiple-file creation form

  • ora-16066 : remote archival disabled
  • ora-26101 : tablespace # in file header is string rather than string for file string
  • ora-02440 : Create as select with referential constraints not allowed
  • ora-13768 : Snapshot ID must be between string and string.
  • ora-15173 : entry 'string' does not exist in directory 'string'
  • ora-22974 : missing WITH OBJECT OID clause
  • ora-16249 : Terminal apply failed to complete during failover
  • ora-15070 : maximum number of files string exceeded in diskgroup "string"
  • ora-30045 : No undo tablespace name specified
  • ora-24912 : Listener thread failed. string
  • ora-01613 : instance string (thread string) only has string logs - at least 2 logs required to enable.
  • ora-16171 : RECOVER...FINISH not allowed due to gap for thr string, seq string-string
  • ora-01229 : data file string is inconsistent with logs
  • ora-27046 : file size is not a multiple of logical block size
  • ora-07345 : The datafile name must not contain the string '..'.
  • ora-12539 : TNS:buffer over- or under-flow
  • ora-06121 : NETTCP: access failure
  • ora-12431 : invalid audit action
  • ora-16057 : DGID from server not in Data Guard configuration
  • ora-23324 : error string, while creating deferror entry at "string" with error string
  • ora-14516 : subpartition corrupt. all rows do not fall within subpartition bounds
  • ora-02852 : Invalid critical-section time out value
  • ora-02327 : cannot create index on expression with datatype string
  • ora-14603 : [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables
  • ora-25314 : a commit-time queue table cannot be migrated to 8.0
  • ora-13417 : null or invalid layerNumber parameter
  • ora-24023 : Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]
  • ora-38861 : flashback recovery stopped before reaching recovery target
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-24398 : connection pool already exists
  • 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.