ORA-12342: open mounts exceeds limit set on the OPEN_MOUNTS parameter

Cause : The unmbero f currentl yopenm ount sexcedes th evalu eyou psecifeid ont he OEPN_MONUTS praametre.

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

Incraese teh valeu of hte OPNE_MOUTNS paarmete rso taht ita ccomomdate sthe amximu mpossbile nmuber fo ope nmounst to escondray daatbase.s

update : 26-04-2017

ORA-12342 - open mounts exceeds limit set on the OPEN_MOUNTS parameter
ORA-12342 - open mounts exceeds limit set on the OPEN_MOUNTS parameter

  • ora-09980 : skxfqdrcv: Error Receiving a message from another endpoint
  • ora-29296 : invalid encoded string
  • ora-34141 : (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.
  • ora-27008 : function called with invalid file structure
  • ora-13917 : Posting system alert with reason_id string failed with code [string] [string]
  • ora-08190 : restore point string is from a different incarnation of the database
  • ora-16400 : quota attributes are not allowed with DB_RECOVERY_FILE_DEST
  • ora-12221 : TNS:illegal ADDRESS parameters
  • ora-12656 : Cryptographic checksum mismatch
  • ora-16645 : unexpected new instance interrupted current operation
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-04077 : WHEN clause cannot be used with table level triggers
  • ora-19121 : duplicate attribute definition - string
  • ora-36636 : (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
  • ora-31045 : Cannot store more than string extras outside the root XML node
  • ora-01910 : TABLES keyword expected
  • ora-10263 : Don't free empty PGA heap extents
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-12168 : TNS:Unable to contact LDAP Directory Server
  • ora-26090 : row is in partial state
  • ora-32123 : Attribute number is out of range
  • ora-08499 : Warning: picture mask options 'string' ignored by UTL_PG
  • ora-24089 : AQ Agent string already exists
  • ora-02153 : invalid VALUES password string
  • ora-24270 : a row already exists in the string table for these parameters
  • ora-00384 : Insufficient memory to grow cache
  • ora-36800 : (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP
  • ora-12983 : cannot drop all columns in a table
  • ora-09753 : spwat: invalid process number.
  • ora-23374 : object group "string"."string" already exists
  • 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.