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 : 17-08-2017
ORA-12541

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

  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-38721 : Invalid file number.
  • ora-27041 : unable to open file
  • ora-32621 : illegal aggregation in UNTIL iteration condition
  • ora-10587 : Invalid count for ALLOW n CORRUPTION option
  • ora-09344 : spsig: error signalling thread
  • ora-01681 : max # extents (string) reached in LOB segment in tablespace string
  • ora-19508 : failed to delete file "string"
  • ora-07626 : smsget: sga already mapped
  • ora-38763 : flashback not started; enabled threads have changed
  • ora-28042 : Server authentication failed
  • ora-10700 : Alter access violation exception handler
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-30054 : invalid upper limit snapshot expression
  • ora-15192 : invalid ASM disk header [string] [string] [string] [string] [string]
  • ora-33261 : (DBERRLEN) Analytic workspace string extension number truncated at number bytes while trying to read at number.
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-29554 : unhandled Java out of memory condition
  • ora-12448 : policy string not applied to schema string
  • ora-07444 : function address string is not readable
  • ora-00250 : archiver not started
  • ora-02048 : attempt to begin distributed transaction without logging on
  • ora-01607 : cannot add logfile to the specified instance
  • ora-23442 : object already exists for the refresh group template
  • ora-01582 : unable to open control file for backup
  • ora-07617 : $FORMAT_CLASS failed translating the binary label to a string
  • ora-12218 : TNS:unacceptable network configuration data
  • ora-00295 : datafile/tempfile number string is invalid, must be between 1 and string
  • ora-13199 : %s
  • ora-28591 : agent control utility: unable to access parameter file
  • 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.