使用ASM安装后，Oracle 19C创建数据库失败

Question

我安装了19C网格，然后只安装了19C软件，一切都是成功的。然后我尝试用dbca创建一个数据库，但是失败了，奇怪的是RMAN在日志中失败了，我怀疑这是网格特权问题，但我找不到它是什么。

有关此问题的更多日志在上述日志之前，请帮助检查：

线程-516 RMANEngine.readSqlOutput:997日志RMAN Output=allocated通道: ORA_DISK_1 Thread-516 RMANEngine.readSqlOutput:997 Log Output=channel ORA_DISK_1: SID=498 device type=DISK Thread-516 RMANEngine.readSqlOutput:997 Log Output= Thread-516 RMANEngine.readSqlOutput:997 Log Output=channel ORA_DISK_1:启动数据文件备份集还原线程-516 RMANEngine.readSqlOutput:997 Log Output=channel ORA_DISK_1:指定从备份集恢复数据文件-516 RMANEngine.readSqlOutput:997 Log RMANEngine.readSqlOutput:997 en19:恢复数据文件00001到+ORA线程-516 /opt/DB/oracle/product/19c/db/assistants/dbca/templates/Seed_Database.dfb日志RMAN Output=channel ORA_DISK_1:从备份片读取RMANEngine.readSqlOutput:997 Thread-516 RMANEngine.readSqlOutput:997 Log Output=channel ORA_DISK_1: ORA-19870:在还原备份段时出错-516 RMANEngine.readSqlOutput:997日志RMAN输出=ORA-19504:创建文件"+ORA“线程失败-516 RMANEngine.readSqlOutput:997日志RMAN输出=ORA-17502: ksfdcre:4未能创建文件+ORA线程-516 RMANEngine.readSqlOutput:997日志RMAN输出=ORA-15001:磁盘组"ORA“不存在或未挂载RMANEngine.readSqlOutput:997日志RMAN输出=ora-01017:无效用户名/密码；登录拒绝线程-516 RMANEngine.readSqlOutput:997日志RMAN Output= Thread-516 RMANEngine.readSqlOutput:997 logon Output=failover到以前的备份线程-516 RMANEngine.readSqlOutput:997日志RMAN Output= Thread-516 RMANEngine.readSqlOutput:997 logon Output=creating数据文件number=1 name=+ORA Thread-516 RMANEngine.readSqlOutput:997 logon输出= RMAN -00571: RMANEngine.readSqlOutput:997线程-516 RMANEngine.readSqlOutput:997 logon输出= RMAN -00569：===============错误消息堆栈遵循=============== Thread-516 RMANEngine.readSqlOutput:997 Log RMAN输出= RMAN -00571：===========================================================线程-516 RMANEngine.readSqlOutput:997日志RMAN输出= RMAN -03002:恢复失败命令09/20/2021 15:36:18线程-516 RMANEngine.readSqlOutput:997日志RMAN输出=ora-01180:无法创建数据文件1线程-516 RMANEngine.readSqlOutput:997日志RMAN Output=线程-516 RMANEngine.readSqlOutput:997日志RMAN Output=RMAN>线程-516 RMANEngine.readSqlOutput:997日志RMAN Output=echo设置的线程-516 RMANEngine.readSqlOutput:997日志RMAN Output=set回波；线程-516 RMANEngine.readSqlOutput:1040 hasError是真线程-516 RMANEngine.readSqlOutput:1046错误跟踪检测到

Starting restore at 20-SEP-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=498 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +ORA
channel ORA_DISK_1: reading from backup piece /opt/DB/oracle/product/19c/db/assistants/dbca/templates/Seed_Database.dfb
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /opt/DB/oracle/product/19c/db/assistants/dbca/templates/Seed_Database.dfb
ORA-19504: failed to create file "+ORA"
ORA-17502: ksfdcre:4 Failed to create file +ORA
ORA-15001: diskgroup "ORA" does not exist or is not mounted
ORA-01017: invalid username/password; logon denied
failover to previous backup
creating datafile file number=1 name=+ORA
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/20/2021 15:36:18
ORA-01180: can not create datafile 1
RMAN>
echo set on

有人能给我一些建议吗？

Answer 1

谢谢大家，这个问题已经在谷歌的帮助下解决了。这是操作系统设置问题，网格和甲骨文没有被设置为正确的组，使用命令

usermod -g oinstall -G oinstall，dba，oper oracle usermod -g oinstall -G oinstall，dba，oper网格。

有关详情，请参阅以下连结。

https://grepora.com/tag/dbca/

但是在数据库创建后还有问题，当试图清理和发布配置时，仍然会引发错误，但是数据库可以启动。让我检查一下，然后再更新。