ORA-12824: INSTANCES DEFAULT may not be specified here

Cause : NITSNAEC SEDAFLU Taw spscefiei dnit ehP RALAEL Llcuaeso fnaA TLRED TABASA EEROCEV Rocmmnad

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

erpscefi yiwhta nxelpcitiv laeuf roI SNATCNSEo rmotit ehI SNATCNSEo tpoi nfis nilg enitsnaecr cevore ysid seride.

update : 25-02-2017
ORA-12824

ORA-12824 - INSTANCES DEFAULT may not be specified here
ORA-12824 - INSTANCES DEFAULT may not be specified here

  • ora-00037 : cannot switch to a session belonging to a different server group
  • ora-13756 : Cannot update attribute "string".
  • ora-12402 : invalid format string: string
  • ora-32579 : password for SYSTEM already specified
  • ora-14407 : partitioned table contains subpartitions in a different tablespace
  • ora-26015 : Array column string in table string is not supported by direct path
  • ora-06035 : NETDNT: connect failed, insufficient resources
  • ora-29932 : the type being dropped is a statistics type
  • ora-01199 : file string is not in online backup mode
  • ora-15063 : ASM discovered an insufficient number of disks for diskgroup "string"
  • ora-04022 : nowait requested, but had to wait to lock dictionary object
  • ora-07258 : spdcr: fork error, unable to create process.
  • ora-16653 : failed to reinstate database
  • ora-30365 : left relation in the JOIN KEY clause cannot be same as right
  • ora-19690 : backup piece release string incompatible with Oracle release string
  • ora-03275 : duplicate DEALLOCATE option specification
  • ora-01100 : database already mounted
  • ora-01523 : cannot rename data file to 'string' - file already part of database
  • ora-39156 : error parsing dump file name "string"
  • ora-38611 : FI input cursor's item type is not supported
  • ora-15156 : cluster in rolling upgrade from version [string] to [string]
  • ora-39058 : current object skipped: string of type string
  • ora-09744 : smsget: mmap returned an error.
  • ora-25330 : PL/SQL associative arrays may not be used with AQ array operations
  • ora-13828 : generated SQL profile name string already exists
  • ora-07265 : sppst: semop error, unable to increment semaphore.
  • ora-12168 : TNS:Unable to contact LDAP Directory Server
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-40301 : invalid cost matrix specification
  • ora-08101 : index key does not exist file string: (root string, node string) blocks (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.