ORACLE内存问题，大虾帮忙，急！

显示全部楼层 · 2007-10-20 08:38:44

ORACLE内存问题，大虾帮忙，急！
服务器：HP DL580 ，3.0GHz CPU*16，8GB内存，双千兆网卡；
操作系统：Windows 2003 Enterprise SP2
数据库：Oracle 10G
报错：TNS-12500: TNS:监听器无法启动专用服务器处理作业
TNS-12560: TNS:协议转接器错误

SELECT SID,SERIAL#,STATUS,SERVER FROM v$SESSION;
============================
SIDSERIAL#STATUSSERVER
2816902ACTIVEDEDICATED
28915617ACTIVEDEDICATED
29724ACTIVEDEDICATED
3114ACTIVEDEDICATED
29345599ACTIVEDEDICATED
3211ACTIVEDEDICATED
3247ACTIVEDEDICATED
3281ACTIVEDEDICATED
3301ACTIVEDEDICATED
3351ACTIVEDEDICATED
3341ACTIVEDEDICATED
3331ACTIVEDEDICATED
3321ACTIVEDEDICATED
3311ACTIVEDEDICATED
3291ACTIVEDEDICATED
3271ACTIVEDEDICATED
3231ACTIVEDEDICATED
27949512INACTIVEDEDICATED
30068INACTIVEDEDICATED
30313INACTIVEDEDICATED
3061INACTIVEDEDICATED
30822INACTIVEDEDICATED
32654238INACTIVEDEDICATED
31720479INACTIVEDEDICATED
3131INACTIVEDEDICATED
3121INACTIVEDEDICATED
3103INACTIVEDEDICATED
3079INACTIVEDEDICATED
3048INACTIVEDEDICATED
30194INACTIVEDEDICATED
2994INACTIVEDEDICATED
28213061INACTIVEDEDICATED
29812INACTIVEDEDICATED
29541915INACTIVEDEDICATED
TNSNAMES.ORA
=========================
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
AYPT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp-kfuldch7u5t4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AYPT)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

SQLNET.ORA
==============================================
# sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

求助：请帮忙断断数据库究竟是专用模式还是共享模式？判断的最基本标准是什么？怎么查看这些回话占用了多大的资源？帮忙分析为什么会出现上述错误？谢谢！
有个DBA说，是因为windows 32操作系统最大能管理3GB内存，ORACLE在此操作系统下最大可用内存为1.7GB，出现这种错误是因为操作系统没有资源响应新的请求导致，不知道对不对？

千问 · 2007-10-20 08:38:44

32位的oracle和windows？
看你连接不多，可以尝试缩小sga。

千问 · 2007-10-20 08:38:44

AYPT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp-kfuldch7u5t4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AYPT)
)
)

专用服务器
32位windows只能用1.7g内存，突破内存限制可能造成性能下降
听人说的你可以试试看