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-04-2017
ORA-12541

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

  • ora-12988 : cannot drop column from table owned by SYS
  • ora-00483 : During shutdown a process abnormally terminated
  • ora-01095 : DML statement processed zero rows
  • ora-13483 : insufficient memory for the specified GeoRaster data
  • ora-12994 : drop column option only allowed once in statement
  • ora-13017 : unrecognized line partition shape
  • ora-16773 : error starting Redo Apply
  • ora-12207 : TNS:unable to perform navigation
  • ora-02232 : invalid MOUNT mode
  • ora-34141 : (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.
  • ora-37005 : (AWLISTALL03) number readers
  • ora-32634 : automatic order MODEL evaluation does not converge
  • ora-13066 : wrong feature geometry or element type
  • ora-16187 : LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-13634 : The task string needs to be reset before being re-executed.
  • ora-27163 : out of memory
  • ora-33468 : (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
  • ora-16626 : failed to enable specified object
  • ora-34243 : (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
  • ora-32508 : no such watchpoint id
  • ora-32807 : message system link string already exists
  • ora-02141 : invalid OFFLINE option
  • ora-06790 : TLI Driver: poll failed
  • ora-39040 : Schema expression "string" must identify exactly one schema.
  • ora-19734 : wrong creation SCN - control file expects converted plugged-in datafile
  • ora-29808 : specified primary operator binding does not exist
  • ora-00028 : your session has been killed
  • ora-14029 : GLOBAL partitioned index must be prefixed
  • ora-40273 : invalid model type string for Adaptive Bayes Network algorithm
  • 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.