ORA-09925 linux-x86_64 error:2: No such file or directory

Source: Internet
Author: User

After dbca*** all instances of the database, I wanted to clone the DB in rman duplicate mode, so I created the relevant directory under the $oracle_base directory Admin/dupl/adump ,admin/dupl/dpump    in use sqlplus normal connection idle instance, hand cheap but executed the startup command, Oracle decisively appear ORA-09925 error [[email protected] ~]$  sqlplus  / as sysdbasql*plus: release 11.2.0.3.0 production on  Mon nov 26 04:27:58 2012connected to an idle instance. Sql> startupora-09925: unable to create audit trail filelinux-x86_64  Error: 2: No such file or directoryAdditional information:  9925sql> exit[[email protected] ~]$ sqlplus  / as sysdbasql*plus:  Release 11.2.0.3.0 Production on Mon Nov 26 04:18:28  2012copyright  (c)  1982, 2011, oracle.  all rights reserved. Error: ora-09925: unable to create audit trail file linux-x86_64 error: 2: no such file or directory  additional information: 9925 ora-01075: you are currently logged  onEnter user-name: ERROR:ORA-01017: invalid username/password; logon  Denied solution 1. First determine whether the adump exists in the $oracle_base directory, the file name, whether the path is correct, and if the permissions are correct, the format under admin is $oracle_sid/adump[[email protected]  ~]$ cd  $ORACLE _base[[email protected] oracle]$ lsadmin  cfgtoollogs   checkpoints  diag  fast_recovery_area  oradata  product[[ email protected] oracle]$ cd admin/dupl/adump/  dpdump/ [[email  protected] oracle]$ cd admin/dupl/[[email protected] dupl]$ ls -ld  adump/drwxr-xr-x 2 oracle oinstall 4096 nov 26 04:19  Adump exclude Adump Directory is problematic, troubleshoot Adump permissions issues 2. Check if the partition used by the space Adump isIt's already full of [[email protected] dupl]$ df -h filesystem      .       size  used avail use% mounted on/dev/sda1               34g   24g   8.0G  75% //dev/sda2               99M  5.8M   88M   7% /hometmpfs                  1.0G      0  1.0G   0% /dev/shm/dev/sdb1               60G  4.6G   52G    9% /U01 Exclude partition over-full problem 3. Check if the shared memory segment is stuck and at the operating system level see [[Email protected] ~]$ ipcs -a  ------ shared memory Segments --------key        shmid       owner      perms      bytes       nattch     status       0x00000000 3342337    root      644         80         2                         0x00000000 3375107    root      644         16384      2                         0x00000000 3407876    root      644         280        2                        0x00000000 3506182     oracle    640         33554432   17                       0x00000000 3538951    oracle     640        5016387584 17                        0x0d99ce94 3571720    oracle    640         2097152    17                       ------ Semaphore Arrays --------key         semid      owner       perms      nsems     0x59451e7c  131073     oracle    640         154       ------ Message Queues --------Key         msqid      owner       perms      used-bytes   messages      Although there are no data files, parameter files, we can still see in the system that the system does allocate shared memory segments and semaphores, and Oracle initiates the related process [[email protected]  Dupl]$ ps -ef | grep ora_oracle    4977     1  0 04:28 ?         00:00:00 ora_pmon_duploracle    4979      1  0 04:28 ?         00:00:00 ora_psp0_duploracle    4981     1  0  04:28 ?        00:00:00 ora_vktm_duploracle     4985     1  0 04:28 ?         00:00:00 ora_gen0_duploracle    4987      1  0 04:28 ?        00:00:00 ora_diag_ duploracle    4989     1  0 04:28 ?         00:00:00 ora_dbrm_duploracle    4991     1   0 04:28 ?        00:00:00 ora_dia0_duploracle     4993     1  1 04:28 ?         00:00:00 ora_mman_duploracle    4995      1  0 04:28 ?        00:00:00 ora_ dbw0_duploracle    4997     1  0 04:28 ?         00:00:00 ora_lgwr_duploracle    4999      1  0 04:28 ?         00:00:00 ora_ckpt_duploracle    5001     1  0  04:28 ?        00:00:00 ora_smon_duploracle    5003      1  0 04:28 ?        00:00:00  ora_reco_duploracle    5005     1  0 04:28  ?        00:00:00 ora_mmon_duploracle     5007     1  0 04:28 ?         00:00:00 ora_mmnl_duploracle    5009     1   0 04:28 ?        00:00:00 ora_d000_duploracle     5011     1  0 04:28 ?         00:00:00 ora_s000_duploracle    5022  4912   0 04:28 pTs/2    00:00:00 grep ora_ by the above data shows that the system is allocated a shared memory segment, so even if the $oracle_base directory has adump, the permissions are correct, However, shared memory and semaphores are stuck, and there are two  1 of ORA-09925 error solutions when using Sqlplus. Re-system operating system, freeing shared memory segments and semaphores (reboot system takes a long time) 2. Using the IPCSRM at the operating system level   -m ,ipcsrm -s *** shared memory segments and semaphores can be [[email protected] ~]$ ipcrm   -m 3506182 [[email protected] ~]$ ipcrm  -m 3538951[[email  protected] ~]$ ipcrm  -m 3571720[[email protected] ~]$ ipcrm   -s 131073[[email protected] ~]$ sqlplus  / as sysdbasql*plus:  Release 11.2.0.3.0 Production on Mon Nov 26 04:19:28  2012copyright  (c)  1982, 2011, oracle.  all rights reserved. Connected to an idle instance.


This article is from the "O Record" blog, so be sure to keep this source http://evils798.blog.51cto.com/8983296/1420947

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.