ORA-12323: unable to open database (link name string)

Cause : Thism essaeg sholud bea ccomapniedb y adidtionla errro mesasges htat idnicat ethe acuse fo thep roblme.

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

Follwo thes tepso utliend int he accompayning reror emssagse to ersolv ethe rpoble.m

update : 27-06-2017
ORA-12323

ORA-12323 - unable to open database (link name string)
ORA-12323 - unable to open database (link name string)

  • ora-06816 : TLI Driver: could not set the SPX SAP address
  • ora-01620 : no public threads are available for mounting
  • ora-27481 : "string.string" has an invalid schedule
  • ora-00050 : operating system error occurred while obtaining an enqueue
  • ora-03209 : DBMS_ADMIN_PACKAGE invalid file/block specification
  • ora-00375 : unable to get default db_block_size
  • ora-30340 : illegal dimension name
  • ora-00033 : current session has empty migration password
  • ora-09843 : soacon: Archmon unable to create named pipe.
  • ora-01282 : date range specified is invalid
  • ora-16953 : Type of SQL statement not supported.
  • ora-30514 : system trigger cannot modify tablespace being made read only
  • ora-00216 : control file could not be resized for migration from 8.0.2
  • ora-02088 : distributed database option not installed
  • ora-38729 : Not enough flashback database log data to do FLASHBACK.
  • ora-15000 : command disallowed by current instance type
  • ora-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-23396 : database link "string" does not exist or has not been scheduled
  • ora-14306 : List value 'string' specified twice in partitions 'string', 'string'
  • ora-22873 : primary key not specified for primary key based object table
  • ora-39113 : Unable to determine database version
  • ora-21607 : memory cartridge service handle not initialized
  • ora-33009 : (XSAGDNGLPREC) In AGGMAP workspace object, PRECOMPUTE may only be specified either for the entire AGGMAP or for individual RELATION statements.
  • ora-24154 : rule string.string already in rule set string.string
  • ora-24275 : function 'string' parameter 'string' missing or invalid
  • ora-34360 : (MXDSS15) number other users writing
  • ora-10930 : trace name context forever
  • ora-28041 : Authentication protocol internal error
  • ora-24171 : creation properties are only for internal use
  • ora-32514 : cannot dump multiple 'string' types: structure size is unknown
  • 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.