ORA-12543: TNS:destination host unreachable

Cause : Contact can not be made with remote party.

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

Make sure the network driver is functioning and the network is up.

update : 26-06-2017

ORA-12543 - TNS:destination host unreachable
ORA-12543 - TNS:destination host unreachable

  • ora-10862 : resolve default queue owner to current user in enqueue/dequeue
  • ora-30939 : Order violation: Element 'string' may not follow element 'string'
  • ora-06307 : IPA: Cannot reset connection
  • ora-12433 : create trigger failed, policy not applied
  • ora-22324 : altered type has compilation errors
  • ora-12151 : TNS:received bad packet type from network layer
  • ora-26745 : cursors (string) are not sufficient
  • ora-23378 : connection qualifier "string" is not valid for object group "string"."string"
  • ora-38755 : Flashback is already turned on for this tablespace.
  • ora-06736 : TLI Driver: server not running
  • ora-27418 : syntax error in repeat interval or calendar
  • ora-16204 : DDL successfully applied
  • ora-22611 : TDS version is not recognized
  • ora-19234 : XQ0014 - invalid or unsupported must-understand extension
  • ora-23418 : cannot unregister the propagator who is currently in use
  • ora-22308 : operation not allowed on evolved type
  • ora-00026 : missing or invalid session ID
  • ora-22617 : error while accessing the image handle collection
  • ora-00711 : new tablespace name is invalid
  • ora-13857 : Invalid module name
  • ora-38401 : synonym string not allowed
  • ora-39167 : Tablespace string was not found.
  • ora-19956 : database should have no offline immediate datafiles
  • ora-13604 : The specified parameter string cannot be fetched as a SQL table.
  • ora-12452 : label tag string already exists
  • ora-19020 : invalid dereference of XMLType columns
  • ora-28265 : NameSpace beginning with 'sys_' is not allowed
  • ora-31446 : this session does not own the lock handle for string
  • ora-39305 : schema "string" does not exist
  • ora-16164 : LGWR network server host detach error
  • 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.