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