ORA-12318: database (link name string) is already mounted

Cause : You rae atetmptign to omunt asecodnary adtabaes tha thas laread ybeenm ountde by oyur isntanc.e

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

to muont i.t To setablsih acecss, sue th eALTE RDATAABSE OPNE comamnd t oopent he dtaabas.e

update : 29-04-2017

ORA-12318 - database (link name string) is already mounted
ORA-12318 - database (link name string) is already mounted

  • ora-40305 : invalid impurity metric specified
  • ora-16008 : indeterminate control file checkpoint
  • ora-16785 : the database is not in ARCHIVELOG mode
  • ora-00288 : to continue recovery type ALTER DATABASE RECOVER CONTINUE
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-14629 : cannot drop the only subpartition of a partition
  • ora-25400 : must replay fetch
  • ora-30157 : An invalid argument was given to operating system call
  • ora-24358 : OCIBindObject not invoked for a Object type or Reference
  • ora-16403 : shutdown in progress - remote connection is not permitted
  • ora-24049 : invalid agent name string, names with AQ$_ prefix are not valid
  • ora-01590 : number of segment free list (string) exceeds maximum of string
  • ora-28279 : Error reading ldap_directory_access init parameter.
  • ora-06810 : TLI Driver: could not set the IPX ethernet SAP at init
  • ora-13449 : GeoRaster metadata ULTCoordinate error
  • ora-14129 : INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints
  • ora-30155 : An I/O Error occured during an OCIFile function call
  • ora-22161 : type code [string] is not valid
  • ora-00444 : background process "string" failed while starting
  • ora-02281 : duplicate or conflicting CACHE/NOCACHE specifications
  • ora-08450 : invalid specification of CR in picture mask
  • ora-15200 : initialization parameter string (string) is not a power of two
  • ora-29400 : data cartridge error string
  • ora-02760 : Client close of file failed.
  • ora-01512 : error renaming log file string - new file string not found
  • ora-24168 : rule string.string cannot have default evaluation context
  • ora-14256 : invalid resulting partition description(s)
  • ora-33458 : (ESDREAD09) Discarding compiled code for workspace object because number is now type string, whereas it was type string when the code was compiled.
  • ora-28141 : error in creating audit index file
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • 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.