ORA-13504: No SYSAUX datafile clause specified

Cause : If Create Database has the datafile clause, then SYSAUX datafile clause has to be specified, unless using OMF.

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

Specify the SYSAUX datafile clause.

update : 27-06-2017

ORA-13504 - No SYSAUX datafile clause specified
ORA-13504 - No SYSAUX datafile clause specified

  • ora-26005 : Invalid handle for direct path load
  • ora-04082 : NEW or OLD references not allowed in table level triggers
  • ora-30755 : error during expansion of view hierarchy
  • ora-12706 : this CREATE DATABASE character set is not allowed
  • ora-14104 : RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
  • ora-31445 : invalid lock handle while acquiring lock on string
  • ora-02175 : invalid rollback segment name
  • ora-38734 : Flashback log is inconsistent; belongs to another database.
  • ora-13624 : The task string is executing and cannot be deleted or modified.
  • ora-38605 : FI not enough memory(stringK) for candidate generation(stringK)
  • ora-38464 : expression set is not empty.
  • ora-26721 : enqueue of the LCR not allowed
  • ora-12436 : no policy options specified
  • ora-38403 : attribute set name may not be longer than 22 characters
  • ora-02191 : correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
  • ora-02266 : unique/primary keys in table referenced by enabled foreign keys
  • ora-07490 : scgrcl: cannot convert lock.
  • ora-01571 : redo version string incompatible with ORACLE version string
  • ora-02832 : Segment deallocation failed - segment not on list
  • ora-09799 : File label retrieval failed.
  • ora-31670 : Username argument must be specified and non-null.
  • ora-01308 : initialization parameter utl_file_dir is not set
  • ora-26515 : no master log available for 'string.string'
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-30941 : Cannot specify empty URI for non-default namespace 'string'
  • ora-07804 : slpdtb: number too large for supplied buffer
  • ora-01664 : Transaction which has expanded the Sort Segment has aborted
  • ora-30683 : failure establishing connection to debugger
  • ora-16001 : database already open for read-only access by another instance
  • ora-23622 : Operation string.string.string is in progress.
  • 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.