我的服务器突然出现用户偶然连接不上的问题,
我的alert.log
Errors in file /export/home/oracle/admin/wcb/bdump/wcb_psp0_68658.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
我的listener.log里:
TNS-12518: TNS:listener could not hand off client connection
TNS-12549: TNSperating system resource quota exceeded
TNS-12560: TNSrotocol adapter error
TNS-00519: Operating system resource quota exceeded
IBM/AIX RISC System/6000 Error: 11: Resource temporarily unavailableOS:IBM/AIX 5.3 ORACLE:10.2.0.3
AIX:MEM:4G
maxuproc =1024
DB1:/#vmstat 1 2System configuration: lcpu=8 mem=15744MBkthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 0 1370290 2080074 0 0 0 0 0 0 60 2857 378 0 0 99 0
0 0 1370333 2080031 0 0 0 0 0 0 233 4286 546 1 1 97 1 ORACLE:process =1000
session =1105
PGA=1000MB
SGA=1500MB
出现问题时V$PROCESS里面只有100多个,
目前数据库还没有上线,不知道什么问题?
我的alert.log
Errors in file /export/home/oracle/admin/wcb/bdump/wcb_psp0_68658.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
我的listener.log里:
TNS-12518: TNS:listener could not hand off client connection
TNS-12549: TNSperating system resource quota exceeded
TNS-12560: TNSrotocol adapter error
TNS-00519: Operating system resource quota exceeded
IBM/AIX RISC System/6000 Error: 11: Resource temporarily unavailableOS:IBM/AIX 5.3 ORACLE:10.2.0.3
AIX:MEM:4G
maxuproc =1024
DB1:/#vmstat 1 2System configuration: lcpu=8 mem=15744MBkthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 0 1370290 2080074 0 0 0 0 0 0 60 2857 378 0 0 99 0
0 0 1370333 2080031 0 0 0 0 0 0 233 4286 546 1 1 97 1 ORACLE:process =1000
session =1105
PGA=1000MB
SGA=1500MB
出现问题时V$PROCESS里面只有100多个,
目前数据库还没有上线,不知道什么问题?
解决方案 »
- 电脑断电之后,重启电脑,oracel连接不了?
- 跪求一条删除重复记录的sql语句
- ORA-01489:result of strling concatenation is too long疑问
- 请问大家,要把从ORACLE查询出来的文本数据导入到ACCESS中,用什么办法效率最高呢。
- 查询语句怎么把数字数据转换为字符串数据
- 100分求《Oracle PL/SQL程序设计基础教程》电子书下载,
- SQL语句to_char(to_date..)的问题
- ORACLE 的问题,附代码
- SQL Server与Oracle的转换
- 急:联想万金T200服务器+Win2K Server 装不起Oracle数据库
- ORA-12535:TNS:操作超时如何解决
- FROM R_RInfoTp_New_No_AGG@DL_ToGenesys HourInfo 请问这是什么意思
SolutionTo implement the solution, please execute the following steps:1. login as root.2. use smitty utility
Select 'System Environments'
Select 'Change / Show Characteristics of Operating System'
Maximum number of PROCESSES allowed per user' ---> change to an appropriate valueOR3. use command line:
chdev -l sys0 -a maxuproc <n>, where n is an appropraite value