Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ ORA-12537: TNS: connection closed error process     - Fedora 22 users to install the VLC media player (Linux)

- CentOS 6.3 compile and install LNMP environment (Server)

- Debian installation (Linux)

- Oracle 11g upgrade PSU detailed steps (Database)

- PHP 7.0 Upgrade Notes (Linux)

- Oracle restrict certain IP, the malicious user actions on important table (Database)

- Talk about Java EE Learning (Programming)

- RHEL7.0 environment Linux kernel upgrade (Linux)

- Make command tutorial (Linux)

- Nginx-1.9.7 TCP reverse proxy (Server)

- Repair fatal error in Linux: lame / lame.h: No such file or dir Error (Linux)

- To install and use Docker under linux (Server)

- hexdump Linux command (Linux)

- Ceph single / multi-node installation summary Powered by CentOS 6.x (Server)

- 25 Git Usage Tips (Linux)

- curl Usage: Being the first site header and status codes (Server)

- Linux Getting Started tutorial: Experience Xen Virtual Machine chapter (Linux)

- Java Generics Introduction --HashMap summary (Programming)

- Ubuntu mysql stop fail to solve the problem (Database)

- Zabbix API and PHP configuration (Server)

 
         
  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:      
 
- Windows 8.1 and Ubuntu 14.04 dual system uninstall Ubuntu Tutorial (Linux)
- How to disable UEFI to install Linux on Win8 (Linux)
- Linux Getting Started tutorial: Borrow Windows fonts in Ubuntu 14.10 (Linux)
- Hackers is how the invasion and control of Things devices? (Linux)
- CentOS yum source configuration (Linux)
- To delete the directory and all specified files under the Mac (Linux)
- Configuring Sublime Text Python runtime environment 2 (Linux)
- Vim custom color (Linux)
- Ubuntu users install the Download Manager software Xdman 5.0 (Linux)
- Android code performance optimization tips (Programming)
- AngularJS notes --- Scope and controller (Programming)
- Install Java, Maven, Tomcat under Linux (Linux)
- CentOS6.3 build a Python 3.3 environment to access Oracle 11gR2 (Database)
- Experts teach you safety precautions Linux Sniffer (Linux)
- CentOS 6 / Linux su: Unable to set user ID: Resource temporarily unavailable (Linux)
- How to use the command line to obtain Freely RSS source on Linux (Linux)
- Extended VMware Ubuntu root partition size (Linux)
- Save the database data files into Oracle Learning (Database)
- redis configuration in detail (English) (Database)
- SQL Server memory Misunderstanding (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.