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 : 23-01-2017
ORA-02144

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

  • ora-13901 : Object string was not found.
  • ora-36271 : (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.
  • ora-23307 : replicated schema string already exists
  • ora-19772 : change tracking file name exceeds limit of string characters
  • ora-09854 : snyPortInfo: bad return code from request.
  • ora-00205 : error in identifying control file, check alert log for more info
  • ora-19272 : XQ0052 - invalid atomic value in attribute or element constructor
  • ora-27102 : out of memory
  • ora-07470 : snclget: cannot get cluster number.
  • ora-22974 : missing WITH OBJECT OID clause
  • ora-19831 : incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required
  • ora-16235 : DDL skipped because import has occurred
  • ora-29392 : cpu parameters for level string for plan string must be zero
  • ora-28180 : multiple authentication methods provided by proxy
  • ora-07215 : slsget: getrusage error.
  • ora-00107 : failed to connect to ORACLE listener process
  • ora-14305 : List value 'string' specified twice in partition 'string'
  • ora-32807 : message system link string already exists
  • ora-01492 : LIST option not valid
  • ora-02835 : Server unable to send signal to client
  • ora-16181 : SGA specified for Logical Standby is too large
  • ora-06323 : IPA: Cause event error
  • ora-19656 : cannot backup, copy, or delete online log string
  • ora-12042 : cannot alter job_queue_processes in single process mode
  • ora-23500 : cannot switch master for a multi-tier materialized view repgroup "string"."string"
  • ora-12539 : TNS:buffer over- or under-flow
  • ora-22151 : cannot resize non-zero variable-length array to zero elements
  • ora-02728 : osnfop: access error on oracle executable
  • ora-12527 : TNS:listener: all instances are in restricted mode or blocking new connections
  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • 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.