度量快速开发平台-专业、快速的软件定制快开平台

标题: ORA-40030错误解决方法 [打印本页]

作者: caixuqad 时间: 2020-6-9 18:23
标题: ORA-40030错误解决方法

操作系统：windows server 2003 R2 SP2 enterprises 32位系统，
数据库版本：SQL> select * from v$version;

BANNER

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

Oracle9i Release 9.2.0.1.0 - Production

PL/SQL Release 9.2.0.1.0 - Production

CORE 9.2.0.1.0 Production

TNS for 32-bit Windows: Version 9.2.0.1.0 - Production

NLSRTLVersion 9.2.0.1.0 - Production

配置情况：

SQL> show parameter sga pgaprocess session

NAME TYPE VALUE

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

lock_sga boolean FALSE

pre_page_sga boolean FALSE

sga_max_size big integer 1076437756

NAME TYPE VALUE

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

pga_aggregate_target big integer 524288000

workarea_size_policy string AUTO

NAME TYPE VALUE

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

aq_tm_processes integer 1

db_writer_processes integer 2

job_queue_processes integer 10

log_archive_max_processes integer 2

processes integer 600

NAME TYPE VALUE

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

java_max_sessionspace_size integer 0

java_soft_sessionspace_limit integer 0

license_max_sessions integer 0

license_sessions_warning integer 0

logmnr_max_persistent_sessions integer 1

mts_sessions integer 660

session_cached_cursors integer 0

session_max_open_files integer 10

sessions integer 665

shared_server_sessions integer 660

警告日志：

Wed Aug 20 08:07:402014

Errors in filec:\oracle\admin\gxmtd\bdump\gxmtd_pmon_1328.trc:

ORA-04030: out ofprocess memory when trying to allocate 8389132 bytes (pga heap,redo readbuffer)

listener.log错误信息:

01-8月 -2014 10:48:45 *(CONNECT_DATA=(SID=ora10)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *(ADDRESS=(PROTOCOL=tcp)(HOST=89.18.17.158)(PORT=1882)) * establish * ora10 *12500

TNS-12500: TNS：监听器未能启动专用的服务器进程

TNS-12540: TNS：超出内部极限限制

TNS-12560: TNS: 协议适配器错误

TNS-00510: 超出内部极限限制

32-bit WindowsError: 8: Exec format error

作者: caixuqad 时间: 2020-6-9 18:23

作者: fteair 时间: 2020-6-10 14:06

作者: caixuqad 时间: 2020-6-10 18:25

欢迎光临度量快速开发平台-专业、快速的软件定制快开平台 (http://plat.delit.cn/)