立即注册 登录
玉祥平台客服-15087858732 返回首页

王爱东的个人空间 http://p.delit.cn/?3 [收藏] [复制] [RSS]

日志

数据库安装报错之:Oracle 11gR1 dbca – maximum number of sessions exceeded。ORA- ...

已有 1082 次阅读2020-6-12 16:28 |个人分类:数据库技术|系统分类:数据库技术| 数据库安装, number, Oracle

在服务器上安装oracle11.1.0.7数据库。在用dbca创建数据库时,报告如下错误:

ORA-12801: error signaled in parallel query server P073.
ORA-00018: maximum number of sessions exceeded
ORA-06512: at “SYS.UTL_RECOMP”, line 629
ORA-06512: at “SYS.UTL_RECOMP”, line 671
ORA-06512: at line 1

经过检查,发现是创建数据库模板的参数parallel_max_servers有问题,安装的服务器是4核处理器,每核心12线程,共计48线程。

 

以下是资料查询的解决办法:


Oracle 11gR1 dbca – maximum number of sessions exceeded

Used dbca CLI

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName DB1 -sid DB1 -SysPassword oracle -SystemPassword oracle -emConfiguration NONE -storageType ASM -asmSysPassword oracle -diskGroupName DG1 -datafileDestination DG1 -recoveryAreaDestination FG1

At time of creating the 11gr1 database using dbca, I was facing following error quite frequently.

ORA-12801: error signaled in parallel query server P073.
ORA-00018: maximum number of sessions exceeded
ORA-06512: at “SYS.UTL_RECOMP”, line 629
ORA-06512: at “SYS.UTL_RECOMP”, line 671
ORA-06512: at line 1
Solution to this problem, was to change the values for parallel server related parameters. Now the database is not created yet, so where to change this?

DBCA uses values from template file (*.dbc) specified in the -templateName parameter. For example, in above dbca CLI I’ve used General_Purpose.dbc as my template.

Before executing the dbca, I’ve modified /oracle/ora11/assistants/dbca/templates/General_Purpose.dbc file as following:

就说说安装数据库软件的时候,不创建数据库,先找到oracle/ora11/assistants/dbca/templates/General_Purpose.dbc 文件,把下面图中红色部分增加进去后。再用DBCA工具创建数据库。

 


路过

鸡蛋

鲜花

握手

雷人

评论 (0 个评论)

facelist

您需要登录后才可以评论 登录 | 立即注册

手机版|小黑屋|玉祥公司客服-玉祥集团客服  本站关键词:快速开发平台

GMT+8, 2024-5-19 02:47 , Processed in 0.074210 second(s), 21 queries .

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

返回顶部