温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

ORA-13516 / ORA-06512 DBCA建库,密码特殊符号报错

发布时间:2020-08-06 08:07:00 来源:网络 阅读:390 作者:roidba 栏目:关系型数据库

Oracle 11.2.0.4使用DBCA建库,sys/system密码使用了特殊符号结果安装过程中报错。

以下为解决方法:

APPLIES TO:
Oracle Database - Standard Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
SYMPTOMS
 DBCA fails while in the middle of creating the database with the following errors

ORA-13516: AWR Operation failed: CATPROC not valid
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 206
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 239
ORA-06512: at line 1

CAUSE
 ORA-13516 DURING DB CREATION WHEN DB PWD CONTAINS " " (SPACE) CHARACTER Bug ID 8633879

This Bug is suspended due to lack of required information, but the issue is solved by using workaround (removing the space and the special characters used in the passwd)

SOLUTION
Do not include any spaces or special characters in the password,

If you are particular with the passwords, then you can reset the passwords once the database is created. Eg: 

conn / as sysdba

alter user USERNAME identified by PWD;
向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI