liunx下oracle链接数超出最大链接数处理方法

-------------使用如下命令------------------

SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

alter system set processes = 5000 scope = spfile;

alter system set O7_DICTIONARY_ACCESSIBILITY=false scope=spfile;

alter system set remote_login_passwordfile=NONE scope=spfile;

shutdown immediate;

startup;

lsnrctl status

 

.............................................具体操作..............................

Connection established.

Escape character is '^@]'.

 

Last login: Thu Dec  6 14:49:49 2018 from 10.10.1.220

[root@oracledb ~]# su - oracle

Last login: Thu Dec  6 09:16:38 CST 2018 from 10.10.1.220 on pts/0

[oracle@oracledb ~]$ source /home/oracle/.bash_profile

[oracle@oracledb ~]$ sqplus / as sysdba

bash: sqplus: command not found...

[oracle@oracledb ~]$ sqplus / as sysdba

bash: sqplus: command not found...

[oracle@oracledb ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 16:52:21 2018

 

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> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

 

PROFILE                RESOURCE_NAME            RESOURCE

------------------------------ -------------------------------- --------

LIMIT

----------------------------------------

DEFAULT                PASSWORD_LIFE_TIME        PASSWORD

180

 

 

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

 

Profile altered.

                           " - rest of line ignored.

SQL> ^[[A^[[A

SQL> 042: unknown command "

SQL>

SQL>

SQL> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

 

PROFILE                RESOURCE_NAME            RESOURCE

------------------------------ -------------------------------- --------

LIMIT

----------------------------------------

DEFAULT                PASSWORD_LIFE_TIME        PASSWORD

UNLIMITED

 

 

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

 

System altered.

 

SQL> alter system set remote_login_passwordfile=NONE scope=spfile;

 

System altered.

 

SQL> shutdown  immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

 

Total System Global Area 1.3429E+10 bytes

Fixed Size            2217992 bytes

Variable Size         7650412536 bytes

Database Buffers     5704253440 bytes

Redo Buffers           71770112 bytes

Database mounted.

Database opened.