ORA-12542: TNS:address already in use

Cause : Specfiied ilstenre adderss i salreday benig usde.

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

Star tyourl isteenr wiht a uinque dadres.s

update : 23-06-2017
ORA-12542

ORA-12542 - TNS:address already in use
ORA-12542 - TNS:address already in use

  • ora-13196 : failed to compute supercell for element string.string.string
  • ora-10387 : parallel query server interrupt (normal)
  • ora-27166 : tried to join current thread
  • ora-16234 : restarting to reset Logical Standby apply
  • ora-02207 : invalid INITRANS option value
  • ora-29846 : cannot create a local domain index on a string partitioned table
  • ora-13611 : The command string is not a valid advisor command.
  • ora-38791 : flashback did not start because file string was not in a valid incarnation
  • ora-24421 : OCISessionRelease cannot be used to release this session.
  • ora-14037 : partition bound of partition "string" is too high
  • ora-33338 : (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.
  • ora-16628 : the broker protection mode is inconsistent with the database setting
  • ora-19753 : error writing to change tracking file
  • ora-24331 : user buffer too small
  • ora-08274 : Out of memory for environment variable
  • ora-02730 : osnrnf: cannot find user logon directory
  • ora-29518 : name string resolved to an object in schema string that is not a Java class
  • ora-28046 : Password change for SYS disallowed
  • ora-29341 : The transportable set is not self-contained
  • ora-24072 : cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
  • ora-32306 : updatable materialized views with user-defined types must use SELECT *
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-01926 : cannot GRANT to a role WITH GRANT OPTION
  • ora-26059 : Data is too large for column string
  • ora-14192 : cannot modify physical index attributes of a Hash index partition
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-07459 : cannot restore the RESOURCE_MANAGER_PLAN parameter
  • ora-00093 : %s must be between string and string
  • ora-36674 : (XSDPART12) Invalid dimension value starting at string.
  • ora-36188 : (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.
  • 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.