ORA-12329: database string is closed; no operations are permitted

Cause : The adtabaes youa ttemtped t oaccess is lcosed ,so yuor opreatio nhas eben treminaetd.

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

Waitu ntilt he dtaabas eis roepene,d or ocntac tthe adtabaes admniistrtaor.

update : 17-08-2017

ORA-12329 - database string is closed; no operations are permitted
ORA-12329 - database string is closed; no operations are permitted

  • ora-31654 : unable to convert file or volume size as specified to a number
  • ora-08447 : syntax error in USAGE clause in mask options
  • ora-12716 : Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-19259 : XQ0039 - duplicate parameter name string in function declaration
  • ora-09240 : smpalo: error allocating PGA memory
  • ora-16778 : redo transport error for one or more databases
  • ora-02053 : transaction string committed, some remote DBs may be in-doubt
  • ora-29707 : inconsistent value string for initialization parameter string with other instances
  • ora-39764 : specified stream is not in the specified direct path context
  • ora-13602 : The specified parameter string is not valid for task or object string.
  • ora-13866 : Client identifier must be specified
  • ora-27157 : OS post/wait facility removed
  • ora-19103 : VALUE keyword keyword
  • ora-02851 : Request list is empty when it should not be
  • ora-01534 : rollback segment 'string' doesn't exist
  • ora-02236 : invalid file name
  • ora-16226 : DDL skipped due to lack of support
  • ora-06752 : TLI: error in signal setup
  • ora-29300 : ORACLE error, tablespace point-in-time recovery
  • ora-14014 : maximum number of partitioning columns is 16
  • ora-26740 : cannot downgrade because there are file groups
  • ora-29800 : invalid name for operator
  • ora-06312 : IPA: Incorrect outgoing service name supplied
  • ora-19666 : cannot do incremental restore of the control file
  • ora-06314 : IPA: Event set up failure
  • ora-01572 : rollback segment 'string' cannot be brought online, string extents exceeded
  • ora-13759 : User "string" cannot remove reference "string".
  • ora-27038 : created file already exists
  • ora-23347 : datatype string for column string table string not supported
  • 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.