数据库报无法连接,tns-12500,无法创建专用的服务器进程。我在操作系统的日志信息中发现如下错误。DescriptionSOFTWARE PROGRAM ABNORMALLY TERMINATEDProbable CausesSYSTEM RUNNING OUT OF PAGING SPACEFailure CausesINSUFFICIENT PAGING SPACE DEFINED FOR THE SYSTEM...
显示全部数据库报无法连接,tns-12500,无法创建专用的服务器进程。
我在操作系统的日志信息中发现如下错误。
Description
SOFTWARE PROGRAM ABNORMALLY TERMINATED
Probable Causes
SYSTEM RUNNING OUT OF PAGING SPACE
Failure Causes
INSUFFICIENT PAGING SPACE DEFINED FOR THE SYSTEM
PROGRAM USING EXCESSIVE AMOUNT OF PAGING SPACE
Recommended Actions
DEFINE ADDITIONAL PAGING SPACE
REDUCE PAGING SPACE REQUIREMENTS OF PROGRAM(S)
Detail Data
PROGRAM
oracle
USER'S PROCESS ID:
0
PROGRAM'S PAGING SPACE USE IN 1KB BLOCKS
0
---------------------------------------------------------------------------
LABEL: PGSP_KILL
IDENTIFIER: C5C09FFA
Date/Time: Thu Dec 25 09:11:34 CST 2008
Sequence Number: 72223
Machine Id: 00CE79EF4C00
Node Id: p595-1-lpar4
Class: S
Type: PERM
Resource Name: SYSVMM
topas的结果如下:
Kernel 0.1 |# | Reads 2 Rawin 0
User 0.0 |# | Writes 5 Ttyout 251
Wait 0.0 | | Forks 0 Igets 0
Idle 99.9 |############################| Execs 0 Namei 1
Runqueue 0.0 Dirblk 0
Network KBPS I-Pack O-Pack KB-In KB-Out Waitqueue 0.0
en0 1.1 5.5 6.0 0.3 0.8
lo0 0.0 0.0 0.0 0.0 0.0 PAGING MEMORY
Faults 0 Real,MB 16384
Disk Busy% KBPS TPS KB-Read KB-Writ Steals 0 % Comp 95.9
hdisk0 0.0 0.0 0.0 0.0 0.0 PgspIn 0 % Noncomp 0.9
hdisk1 0.0 0.0 0.0 0.0 0.0 PgspOut 0 % Client 0.9
hdisk3 0.0 0.0 0.0 0.0 0.0 PageIn 0
hdisk4 0.0 0.0 0.0 0.0 0.0 PageOut 0 PAGING SPACE
hdisk46 0.0 0.0 0.0 0.0 0.0 Sios 0 Size,MB 512
hdisk11 0.0 0.0 0.0 0.0 0.0 % Used 94.9
hdisk67 0.0 0.0 0.0 0.0 0.0 NFS (calls/sec) % Free 5.0
hdisk5 0.0 0.0 0.0 0.0 0.0 ServerV2 0
hdisk10 0.0 0.0 0.0 0.0 0.0 ClientV2 0 Press:
hdisk8 0.0 0.0 0.0 0.0 0.0 ServerV3 0 "h" for help
hdisk49 0.0 0.0 0.0 0.0 0.0 ClientV3 0 "q" to quit
hdisk6 0.0 0.0 0.0 0.0 0.0
hdisk9 0.0 0.0 0.0 0.0 0.0
hdisk13 0.0 0.0 0.0 0.0 0.0
hdisk69 0.0 0.0 0.0 0.0 0.0
Name PID CPU% PgSp Owner
dtterm 1474682 0.1 1.5 root
topas 1769562 0.0 2.3 root
gil 98352 0.0 0.1 root
xmgc 45078 0.0 0.0 root
resv_min 221314 0.0 0.1 root
oracle 1843368 0.0 3.7 oracle
oracle 401608 0.0 8.5 oracle
rmcd 274600 0.0 1.4 root
sendmail 290980 0.0 1.0 root
rpc.lock 307358 0.0 0.2 root
pilegc 40980 0.0 0.2 root
oracle 368838 0.0 4.5 oracle
syncd 110760 0.0 0.5 root
netm 94254 0.0 0.0 root
oracle 1355846 0.0 8.5 oracle
oracle 1147092 0.0 8.4 oracle
oracle 352464 0.0 6.3 oracle
# more /etc/swapspaces
* /etc/swapspaces
*
* This file lists all the paging spaces that are automatically put into
* service on each system restart (the 'swapon -a' command executed from
* /etc/rc swaps on every device listed here).
*
* WARNING: Only paging space devices should be listed here.
*
* This file is modified by the chps, mkps and rmps commands and referenced
* by the lsps and swapon commands.
hd6:
dev = /dev/hd6
通过topas说明内存16G,交换paging space 512M,很明显空间不够使用。
解决方法:增加交换分区
smit pgsp
mkps
增加后问题解决。
收起