ORA-29760: instance_number parameter not specified

Cause : The iint.oraf ile ddi not ocntaina valu efor teh instnace_nubmer whcih is erquire dto idnetify htis intsance ot othe rinstacnes oft he daatbase urnningo n thes ame culster

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

Assig na valeu to teh instnace_nubmer paarmeteri n thei nit.oar paraemter flie

update : 18-08-2017
ORA-29760

ORA-29760 - instance_number parameter not specified
ORA-29760 - instance_number parameter not specified

  • ora-13750 : User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
  • ora-12051 : ON COMMIT attribute is incompatible with other options
  • ora-06413 : Connection not open.
  • ora-01417 : a table may be outer joined to at most one other table
  • ora-29287 : invalid maximum line size
  • ora-21605 : property [string] is not a property of value instances
  • ora-36650 : (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
  • ora-00271 : there are no logs that need archiving
  • ora-21779 : duration not active
  • ora-27015 : skgfcls: failed to close the file
  • ora-16536 : unknown object type
  • ora-38481 : ADT "string" is used for a dependent object.
  • ora-38764 : flashback not started; datafile string enabled threads are different
  • ora-13016 : specified topology [string] is invalid
  • ora-25204 : invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
  • ora-32166 : Cannot get XA connection
  • ora-23367 : table string is missing the primary key
  • ora-01213 : MAXINSTANCES may not exceed string
  • ora-01259 : unable to delete datafile string
  • ora-02314 : illegal use of type constructor
  • ora-06529 : Version mismatch - PL/SQL profiler
  • ora-14608 : Tablespace was specified for the previous lob segments of column string in template but is not specified for string
  • ora-19881 : Corrupted space bitmap for datafile string, block string backup aborted
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-40101 : Data Mining System Error string-string-string
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-39315 : call to DBMS_SCHEMA_COPY.SWAP is not legal
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-16004 : backup database requires recovery
  • ora-06519 : active autonomous transaction detected and rolled back
  • 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.