ORA-01531: a database already open by the instance

Cause : DuirngA LTRE DTAABSAE,a n tatepmt aws amdet o poena dtaabsae no a nintsanec fro wihcht heer i salerad yano pe ndaatbaes.

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

Ify ouw is htoo pe na enw adtaabseo n hte nistnace ,fisrt hsutodwnt hei nsatnc ean dthne satrtpu teh isntacne nad ertr yth eopreatoin.

update : 28-06-2017
ORA-01531

ORA-01531 - a database already open by the instance
ORA-01531 - a database already open by the instance

  • ora-19757 : could not resize change tracking file to string blocks
  • ora-00349 : failure obtaining block size for 'string'
  • ora-15009 : ASM disk "string" does not exist
  • ora-02433 : cannot disable primary key - primary key not defined for table
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-00268 : specified log file does not exist 'string'
  • ora-02468 : Constant or system variable wrongly specified in expression
  • ora-38503 : index already defined using the parameters
  • ora-38495 : data type for the stored attribute string is inconsistent.
  • ora-26006 : Incorrect bind variable in column string's sql expression - string
  • ora-02451 : duplicate HASHKEYS specification
  • ora-31495 : error in synchronous change table on "string"."string"
  • ora-02209 : invalid MAXTRANS option value
  • ora-26563 : renaming this table is not allowed
  • ora-30646 : schema for external table type must be SYS
  • ora-12635 : No authentication adapters available
  • ora-07564 : sldext: wildcard in filename or extension
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-13600 : error encountered in Advisor string
  • ora-22303 : type "string"."string" not found
  • ora-30437 : all job queue processes have stopped running
  • ora-00133 : value of string is too long
  • ora-12354 : secondary object being dropped
  • ora-12723 : regular expression too complex
  • ora-38478 : creation of system trigger EXPFIL_DROPOBJ_MAINT failed
  • ora-36666 : (XSDPART04) workspace object is not a concat dimension.
  • ora-00204 : error in reading (block string, # blocks string) of control file
  • ora-28262 : global_context_pool_size has invalid value.
  • ora-13907 : Threshold value is invalid.
  • ora-13142 : invalid PROXIMITY window definition
  • 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.