Ora-09925:unable to create audit trail file at DBCA

Source: Internet
Author: User
Tags semaphore

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.