oracle启动报错00450,ORA-01501: CREATE DATABASE failed,ora-01501database

ORA-01501: CREATE DATABASE failed,ora-01501database

使用dbca建库时遇到ORA-01501: CREATE DATABASE failed这个错误,检查告警日志,发现有下面错误信息: SMON: enabling tx recoveryFri Apr 29 14:06:25 HKT 2016replication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCProcess QMNC died, see its trace fileFri Apr 29 14:06:26 HKT 2016Errors in file /u01/app/oracle/admin/EPPS/udump/epps_ora_6832.trc:ORA-00444: background process "QMNC" failed while startingORA-00020: maximum number of processes () exceededFri Apr 29 14:06:26 HKT 2016Errors in file /u01/app/oracle/admin/EPPS/udump/epps_ora_6832.trc:ORA-01501: CREATE DATABASE failedORA-00450: background process 'QMNC' did not startORA-00444: background process "QMNC" failed while startingORA-00020: maximum number of processes () exceededError 450 happened during db open, shutting down databaseUSER: terminating instance due to error 450Instance terminated by USER, pid = 6832ORA-1092 signalled during: CREATE DATABASE "EPPS"

1124901.html

从错误信息看,后台进程"QMNC"没有启动,后台进程"QMNC"启动失败,检查对应的跟踪文件,发现ORA-00020: maximum number of processes () exceeded,也就是说因为processes超了,导致后台进程无法启动。

1124901.html

仔细检查后,发现我设置的参数process的值为150,但是在连接模式(Connection Mode)里给了Shared Servrer给了一个很大的值(当时一边操作,一边接电话,把这个值误当成session的值),所以导致后面一系列错误。重新正确设置Shared Servrer值,然后用DBCA建库,问题解决!

https://i-blog.csdnimg.cn/blog_migrate/dbfbf53b2b545a3270d80c36e3111671.pngwww.dengb.comtruehttps://i-blog.csdnimg.cn/blog_migrate/dbfbf53b2b545a3270d80c36e3111671.pngTechArticleORA-01501: CREATE DATABASE failed,ora-01501database 使用dbca建库时遇到ORA-01501: CREATE DATABASE failed这个错误,检查告警日志,发现有下面错误信息: S...

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值