ora-09925: unable to create audit trail file DBCA when the database, and then execute DBCA time error ORA-09925: Unable to create audit trail file initially thought it was a privilege issue, $CD $ Oracle_home/rdbms/audit view under Permissions, belong to the main, in order to avoid trouble directly to give Aufit directory 777 permission to quit DBCA directly to execute again, the problem is still ora-09925: unable to create audit trail file checked oracle official data shows that some shared memory and semaphore segments may be stuck, so you need to perform IPCS to * * * Shared memory segments , shared semaphore related command parameters ipcs -m | -s [[email protected]_01 audit]$ ipcs------ shared memory segments --------Key shmid owner perms bytes nattch status 0x3b69ade0 589835 oracle 640 169869312 14 0x00000000 5046284 oracle 777 232500 2 dest 0x00000000 5079053 oracle 777 232500 2 dest ------ Semaphore Arrays --------Key semid owner perms nsems 0xc2e507f4 622593 oracle 640 154 ------ Message Queues --------Key msqid owner perms used-bytes messages [[email protected]_01 audit]$ ipcrm -m 589835[[email protected]_01 audit]$ ipcrm -m 5046284[[email Protected]_01 audit]$ ipcrm -m 5079053[[email protected]_01 audit]$ ipcrm -s 622593 re-execution of the dbca issue is resolved note: IPCS command in the Unix/linux, often because of shared memory, semaphores, queues and other shared information is not clear and cause some problems. The command to view the memory sharing information is ipcs [-m|-s|-q]. By default, shared memory, Semaphore, queue information,-m lists shared memory,-s lists shared semaphores, and-Q lists shared queues. How is it clear? The clear order is ipcrm [-m|-s|-q] id. -m *** shared memory,-s*** shared semaphore,-q*** Shared Queue. Here is an example of an operation: View plaincopy to clipboardprint? [[email protected] ora]$ ipcs ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status 0x0399ef4c 262145 ora 660 255852544 55 ------ Semaphore Arrays -------- key semid owner perms nsems 0x965bd64c 884736 ora 660 154 ------ Message Queues -------- key msqid owner perms used-bytes messages [[email protected] ora]$ ipcs ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status 0x0399ef4c 262145 ora 660 255852544 50 ------ Semaphore Arrays -------- key semid owner perms nsems 0x965bd64c 884736 ora 660 154 ------ Message Queues -------- key msqid owner perms used-bytes messages [[email protected] ora]$ Ipcrm -m 262145 [[email protected] ora]$ ipcrm -s 884736 [[email protected] ora]$ ipcs ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status ------ Semaphore Arrays -------- key semid owner perms nsems ------ Message Queues -------- key Msqid owner perms used-bytes messages [[email protected] ora]$ ipcs -m ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status [[email protected] ora]$ ipcs -s ------ Semaphore Arrays -------- key semid owner perms nsems [[email protected] ora]$ ipcs -q ------ Message Queues -------- key msqid owner perms used-bytes messages [[email protected] ora]$ IPCS------ SHARED&NBSp memory segments --------Key shmid owner perms bytes nattch status 0x0399ef4c 262145 ora 660 255852544 55 ------ semaphore arrays --------key semid owner perms nsems 0x965bd64c 884736 ora 660 154 ------ Message Queues --------key msqid owner perms USED-BYTES MESSAGES [[EMAIL PROTECTED] ORA]$ IPCS------ Shared Memory segments --------key shmid owner perms bytes nattch status 0x0399ef4c 262145 ora 660 255852544 50 ------ Semaphore Arrays --------Key semid owner perms nsems 0x965bd64c 884736 ora 660 154 ----- - message queues --------Key msqid owner perms used-bytes messages [[email protected] ora]$ ipcrm -m 262145[[email protected] ora]$ ipcrm -s 884736[[ email protected] ora]$ ipcs------ Shared Memory Segments --------key shmid owner perms bytes nattch status ------ Semaphore Arrays --- -----key semid owner perms nsems ------ Message Queues --------Key msqid owner perms used-bytes messages [[email protected] ora]$ ipcs -m------ Shared Memory Segments --------key shmid owner perms bytes nattch status [[email protected] ora]$ ipcs -s------ semaphore arrays --------key semid owner perms nsems [[email protected ] ORA]$ IPCS -Q------ Message Queues --------key msqid owner Perms used-bytes messages in the example above: the shared memory, Shared Queue, and shared semaphore are listed first with the IPCS command. Shows that the current system has shared memory, shared semaphores, and no shared queues. Then perform ipcrm -m 262145 to clearly share semid=262145 shared memory. The execution ipcrm -s 884736 clearly shares the amount of semid=884736 shared semaphores. Finally execute IPCS view shared memory, Shared Queue, share semaphore information, found all gone, the above Ipcrm clear shared memory and shared semaphore success
This article is from the "O Record" blog, so be sure to keep this source http://evils798.blog.51cto.com/8983296/1420945