OracleORA-12520: TNS: The Listener cannot find a problem with available handlers for the requested server type

OracleORA-12520: TNS: The Listener cannot find a problem with available handlers for the requested server type. view the processes and sessions parameters SQL> show parameter processesNAME TYPE when integer 1gcs_server_processes integer 0job_queue_processes integer when integer 2 processes integer 50 SQL> show parameter sessionsNAME TYPE VALUE www.2cto.com when integer then Ent_sessions integer 1 sessions integer 60shared_server_sessions integer 2. Modify the processes and sessions values SQL> alter system set processes = 300 scope = spfile; the system has changed. SQL> alter system set sessions = 335 scope = spfile; the system has been changed. 3. to modify the processes and sessions values, you must restart the oracle server to apply the number of ORACLE connections (sessions). The relationship between the number of processes in the parameter file is as follows: sessions = (1.1 * process + 5) Abstract (2) Number of connections to query the current process of the database: select count (*) from v $ process; view the number of connections of the current session of the database: select count (*) from v $ session; view the number of concurrent connections of the database: select count (*) from v $ session where status = 'active'; view the session established by the current database: select sid, serial #, username, program, machine, status from v $ session; query the maximum number of connections allowed by the database: select value from v $ pa Rameter where name = 'processs'; or: show parameter processes; modify the maximum number of connections allowed by the database: alter system set processes = 300 scope = spfile; (You need to restart the database to modify the number of connections) restart the database: shutdown immediate; startup; view which users are currently using data: select osuser,. username, cpu_time/executions/1000000 |'s, SQL _fulltext, machinefrom v $ session a, v $ sqlarea B www.2cto.com where. SQL _address = B. addressorder by cpu_time/executions desc; Note: one session of a UNIX user Corresponds to an operating system process, while Windows is reflected in the thread. Start oracle su-oraclesqlplus system/pwd as sysdba // enter sqlstartup // start database lsnrctl start // start listening sqlplus "/as sysdba" shutdown immediate; startup mount; alter database open; sqlplus login oracleC: \ Users \ Administrator> sqlplus sys/manager @ nw as sysdba
Author liuguofeng