ORA-01501: CREATE DATABASE failed

简介: 使用dbca建库时遇到ORA-01501: CREATE DATABASE failed这个错误,检查告警日志,发现有下面错误信息: SMON: enabling tx recoveryFri Apr 29 14:06:25 HKT 2016replication_dependenc...

    使用dbca建库时遇到ORA-01501: CREATE DATABASE failed这个错误,检查告警日志,发现有下面错误信息:

SMON: enabling tx recovery
Fri Apr 29 14:06:25 HKT 2016
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Process QMNC died, see its trace file
Fri Apr 29 14:06:26 HKT 2016
Errors in file /u01/app/oracle/admin/EPPS/udump/epps_ora_6832.trc:
ORA-00444: background process "QMNC" failed while starting
ORA-00020: maximum number of processes () exceeded
Fri Apr 29 14:06:26 HKT 2016
Errors in file /u01/app/oracle/admin/EPPS/udump/epps_ora_6832.trc:
ORA-01501: CREATE DATABASE failed
ORA-00450: background process 'QMNC' did not start
ORA-00444: background process "QMNC" failed while starting
ORA-00020: maximum number of processes () exceeded
Error 450 happened during db open, shutting down database
USER: terminating instance due to error 450
Instance terminated by USER, pid = 6832
ORA-1092 signalled during: CREATE DATABASE "EPPS"

 

 

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

 

 

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

相关文章
|
3月前
|
数据库连接 网络安全 数据库
Could not create connection to database server.Attempted reconnect 3 times. Giving up.
这篇文章提供了解决数据库连接问题的方法,建议在连接字符串后添加`?serverTimezone=UTC`来指定时区,并检查网络设置、连接属性、驱动版本以及是否需要SSH或SSL连接。
Could not create connection to database server.Attempted reconnect 3 times. Giving up.
|
4月前
|
SQL 数据库
SQL CREATE DATABASE 语句
【7月更文挑战第18天】SQL CREATE DATABASE 语句。
137 1
|
5月前
|
SQL 数据库
SQL CREATE DATABASE 语句
SQL CREATE DATABASE 语句
64 4
|
4月前
|
数据库
数据库bug-[08001] Could not create connection to database server. Attempted reconnect 3,主机名ip必须写对
数据库bug-[08001] Could not create connection to database server. Attempted reconnect 3,主机名ip必须写对
|
5月前
|
SQL 数据库
SQL CREATE DATABASE 语句
SQL CREATE DATABASE 语句
44 2
|
XML 关系型数据库 MySQL
已解决Failed to connect mysql database,please check username and password,or mysql is version8? true
已解决Failed to connect mysql database,please check username and password,or mysql is version8? true
285 0
|
数据库
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
156 0
|
SQL 数据库
CREATE DATABASE 语句
CREATE DATABASE 语句
121 1
|
存储 SQL 关系型数据库
开发指南—DDL语句—分库分表语法—CREATE DATABASE
CREATE DATABASE语句用于创建数据库,并可以指定数据库的默认属性(如数据库默认字符集,校验规则等)。
145 0