ORA-09925 Unable to create audit trail file,DBCA

ORA-09925: Unable to create audit trail file 在DBCA时 删除数据库后,再执行dbca时候报错 ORA-09925: Unable to create audit trail file 起初以为是权限问题,
$cd $ORACLE_HOME/rdbms/audit 查看下权限,属主,为了避免麻烦直接赋予aufit目录 777权限
退出DBCA直接们再次执行,问题依旧
ORA-09925: Unable to create audit trail file
查过oracle 官方资料显示,有些共享内存和信号量段可能被stuck,因此需要执行ipcs来删除共享内存段,共享信号量
相关命令参数 ipcs -m -s
[oracle@cat1 ~]$ ipcs

------ Message Queues --------
key msqid owner perms used-bytes messages

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0xcacdecdc 65536 grid 600 28672 40
0x00000000 98305 oracle 600 9142272 180
0x00000000 131074 oracle 600 2801795072 90
0x00000000 163843 oracle 600 7634944 90
0x4bc1c778 196612 oracle 600 20480 90

------ Semaphore Arrays --------
key semid owner perms nsems
0xb4dbd908 98304 grid 600 250
0xb4dbd909 131073 grid 600 250
0xb4dbd90a 163842 grid 600 250
0xb4dbd90b 196611 grid 600 250
0xb4dbd90c 229380 grid 600 250
0x4511d800 360453 oracle 600 250
0x4511d801 393222 oracle 600 250

[oracle@cat1 ~]$ ipcrm -m 98305
[oracle@cat1 ~]$ ipcrm -m 131074
[oracle@cat1 ~]$ ipcrm -m 163843
[oracle@cat1 ~]$ ipcrm -s 196612
再次执行DBCA 问题得到解决

Related Posts