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 : 24-05-2017
ORA-12541

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

  • ora-01968 : Only specify RESETLOGS or NORESETLOGS once
  • ora-29656 : Invalid option for USING
  • ora-30133 : reserved for future use
  • ora-13354 : incorrect offset in ELEM_INFO_ARRAY
  • ora-19646 : cannot change size of datafile string from string to string
  • ora-31532 : cannot enable change source string
  • ora-09353 : Windows 32-bit Two-Task driver unable to open event semaphore
  • ora-07645 : sszfsl: $CHANGE_CLASS failure
  • ora-32695 : HTI: Not enough memory
  • ora-24031 : invalid value, string should be non-NULL
  • ora-22868 : table with LOBs contains segments in different tablespaces
  • ora-09748 : pws_look_up: fork failed
  • ora-19243 : XQ0023 - invalid document node content in element constructor
  • ora-01928 : GRANT option not granted for all privileges
  • ora-29314 : tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY
  • ora-24422 : error occurred while trying to destroy the Session Pool
  • ora-30100 : internal error [number]
  • ora-13603 : The specified parameter string cannot be fetched as a numeric value for task or object string.
  • ora-19686 : SPFILE not restored due to string
  • ora-29252 : collection does not contain elements at index locations in call to dbms_sql.bind_array
  • ora-36833 : (XSLMGEN03) View token cannot be blank
  • ora-22336 : table contained 8.0 image format, must specify INCLUDING DATA
  • ora-13185 : failed to generate initial HHCODE
  • ora-01652 : unable to extend temp segment by string in tablespace string
  • ora-29856 : error occurred in the execution of ODCIINDEXDROP routine
  • ora-24128 : partition name specified for a non-partitioned object
  • ora-29264 : unknown or unsupported URL scheme
  • ora-15131 : block string of file string in diskgroup string could not be read
  • ora-14621 : cannot add subpartition when DEFAULT subpartition exists
  • ora-22328 : object "string"."string" has errors. string
  • 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.