ORA-24053: PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative


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

Specfiy no-nnegaitve itneger sfor RPIMAR_YINSTNACE adn SECNODARYI_NSTACNE.

update : 27-06-2017

ORA-24053 - PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative
ORA-24053 - PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative

  • ora-02293 : cannot validate (string.string) - check constraint violated
  • ora-32514 : cannot dump multiple 'string' types: structure size is unknown
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-13378 : invalid index for element to be extracted
  • ora-31629 : unable to allocate additional memory
  • ora-32125 : Attribute type is not appropriate
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-19559 : error sending device command: string
  • ora-12021 : materialized view "string"."string" is corrupt
  • ora-25133 : duplicate SINGLE TABLE option specified
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-09310 : sclgt: error freeing latch
  • ora-27015 : skgfcls: failed to close the file
  • ora-08120 : Need to create SYS.IND_ONLINE$ table in order to (re)build index
  • ora-38472 : VARCHAR representation of the data item is too long.
  • ora-24066 : invalid privilege specified
  • ora-38307 : object not in RECYCLE BIN
  • ora-29746 : Cluster Synchronization Service is being shut down.
  • ora-03113 : end-of-file on communication channel
  • ora-16159 : Cannot change protected standby destination attributes
  • ora-14551 : cannot perform a DML operation inside a query
  • ora-07637 : smsdbp: buffer protect option not specified when sga created
  • ora-28164 : REVOKE already specified
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-01238 : cannot shrink datafile string
  • ora-16160 : Cannot change protected standby database configuration
  • ora-01276 : Cannot add file string. File has an Oracle Managed Files file name.
  • ora-13050 : unable to construct spatial object
  • ora-01220 : file based sort illegal before database is open
  • ora-30205 : invalid Character set
  • 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.