Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ ORA-12537: TNS: connection closed error process     - Via Twitter how open source library to be used anywhere Emoji emoticons (Linux)

- Linux file compression and file system packaged with instructions (Linux)

- How to install Linux Kernel 4.0 On CentOS 7 system (Linux)

- Using Vagrant to build multi-platform environment (Server)

- Oracle 12c users create (Database)

- Linux kernel network subsystem analysis (Programming)

- Git and GitHub use of Eclipse and Android Studio (Programming)

- Spark SQL job of a lifetime (Server)

- Dom4j change XML coding (Programming)

- How to fix apt-get update can not add a new CD-ROM error (Linux)

- Monitoring services are running properly and will email alert (Server)

- Servlet life cycle code examples (Programming)

- Oracle to use full-text indexing (Database)

- Ubuntu 14.10 / 14.04 / 12.04 installation GNOME Pie 0.5.6 (Linux)

- How SSHfs mount a remote file system on Linux (Linux)

- Installation Elementary OS Freya to do some settings (Linux)

- MongoDB start under Linux (Database)

- Java to create a table in the database SYBase (Database)

- SolrCloud-5.2.1 cluster deployment and testing (Server)

- Sublime Text - Opens the current file in a browser (Linux)

 
         
  ORA-12537: TNS: connection closed error process
     
  Add Date : 2017-01-08      
         
       
         
  1, colleagues said Oracle test for a connection is not on, the following error

[Oracle @ pldb236 admin] $ rlwrap sqlplus powerdesk / pd141118 @ PD236

SQL * Plus: Release 11.2.0.1.0 Production on Mon Nov 23 14:16:31 2015

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-12537: TNS: connection closed


Enter user-name:
Check the monitor properly, Oracle service is started normally, but does not login into

[Oracle @ pldb236 admin] $ tnsping PD236

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 23-NOV-2015 14:17:22

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.180.236) (PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = powerdes)))
OK (10 msec)
[Oracle @ pldb236 admin] $
2, Solution

[Oracle @ pldb236 bin] $ cd $ ORACLE_HOME / bin /
[Oracle @ pldb236 bin] $
[Oracle @ pldb236 bin] $
[Oracle @ pldb236 bin] $ ll oracle
-rwsr-s -. x 1 oracle oinstall 210823844 Jul 31 13:21 oracle
[Oracle @ pldb236 bin] $
[Oracle @ pldb236 bin] $ chmod 6571 oracle
[Oracle @ pldb236 bin] $
[Oracle @ pldb236 bin] $ ll oracle
-r-srws -. x 1 oracle oinstall 210823844 Jul 31 13:21 oracle
[Oracle @ pldb236 bin] $



[Oracle @ pldb236 bin] $ rlwrap sqlplus / as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Mon Nov 23 14:20:09 2015

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL>
ok can be connected, has initially solved the problem

3, but three minutes later, to die, not get logged.

SQL * Plus: Release 11.2.0.1.0 Production on Mon Nov 23 14:29:17 2015

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-12537: TNS: connection closed

Enter user-name:

Lsnrctl status to view:
[Oracle @ pldb236 bin] $ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-NOV-2015 14:30:33

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.180.236) (PORT = 1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 23-NOV-2015 14:30:19
Uptime 0 days 0 hr. 0 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/pldb236/listener/alert/log.xml
Listening Endpoints Summary ...
  (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.180.236) (PORT = 1521)))
  (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC0)))
Services Summary ...
Service "PLSExtProc" has 1 instance (s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler (s) for this service ...
Service "powerdes" has 1 instance (s).
  Instance "powerdes", status UNKNOWN, has 1 handler (s) for this service ...
The command completed successfully
[Oracle @ pldb236 bin] $
See backstage alert log being given as follows:

        Mon Nov 23 14:32:00 2015
        ORA-00020: maximum number of processes 150 exceeded
        ORA-20 errors will not be written to the alert log for
         the next minute. Please look at trace files to see all
         the ORA-20 errors.
        Mon Nov 23 14:32:47 2015
        Process m000 submission failed with error = 20
        Mon Nov 23 14:33:02 2015
        ORA-00020: maximum number of processes 150 exceeded
        ORA-20 errors will not be written to the alert log for
         the next minute. Please look at trace files to see all
         the ORA-20 errors.
        Mon Nov 23 14:34:03 2015
        ORA-00020: maximum number of processes 150 exceeded
        ORA-20 errors will not be written to the alert log for
         the next minute. Please look at trace files to see all
         the ORA-20 errors.
Solution 1:
lsnrctl stop 5 minutes, then lsnrctl start up, the problem is resolved, the application has been kept a database connection, the connection pool filled lead.

Solution 2:
Check oracle number of connections, it really is 150

SQL> show parameter processes;

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
aq_tm_processes integer 0
db_writer_processes integer 2
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 150
SQL>
SQL>
SQL>

Analyze the reasons:

SQL> select count (1) from v $ session t where t.status = 'INACTIVE' and t.username = 'PLAS';
  COUNT (1)
----------
        88

SQL>
SQL>
SQL> select count (1) from v $ session t where t.status = 'INACTIVE' and t.username = 'PLAS';
  COUNT (1)
----------
         5

SQL>
Modify the configuration file:

[Oracle @ pldb236 ~] $ find / oracle -name * init.ora *
/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/init.ora
/oracle/app/oracle/product/11.2.0/dbhome_1/srvm/admin/init.ora
/oracle/app/oracle/admin/powerdes/pfile/init.ora.7112015171232
[Oracle @ pldb236 ~] $
Changes in the number of connections, and writes the parameter file

alter system set processes = 500 scope = spfile;
SQL> alter system set processes = 500 scope = spfile;

System altered.

SQL> create pfile from spfile;

File created.

SQL>
Close restart oracle instance, you can start to see the maximum number of connections has become a 500, the problem is solved

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[Oracle @ pldb236 ~] $ rlwrap sqlplus / as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Mon Nov 23 23:09:00 2015

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 6680915968 bytes
Fixed Size 2213936 bytes
Variable Size 4362078160 bytes
Database Buffers 2281701376 bytes
Redo Buffers 34922496 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> show parameter processes;

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
aq_tm_processes integer 0
db_writer_processes integer 2
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 500
SQL>
     
         
       
         
  More:      
 
- Https (SSL / TLS) Detailed principles (Server)
- PL / SQL data types (Database)
- Easy to install CentOS 6.6 desktop environment (Linux)
- Install Ubuntu open source drawing program MyPaint 1.2.0 (Linux)
- Use in Linux ipmitool tool (Linux)
- Six Ways to view slides can be implemented Android (Programming)
- Oracle restrict certain IP, the malicious user actions on important table (Database)
- How to run in support UDp Docker container JBoss data virtualization GA (Server)
- Ubuntu 14.04 can be used to create a WIFI hotspot for Android (Linux)
- Encrypted with GnuPG signature to verify the authenticity and integrity of downloaded file (Linux)
- Asynchronous communication mechanism between the Android source code analysis thread (Programming)
- High-performance JavaScript DOM programming (Programming)
- Linux user groups, file permissions Detailed (Linux)
- Xtrabackup creates a slave node without downtime (Database)
- Linux System Getting Started Tutorial: How to automatically set the JAVA_HOME environment variable on Linux (Linux)
- RealVNC Server 5.2.3 Installation and Configuration In Fedora (Server)
- Android custom title bar (Programming)
- Java class HashSet (Programming)
- grep command Series: How to Use the grep command in Linux / UNIX (Linux)
- About Nginx 7 (Server)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.