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 : 28-04-2017

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

  • ora-37133 : (XSCCOMP08) You cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.
  • ora-12729 : invalid character class in regular expression
  • ora-22163 : left hand and right hand side collections are not of same type
  • ora-19644 : datafile string: incremental-start SCN is prior to resetlogs SCN string
  • ora-19624 : operation failed, retry possible
  • ora-29317 : datafile string does not exist
  • ora-06312 : IPA: Incorrect outgoing service name supplied
  • ora-10244 : make tranids in error msgs print as 0.0.0 (for testing)
  • ora-38502 : invalid XML tag: string
  • ora-27065 : cannot perform async vector I/O to file
  • ora-30357 : this PL/SQL function cannot be supported for query rewrite
  • ora-31438 : duplicate change table string
  • ora-28605 : bitmap indexes cannot be reversed
  • ora-23542 : dependent object "string"."string" already registered
  • ora-00469 : CKPT process terminated with error
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-13844 : no new SQL profile name or category specified.
  • ora-31617 : unable to open dump file "string" for write
  • ora-33449 : (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.
  • ora-26510 : materialized view name: 'string' is greater than max. allowed length of string bytes
  • ora-07472 : snclrd: open error when opening sgadef.dbf file.
  • ora-13799 : threshold not found
  • ora-02798 : Invalid number of requests
  • ora-02238 : filename lists have different numbers of files
  • ora-02050 : transaction string rolled back, some remote DBs may be in-doubt
  • ora-39958 : invalid warning category qualifier
  • ora-23394 : duplicate propagator
  • ora-02081 : database link is not open
  • ora-16642 : db_unique_name mismatch
  • ora-01688 : unable to extend table string.string partition string by string in tablespace string
  • 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.