Whether the maximum number of connections is set in oracle or an error is returned.

Whether the maximum number of connections is set in oracle or an error is returned.

There are 1100 data records to be updated, and an error is reported during connection.

ORA-12518, TNS: listener cocould not hand off client connection

According to the article of the product, the maximum number of connections is set to 1200, and the session is 1200*1.1 + 5 = 1325. However, tomcat still reports an error.

ORA-12518, TNS: listener cocould not hand off client connection

View the maximum number of connections:

SQL> show parameter processes;
NAME TYPE VALUE
-----------------------------------------------------------------------------
Aq_tm_processes integer 0
Db_writer_processes integer 1
Gcs_server_processes integer 0
Job_queue_processes integer 10
Log_archive_max_processes integer 2

Processes integer 1200

View the current database v $ processes only 356, v $ session 352

PMON updates the content in the listener every five minutes, so the listener and the database are not necessarily synchronized. You now know from the database that there are 356 connections, does not mean that the listener records 356, within 5 minutes it is likely that pmon has not been updated, still 1200 so you report ORA-12518 rather than ora-00020

SQL> show parameter pga; NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------pga_aggregate_target                 big integer 194M SQL> select * from v$resource_limit; RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION   LIMIT_VALUE------------------------------ ------------------- --------------- -------------------- --------------------processes                                       24             366       1200                 1200sessions                                        27             362       1325                 1325enqueue_locks                                   15              25      15950                15950enqueue_resources                               15              43       6048            UNLIMITEDges_procs                                        0               0          0                    0ges_ress                                         0               0          0            UNLIMITEDges_locks                                        0               0          0            UNLIMITEDges_cache_ress                                   0               0          0            UNLIMITEDges_reg_msgs                                     0               0          0            UNLIMITEDges_big_msgs                                     0               0          0            UNLIMITEDges_rsv_msgs                                     0               0          0                    0gcs_resources                                    0               0          0                    0gcs_shadows                                      0               0          0                    0dml_locks                                        0              51       5828            UNLIMITEDtemporary_table_locks                            0               3  UNLIMITED            UNLIMITEDtransactions                                     1               7       1457            UNLIMITEDbranches                                         0               0       1457            UNLIMITEDcmtcallbk                                        0               2       1457            UNLIMITEDsort_segment_locks                               0               3  UNLIMITED            UNLIMITEDmax_rollback_segments                           11              11       1457                65535 RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION   LIMIT_VALUE------------------------------ ------------------- --------------- -------------------- --------------------max_shared_servers                               1               1  UNLIMITED            UNLIMITEDparallel_max_servers                             0               0         40                 3600 22 rows selected 

After changing the maximum number of connections in oracle, the system user is locked. How can I unlock it? Sys user I forgot my password too? The following are connection errors.

Enter the database server. If it is a unix operating system, you need to enter the oracle user and enter
Sqlplus/nocatalog

Conn/as sysdba

Alter user system identifed by new password

But I don't think you forgot your password.

We recommend that you check the sqlnet. ora file of ORACLE_BASE \ ORACLE_HOME \ NETWORK \ ADMIN.
Change sqlnet. authentication_services = (CNT) to sqlnet. authentication_services = (NONE ).

ORACLE insert inserts hundreds of calls of data, and an error is reported to reach the maximum number of partitions <32765>. If you look back at the picture and insert it again, no error is reported.

Are you not capable of automatic resizing?
Pctfree 10
Initrans 1
Maxtrans 255
Storage
(
Initial 64
Minextents 1
Maxextents unlimited
);
You haven't installed pl/SQL yet. Check the SQL in your table structure to see if there is any expansion function,
By the way
Or is the length of the table field exceeded? Please check