Oracle Error 12537 Encountered
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: ora-12537 tns connection closed oracle 10g connection closed error Oracle Database Tips by Burleson Consulting Question: I'm trying to connect to Oracle and I get
Ora 12537 Network Session End Of File
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 ora-12537 tns connection closed oracle 12c of 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 ora-12537: tns:connection closed sap path name 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.
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
Tns-12537 Tns-12560 Tns-00507
Servers $ emca -deconfig dbcontrol db -repos drop -cluster $ emca tns 12537 tns connection closed 12560 -config dbcontrol db -repos create -cluster STARTED EMCA at Sep 6, 2014 1:03:42 PM EM Configuration
Ora 12537 Tns Connection Closed Linux
Assistant, Version 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 http://www.dba-oracle.com/t_ora_12537_tns_error.htm Listener ORACLE_HOME [ /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 https://blogs.oracle.com/taylor22/entry/emca_and_ora_12537_tns ................ 1521 Cluster name ................ 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
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Whilst you are here, check out some content https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 from the AskTom team: PL/SQL Brain Teaser: How can BULK https://geonet.esri.com/thread/89399 COLLECT be used? Latest Followup You Asked i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we connection closed said... sounds like the database is not up. you probably restarted your machine and the instance is not set to autostart C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release tns connection closed 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options C:\Documents and Settings\tkyte>net stop oracleserviceora10gr1 The OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0
without it enabled. Please turn JavaScript back on and reload this page.All Places > GIS > Managing Data > DiscussionsLog in to create and rate content, and to follow, bookmark, and share content with other members.AnsweredAssumed AnsweredORA-12537:TNS:connection closed. No extended error.Question asked by steve62 on Mar 1, 2014Latest reply on Mar 5, 2014 by steve62 Like • Show 0 Likes0 Comment • 6I am trying to create a geodatabase(ArcSDE 10.2.1) in an Oracle database(11.2.0.1) on Windows 8. I had Installed Oracle(db), and Oracle client(11.2.0.1 32 bit) on the same machine and copied tnsnames.ora from ...\11.2.0\dbhome_1\NETWORK\ADMIN to ....\11.2.0\client_1\NETWORK\ADMIN. While executing Create Enterprise Geodatabase tool, I encounter error. ORA-12537: TNS:connection closed. No extended error.Failed to execute (CreateEnterpriseGeodatabase).I understand that ORA-12537 is specific to configuration issues in the sqlnet.ora/listener.ora files. Can you please help me to fix this.nidhinkn Mar 5, 2014 2:28 AMCorrect AnswerThe OTN Forum post might help you to fix the error.See the reply in contextNo one else had this questionMark as assumed answeredOutcomesVisibility: Managing Data3850 ViewsLast modified on Mar 1, 2014 9:15 PMTags:managing_dataContent tagged with managing_datagdbContent tagged with gdb_geodatabaseContent tagged with _geodatabaseThis content has been marked as final. Show 6 comments6 RepliesNameEmail AddressWebsite AddressName(Required)Email Address(Required, will not be published)Website Addressmousaem Mar 1, 2014 11:34 PMMark CorrectCorrect Answeron your machine where Oracle Client directory is placed, double check your TNSNAMES.ORA for your database Also, from command prompt (use cmd) and then use "sqlplus" command to check your accessiblity.Like • Show 0 Likes0 Actions steve62 Mar 1, 2014 11:42 PMMark CorrectCorrect AnswerThanks for your suggestion. Oracle(db), and Oracle client is installed in the same machine. After installing Oracle client, I had copied tnsnames.ora from Oracle(db) directory to Oracle client directory. I can find the same error(ORA-12537), in Oracle Enterprise Manager Database Control.Like • Show 0 Likes0 Actions vangelo-esristaff Mar 2, 2014 6:32 AMMark CorrectCorrect AnswerYou definitely want to get Oracle tools working with this listener before attemptingthird party clients like ArcGIS.-