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 : 29-04-2017
ORA-12543

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

  • ora-31088 : object "string"."string" depends on the schema
  • ora-25400 : must replay fetch
  • ora-32035 : unreferenced query name defined in WITH clause
  • ora-01568 : cannot set space quota on PUBLIC
  • ora-08444 : syntax error in JUSTIFIED clause in mask options
  • ora-12461 : undefined level string for policy string
  • ora-23504 : columns added to table do not match list of columns to be added
  • ora-30391 : the specified rewrite equivalence does not exist
  • ora-22295 : cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
  • ora-26007 : invalid value for SETID or OID column
  • ora-32767 : No server connection for this operation
  • ora-30205 : invalid Character set
  • ora-13430 : the GeoRaster object has null attribute(s)
  • ora-40273 : invalid model type string for Adaptive Bayes Network algorithm
  • ora-25013 : OLD and PARENT values cannot be identical
  • ora-15170 : cannot add entry 'string' in directory 'string'
  • ora-27508 : IPC error sending a message
  • ora-38719 : Invalid DUMP FLASHBACK object.
  • ora-39055 : The string feature is not supported in version string.
  • ora-02045 : too many local sessions participating in global transaction
  • ora-09751 : pw_attachPorts: server call pws_attach failed.
  • ora-01938 : IDENTIFIED BY must be specified for CREATE USER
  • ora-16600 : failover operation can only be submitted at target database
  • ora-24181 : The type string does not exist
  • ora-30118 : syntax error at 'string' at the end of input
  • ora-19591 : backup aborted because job time exceeded duration time
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-16754 : resource guard could not activate standby database
  • ora-39057 : invalid worker request string for string jobs.
  • ora-23441 : object does not exist for refresh group template
  • 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.