OracleStudy case -- OracleSqlplus Error

Source: Internet
Author: User
OracleStudy case -- OracleSqlplus error system environment: Operating System: AIX5.3 Database: External

Oracle Study case -- Oracle Sqlplus error system environment: Operating System: AIX5.3 Database: Oracle 10gR2 650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/12142C928-0.jpg "title =" ax1.png "alt =" wKiom1S3elTR8RPtAAIs2ex0EMc791.jpg "/>

Oracle Study case -- Oracle Sqlplus Error

System Environment:

Operating System: AIX5.3

Database: Oracle 10gR2


650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/12142C928-0.jpg "title =" ax1.png "alt =" wKiom1S3elTR8RPtAAIs2ex0EMc791.jpg "/>

Case Analysis:

1. View spatial information [oracle @ aix220 ~] $ Df-mFilesystem MB blocks Free % Used Iused % Iused Mounted on/dev/hd4 17408.00 1238.15 93% 37699 12%/dev/hd2 8192.00 6310.39 23% 46534/usr/dev/hd9var 4% 1725.55 16% 1704 1%/var/dev/hd3 2048.00 1902.58 8% 420 1%/tmp/dev/fwdump 3072.00 3071.21 1% 1% 4 2048.00/var/adm/ras/platform/dev/hd1 1821.98 12% 74 1%/home/proc--/proc/dev/hd10opt 2048.00 1374.77 33% 8934 3%/opt/dev/lv00 1 024.00 991.80 4% 18 1%/var/adm/csd/dev/arch 10240.00 8347.63 19% 15360.00/dev/lv02 10097.80 35% 123693 4%/u012, View File Permissions [oracle @ aix220 ~] $ Ls-ld/u01/app/oracle/admin/master/drwxr-x --- 8 oracle dba 512 Feb 17/u01/app/oracle/admin/master/[oracle @ aix220 ~] $ Ls-ld/u01/app/oracle/admin/master/adump/drwxr-x --- 2 oracle dba 1536 Feb 17/u01/app/oracle/admin/master/adump /3. view the file system information [oracle @ aix220 dbs] $ cat/etc/filesystems/u01: dev =/dev/lv02 vfs = jfs log =/dev/loglv00 mount = true options = rw account = false [root @ aix220/] # lsvg-l limit levg1_levg: lv name type LPs PPs PVs lv state mount POINTloglv00 jfslog 1 1 1 closed/syncd N/Alv02 jfs 120 120 1 closed/syncd/u01 [root @ aix220/] # df-mFilesystem MB blocks Free % Used Iused % Iused Mounted on/dev/hd4 17408.00 1238.18 93% 37700 12% // dev/hd2 8192.00 6310.39 23% 46534 4%/usr/dev/hd9var 2048.00 1725.56 16% 1704 1%/var/dev/hd3 2048.00 1902.58 8% 420 1%/tmp/dev/fwdump 3072.00 3071.21 1% 4 1%/var /adm/ras/platform/dev/hd1 2048.00 1821.98 12% 74 1%/home/proc--/proc/dev/hd10opt 2048.00 1374.77 33% 8934 3%/opt/dev/lv00 1024.00 991.80 4% 18 1%/var/adm/csd/dev/arch 10240.00 8347.63 19% 1%/arch/dev/lv01 5120.00 4959.25 4% 16 1%/flash/dev/lv03 25600.00 24796.43 4% 17 1%/home/oracle/arch_masterrhel152: /backup/cuug15/storage30 14111.05 13052.23 8% 31 1%/backupmount file system failure: [root @ aix220/] # mount/u01Replaying log for/dev/lv02.mount: /dev/lv02 on/u01: Unformatted or incompatibl E mediaThe superblock on/dev/lv02 is dirty. run a full fsck to fix. file System Repair: [root @ aix220/] # fsck-y/dev/lv02 ...... ** Phase 5-Check Inode Map ** Phase 6-Check Block MapBad Block Map (SALVAGED) ** Phase 6b-Salvage Block MapSuperblock is marked dirty (FIXED) 123665 files 10749336 blocks 20707944 free ****** Filesystem was modified ****** mount the file system successfully: [root @ aix220/] # mount/u01 [root @ aix220/] # df-mFile System MB blocks Free % Used Iused % Iused Mounted on/dev/hd4 17408.00 1238.16 93% 37699 12% 8192.00 // dev/hd2 6310.39 23% 46534 4% 2048.00/usr/dev/hd9var 1725.55 16% 1704 1%/var/dev/hd3 2048.00 1902.58 8% 420 1%/tmp/dev/fwdump 3072.00 3071.21 1% 1% 4 2048.00/var/adm/ras/platform/dev/hd1 1821.98 12% 1% 74 /home/proc---/proc/dev/hd10opt 2048.00 1374.77 33% 8934/opt/dev/lv00 3% 99 1.80 4% 18 1%/var/adm/csd/dev/lv02 15360.00 10111.30 35% 123674 4%/u01 run the sqlplus command successfully: [root @ aix220/] # su-oracle [oracle @ aix220 ~] $ Sqlplus '/as sysdba' SQL * Plus: Release 10.2.0.1.0-Production on Tue Feb 17 19:46:03 2015 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to an idle instance. SQL>

Database reports ORA-09925: Unable to create audit trail file, when the query df-h available space, directory permissions are also correct, not df-I view Inodes usage, there are nearly files in the Audit directory. It is preliminarily estimated that the Inodes in the partition where the directory is located are used up due to the large number of audit generated files. After deleting some audit TRACE files, the Inodes usage is normally not checked.

Summary: ORA-09925 has the following reasons:-In fact, you can determine whether the problem of permission or disk space based on the error

Cause 1:Directory permission problem-the directory permission has been changed and the audit data has no permission to be written to the directory
The owner of the Oracle bin directory (actually the entire oracle directory) is changed: -- ls-al bin
Solution
Chown-R oracle. oinstall/opt/release E
Cause 2: It is true that the disk has no space -- df-h
Cause 3:Disk Inodes used up -- df-I

Refer:When a disk partition in a simulated Linux has free space and No Inodes is available, the error "No space left on device" is returned.

Error example: -- some network Example 1: You can identify the cause of directory permission failure based on the error message.

ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925

Example 2: -- read-only file system -- no write permission (possibly due to file system problems)

ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925
ORA-01075: you are currently logged on

Example 3: -- no available space

650) this. length = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/12142B391-1.jpg "title =" 1401089521285.jpg" alt = "wKiom1S4dWTwKcNbAAG6a2Edp1Y833.jpg"/> ####################### #######
Description and Solution on MOS:
Problem Description -------------------
Problem occurs when: $ ORACLE_HOME/rdbms/audit directory is full or $ ORACLE_HOME/rdbms/audit directory doesn't exist as a side effect of this problem oracle asks for password after connect internal

Solution Description --------------------
Make space available in $ ORACLE_HOME/rdbms/audit by removing files that are not needed or Make sure the directory exists and is readable by oracle or Change init. ora audit_file_dest to an existing directory. change init. ora parameter means restart instance as workaround kill pmon.

Explanation -----------
The behavior on Unix is to write a file named ora _ . Aud into the directory specified by audit_file_dest. the default directory is/rdbms/audit. the file will contain in an entry for the audited action, which wocould be internal logins or startup. on ports which support an OS audit trail, these records will be written there. this feature is not affected by the settings of the audit_trail parameter.

ORA-09925: "Unable to create audit trail file"

Cause: ORACLE was not able to create the file being used to hold audit trail records.

Action: Check the UNIX error number for a possible operating system error.
If there is no error, contact ORACLE customer support.

References ----------

[NOTE: 1018924.102] ORA-09925 on database startup [NOTE: 1056988.6] ORA-09925 during hot backups [NOTE: 21073.1]

OERR: ORA-9925 "Unable to create audit trail [BUG: 723955] sqlplus allows db startup (but not shutdown)

IF AUDIT_FILE_DEST DOESN't EXIST

Search Words ------------ ORA-09925 audit trail audit_file_dest

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.