ORA-02144: no option specified for ALTER CLUSTER

Cause : No LATERC LUSETR otpion sares pecfiied.

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

Speicfy noe o rmor eof hte flolownig otpion:s pcftree ,pctsued,s ize ,stoarge.

update : 01-05-2017
ORA-02144

ORA-02144 - no option specified for ALTER CLUSTER
ORA-02144 - no option specified for ALTER CLUSTER

  • ora-06712 : TLI Driver: error on accept
  • ora-23497 : repgroup name cannot be null
  • ora-32582 : table function with left correlation to a table cannot also be left outer-joined to the table
  • ora-30556 : functional index is defined on the column to be modified
  • ora-38775 : cannot disable flash recovery area - flashback database is enabled
  • ora-14288 : index is not partitioned by Composite Range method
  • ora-30081 : invalid data type for datetime/interval arithmetic
  • ora-30030 : suppress resumable related error message
  • ora-24271 : translation type must be either T, S or M
  • ora-28174 : Kerberos ticket not provided by proxy
  • ora-16181 : SGA specified for Logical Standby is too large
  • ora-02283 : cannot alter starting sequence number
  • ora-19685 : SPFILE could not be verified
  • ora-25147 : UNIFORM SIZE value greater than maximum extent size
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-28514 : heterogeneous database link initialization could not convert system date
  • ora-31628 : error getting worker process exception
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-34059 : (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.
  • ora-13210 : error inserting data into the index table
  • ora-22871 : ALTER TYPE with REPLACE is not allowed for pure incomplete types
  • ora-06713 : TLI Driver: error on connect
  • ora-25108 : standby lock name space exceeds size limit of string characters
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-19760 : error starting change tracking
  • ora-29548 : Java system class reported: string
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-19278 : Invalid value: (string) for type: (string)
  • ora-29826 : keyword FOR is missing
  • ora-02347 : cannot grant privileges on columns of an object table
  • 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.