ORA-12541: TNS:no listener

Cause : The cnonectino requset coudl not eb compelted bceause hte lisetner i snot rnuning.

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

Ensur ethat hte suplpied dsetinatoin adderss macthes oen of teh addrseses uesd by hte lisetner -c ompar ethe TSNNAMESO.RA enrty wit hthe appropritae LISETNER.OAR file( or TNNSAV.OR Aif th econnetcion i sto gob y wayo f an nIterchnage). tSart teh listneer ont he reomte mahcine.

update : 27-06-2017
ORA-12541

ORA-12541 - TNS:no listener
ORA-12541 - TNS:no listener

  • ora-13621 : The task_or object string is marked as a template and cannot perform the requested operation.
  • ora-16701 : generic resource guard request failed
  • ora-26091 : requested direct path operation not supported
  • ora-26712 : remote object is "string"."string"@"string"
  • ora-13401 : duplicate entry for string in USER_SDO_GEOR_SYSDATA view
  • ora-08447 : syntax error in USAGE clause in mask options
  • ora-10902 : disable seghdr conversion for ro operation
  • ora-19958 : potential deadlock involving DIAG process
  • ora-12315 : database link type is invalid for the ALTER DATABASE statement
  • ora-31439 : subscription is already active
  • ora-27366 : job "string.string" is not running
  • ora-12454 : label string does not exist for policy string
  • ora-28166 : duplicate rolename in list
  • ora-12926 : FORCE LOGGING option already specified
  • ora-21611 : key length [string] is invalid
  • ora-12550 : TNS:syntax error
  • ora-06548 : no more rows needed
  • ora-30488 : argument should be a function of expressions in PARTITION BY
  • ora-28349 : cannot encrypt the specified column recorded in the materialized view log
  • ora-32635 : not a single cell reference predicate
  • ora-38483 : invalid FUNCTION/PACKAGE/TYPE name: "string"
  • ora-25217 : enqueue failed, visibility must be IMMEDIATE for queue string.string
  • ora-29845 : indextype does not support local domain index on string partitioned table
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-16952 : Failed to bind this SQL statement.
  • ora-29548 : Java system class reported: string
  • ora-07574 : szrfc: $GETUAI failure
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-16076 : unknown standby database destination
  • 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.