Error Connecting To Database Test Ora-12537
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Ora-12537 Intermittent
Diagnosing the ORA-12537: TNS: connection ora-12537: tns:connection closed sap closed error Oracle Database Tips by Burleson Consulting Question: I'm trying to connect to Oracle and I get
Ora-12537 Tns Connection Closed Oracle 12c
the ORA-12537: TNS: connection closed error. How do I fix an ORA-12537?Answer: The ORA-12537 is an informational error, and the "real" error is the secondary error message. ORA-12537 TNS:connection closed Cause: Normal "end of tns-12537 ora-609 file" condition has been reached; partner has disconnected. Action: None needed; this is an information message. The ORA-12537 error sometimes relates configuration issues in the sqlnet.ora, protocol.ora and listener.ora files. Verify that you service names match between your listener and remote client connect strings.This ORA-12537 can also happen if your firewall has disconnected idle connections.Also, the ORA-12537 sometimes happens in these cases: 1. You have a path name tns-12537 tns-12560 tns-00507 that is too long for the Oracle TNS client. See MOSC note:263489.1. Since the iORA-12537 ssue is caused by a large connection string there are several workarounds for the issue. 1. Install the exe in a shorter named directory. 2. Modify the TNS Names entry so that it is shorter. 3. Replace domain names with IP Addresses if that shortens and vice versa. 4. Remove any parameters from the entry that are not needed. 5. Patch the Database Listener to the most recent version. References 2. Bug:1566794: CONNECTIONS FAIL WITH ORA-12537 WHEN USE_SHARED_SOCKET IS SET IN 8.1.7. Resolution is to set USE_SHARED_SOCKET to FALSE. 3. Tnsping Net Service Name fails with TNS-12537: TNS:connection closed or Sqlplus connection errors out with Ora-12537 Cause: * In the Sqlnet.ora file the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to some specific IP's of the Client Machine. * If trying to connect to the Apps database, by default, with Oracle Apps Installation the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to Server Machines IP or Hostname. Solution * You can disable these parameters in the Sqlnet.ora * Or add the client machines ip address in the TCP.INVITEDNODES list. 4. For ORA-12
By Jeff Taylor-Oracle on Sep 08, 2014 Problem: I couldn't configure Enterprise Manager for a RAC database running on two SPARC T5-4 Servers
Tns-12518: Tns:listener Could Not Hand Off Client Connection
$ emca -deconfig dbcontrol db -repos drop -cluster $ emca -config ns main err code: 12537 dbcontrol db -repos create -cluster STARTED EMCA at Sep 6, 2014 1:03:42 PM EM Configuration Assistant, Version
Ociserverattach(oci_default) Failed With Sql Error 12537
11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database unique name: orcl2 Service name: orcl2 Listener port number: 1521 Listener ORACLE_HOME [ http://www.dba-oracle.com/t_ora_12537_tns_error.htm /u01/app/11.2.0/grid ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: 40 Cluster name: ofsaa-scan Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1 Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0/grid Listener port number ................ 1521 Cluster name https://blogs.oracle.com/taylor22/entry/emca_and_ora_12537_tns ................ proj-scan Database unique name ................ orcl2 Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y Sep 6, 2014 1:04:28 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl2/emca_2014_09_06_13_03_41.log. Sep 6, 2014 1:04:33 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Sep 6, 2014 1:09:20 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Sep 6, 2014 1:09:22 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely WARNING: Error during db connection : ORA-12537: TNS:connection closed Sep 6, 2014 1:09:33 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Failed to unlock all EM-related accounts Sep 6, 2014 1:09:33 PM oracle.sysman.emcp.EMConfig perform SEVERE: Failed to unlock all EM-related accounts Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl2/emca_2014_09_06_13_03_41.log for more details. Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl2/emca_2014_09_06_13_03_41.log for more details. Very strange. Everything else seemed fine. $ srvctl status scan $ srvctl status scan_listener $ srvctl status listener $ srvctl status database -d orcl2 I s
[message #580040] Tue, 19 March 2013 12:41 deepakkrjain3 Messages: 8Registered: October 2011 Location: Delhi Junior Member Dear http://www.orafaq.com/forum/t/186754/ friends, I am facing ora - 12537 TNS connection closed issue while I am trying to login into database. I have installed Oracle database http://www.dbasupport.com/forums/showthread.php?59711-ORA-12537-TNS-connection-closed 11g on windows 7 premium OS. Anyone can help me to trace this issue. Thanks in advance. Regards, Deepak Report message to a moderator connection closed Re: ORA-12537 TNS connection closed [message #580042 is a reply to message #580040] Tue, 19 March 2013 12:50 BlackSwan Messages: 24933Registered: January 2009 Location: SoCal Senior Member post results from following OS commands below lsnrctl status lsnrctl service what clues exist withing listener log file? Please read error connecting to and follow the forum guidelines, to enable us to help you: http://www.orafaq.com/forum/t/88153/0/ Report message to a moderator Re: ORA-12537 TNS connection closed [message #580044 is a reply to message #580042] Tue, 19 March 2013 13:12 deepakkrjain3 Messages: 8Registered: October 2011 Location: Delhi Junior Member Hi, Please look below for lsnrctl status and lsnrctl services command output. Also please look into exact error message which is I am getting during database connectivity. lsnrctl status ------------------ LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 19-MAR-2013 23:39:21 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production Start Date 19-MAR-2013 21:47:20 Uptime 0 days 1 hr. 52 min. 8 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:\database_11g\product\11.2.0\dbhome_1\network\admin\listener.ora Listener Log Fi
TNS:connection closed If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: ORA-12537: TNS:connection closed Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-30-2009,11:58 AM #1 ebethea27703 View Profile View Forum Posts Junior Member Join Date May 2006 Location Maryland Posts 10 ORA-12537: TNS:connection closed I am trying to connect remotely to another linux server. When my servers are started as user 'A' and I connect through sqlplus as system/password@hos from the user 'oracle' i get this error message from the logs: TNS-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact TNS-12560: TNS: protocol adapter error TNS-00517: Lost contact Linux Error: 32: Broken pipe Our processes are set to 2000 so it isn't the processes. Can anyone help me out? Thanks DBA Reply With Quote 05-01-2009,02:39 PM #2 gtcol View Profile View Forum Posts Member Join Date Oct 2006 Posts 175 Can you post what you have in listener.ora, listener.log and /var/log/messages? Reply With Quote 05-01-2009,03:03 PM #3 revzalot View Profile View Forum Posts Junior Member Join Date Apr 2009 Posts 21 How connecting via ssh as user oracle: for example $ ssh oracle@server login as sys as sysdba Reply With Quote 06-18-2009,10:32 AM #4 ebethea27703 View Profile View Forum Posts Junior Member Join Date May 2006 Location Maryland Posts 10 Sorry guys, got busy with other things. Here is the info you requested. Listener.ora: LISTEN_1521 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = IP ADDRESS)(PORT = 1521)) (SERVICE_NAME = SID) ) listen.log: