ORA-01501: CREATE DATABASE failed

Cause : Ane rrro occurerd udrign cerat edaatbaes

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

Se eacocmpnayign error.s

update : 27-05-2017
ORA-01501

ORA-01501 - CREATE DATABASE failed
ORA-01501 - CREATE DATABASE failed

  • ora-28113 : policy predicate has error
  • ora-07390 : sftopn: translate error, unable to translate file name.
  • ora-23371 : column string unknown in table string
  • ora-13850 : Tracing for client identifier string is not enabled
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-01035 : ORACLE only available to users with RESTRICTED SESSION privilege
  • ora-14639 : SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition
  • ora-16624 : broker protocol version mismatch detected
  • ora-02876 : smpini: Unable to attach to shared memory for PGA
  • ora-31218 : DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
  • ora-22908 : reference to NULL table value
  • ora-26664 : cannot create STREAMS process string
  • ora-16822 : new primary database not yet ready for standby database reinstatement
  • ora-29554 : unhandled Java out of memory condition
  • ora-14253 : table is not partitioned by Composite Range method
  • ora-13048 : recursive SQL fetch error
  • ora-19735 : wrong creation SCN - control file expects initial plugged-in datafile
  • ora-10653 : Table is in a cluster
  • ora-24753 : local transactions cannot be detached
  • ora-32017 : failure in updating SPFILE
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-13509 : error encountered during updates to a AWR table
  • ora-12562 : TNS:bad global handle
  • ora-19761 : block size string is not valid for change tracking file
  • ora-13521 : Unregister operation on local Database id (string) not allowed
  • ora-07305 : ksmcsg: illegal database buffer size.
  • ora-37128 : (XSCCOMP03) It is not possible to PARTITION over a base of a COMPRESSED COMPOSITE.
  • ora-27041 : unable to open file
  • ora-07614 : $CHANGE_CLASS failed in retrieving the user's process label
  • 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.