DBCA***數(shù)據(jù)庫所有實例后，本想用RMAN duplicate方式克隆DB，因此在$ORACLE_BASE目錄下創(chuàng)建了相關(guān)的目錄admin/dupl/adump ,admin/dupl/dpump

在使用sqlplus正常連接空閑實例，手賤卻執(zhí)行了startup命令，oracle果斷出現(xiàn)ORA-09925錯誤

[oracle@tips ~]$ sqlplus??/ as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 26 04:27:58 2012

Connected to an idle instance.

SQL> startup

ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 9925

SQL> exit

[oracle@tips ~]$ sqlplus??/ as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 26 04:18:28 2012

Copyright (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 on

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

解決思路

1.首先確定$ORACLE_BASE目錄下的adump是否存在，文件名，路徑是否正確，權(quán)限是否正確

admin下的格式是$ORACLE_SID/adump

[oracle@tips ~]$ cd $ORACLE_BASE

[oracle@tips oracle]$ ls

admin??cfgtoollogs??checkpoints??diag??fast_recovery_area??oradata??product

[oracle@tips oracle]$ cd admin/dupl/

adump/??dpdump/

[oracle@tips oracle]$ cd admin/dupl/

[oracle@tips dupl]$ ls -ld adump/

drwxr-xr-x 2 oracle oinstall 4096 Nov 26 04:19 adump

排除adump目錄有無問題，排除adump權(quán)限問題

2.檢查是否空間adump使用的分區(qū)是否已經(jīng)過滿

[oracle@tips dupl]$ df -h

Filesystem? ?? ?? ?? ?Size??Used Avail Use% Mounted on

/dev/sda1? ?? ?? ?? ???34G? ?24G??8.0G??75% /

/dev/sda2? ?? ?? ?? ???99M??5.8M? ?88M? ?7% /home

tmpfs? ?? ?? ?? ?? ???1.0G? ???0??1.0G? ?0% /dev/shm

/dev/sdb1? ?? ?? ?? ???60G??4.6G? ?52G? ?9% /u01

排除分區(qū)過滿問題

3.檢查共享內(nèi)存段是否被stuck，在操作系統(tǒng)級別查看

[oracle@tips ~]$ 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

盡管沒有任何數(shù)據(jù)文件，參數(shù)文件，我們可以在系統(tǒng)中仍可以看到，系統(tǒng)確實分配了共享內(nèi)存段和信號量，oracle也啟動了相關(guān)進(jìn)程

[oracle@tips dupl]$ ps -ef | grep ora_

oracle? ? 4977? ???1??0 04:28 ?? ?? ???00:00:00 ora_pmon_dupl

oracle? ? 4979? ???1??0 04:28 ?? ?? ???00:00:00 ora_psp0_dupl

oracle? ? 4981? ???1??0 04:28 ?? ?? ???00:00:00 ora_vktm_dupl

oracle? ? 4985? ???1??0 04:28 ?? ?? ???00:00:00 ora_gen0_dupl

oracle? ? 4987? ???1??0 04:28 ?? ?? ???00:00:00 ora_diag_dupl

oracle? ? 4989? ???1??0 04:28 ?? ?? ???00:00:00 ora_dbrm_dupl

oracle? ? 4991? ???1??0 04:28 ?? ?? ???00:00:00 ora_dia0_dupl

oracle? ? 4993? ???1??1 04:28 ?? ?? ???00:00:00 ora_mman_dupl

oracle? ? 4995? ???1??0 04:28 ?? ?? ???00:00:00 ora_dbw0_dupl

oracle? ? 4997? ???1??0 04:28 ?? ?? ???00:00:00 ora_lgwr_dupl

oracle? ? 4999? ???1??0 04:28 ?? ?? ???00:00:00 ora_ckpt_dupl

oracle? ? 5001? ???1??0 04:28 ?? ?? ???00:00:00 ora_smon_dupl

oracle? ? 5003? ???1??0 04:28 ?? ?? ???00:00:00 ora_reco_dupl

oracle? ? 5005? ???1??0 04:28 ?? ?? ???00:00:00 ora_mmon_dupl

oracle? ? 5007? ???1??0 04:28 ?? ?? ???00:00:00 ora_mmnl_dupl

oracle? ? 5009? ???1??0 04:28 ?? ?? ???00:00:00 ora_d000_dupl

oracle? ? 5011? ???1??0 04:28 ?? ?? ???00:00:00 ora_s000_dupl

oracle? ? 5022??4912??0 04:28 pts/2? ? 00:00:00 grep ora_

由以上數(shù)據(jù)表明，系統(tǒng)分配了共享內(nèi)存段，所以即使$ORACLE_BASE目錄下有adump，權(quán)限也正確，

但是共享內(nèi)存和信號量已經(jīng)被卡住，仍會導(dǎo)致使用sqlplus時ORA-09925錯誤

解決方案有兩種

1.重新系統(tǒng)操作系統(tǒng)，釋放共享內(nèi)存段和信號量，(重新啟動系統(tǒng)耗時長)

2.在操作系統(tǒng)級別使用ipcsrm??-m ，ipcsrm -s ***共享內(nèi)存段和信號量即可

[oracle@tips ~]$ ipcrm??-m 3506182

[oracle@tips ~]$ ipcrm??-m 3538951

[oracle@tips ~]$ ipcrm??-m 3571720

[oracle@tips ~]$ ipcrm??-s 131073

[oracle@tips ~]$ sqlplus??/ as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 26 04:19:28 2012

Copyright (c) 1982, 2011, Oracle.??All rights reserved.

Connected to an idle instance.

總結(jié)

以上是生活随笔為你收集整理的oracle no such file or directory,ORA-09925 Linux-x86_64 Error: 2: No such file or directory的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。