Shulou(Shulou.com)06/01 Report--

The case of Oracle Study-- Oracle Sqlplus error

System environment:

Operating system: AIX5.3

Database: Oracle 10gR2

Case study:

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 4% / usr/dev/hd9var 2048.00 1725.55 16% 1704 1% / var/dev/hd3 2048.00 1902. 58% 4201% / tmp/dev/fwdump 3072.00 3071.21 1% 41% / var/adm/ras/platform/dev/hd1 2048.00 1821.98 12% 74.1% / home/proc-/ proc/dev/hd10opt 2048.00 1374 .77 33% 8934 / opt/dev/lv00 1024.00 991.80 4% 18 1% / var/adm/csd/dev/arch 10240.00 8347.63 19% / dev/lv02 15360.00 10097.80 35% 123693 4% / u012, View file permissions [oracle@aix220 ~] $ls-ld / u01OnOnOnOnOnOnLigure Feb MasterBank oracle dba Feb 17 16:40 / u01/app/oracle/admin/master/ [oracle@aix220 ~] $ls-ld / u01Grewxr Mustang-2 oracle dba 1536 Feb 17 19:48 / u01/app/oracle/admin/master/adump/3, View 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 oraclevgoraclevg: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% 420.1% / tmp/dev/fwdump 3072.00 3071.21 1% 41% / 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 % 521% / arch/dev/lv01 5120.00 4959.25 4% 161% / 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 failed: [root@aix220 /] # mount / u01Replaying log for / dev / lv02.mount: / dev/lv02 on / u01: Unformatted or incompatible mediaThe superblock on / dev/lv02 is dirty. Run a full fsck to fix. Repair file system: [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 file system succeeded: [root@aix220 /] # mount / U01 [root@aix220 /] # df-mFilesystem MB blocks Free% Used Iused % Iused Mounted on/dev/hd4 17408.00 1238.16 93% 37699 12% / / dev/hd2 8192.00 6310.39 23% 46534 4% / usr/dev/hd9var 2048.00 1725.55 16% 1704 1% / var/dev/hd3 2048.00 1902.58% 420.1% / tmp/dev/fwdump 3072.00 3071.21 1% 41% / 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/lv02 15360.00 10111.30 35% 123674 4% / U01 successfully executed sqlplus command: [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 2015Copyright (c) 1982 2005, Oracle. All rights reserved.Connected to an idle instance.SQL >

The database reported ORA-09925: Unable to create audit trail file. At that time, it checked that df-h had available space, and the permissions of the directory were also correct. There were nearly 24W files under the audit directory without df-I checking the usage of Inodes. The preliminary guess is that too many audit generated files caused the Inodes of the partition where the directory is located to run out. At that time, the usage of Inodes was not checked normally after deleting some audit TRACE files.

Summed up below: there are three reasons for ORA-09925:-- in fact, you can judge whether it is a permission problem or a disk space problem according to the error report.

Reason 1: the problem of directory permissions-- directory permissions have been changed and there is no permission to write audit data to the directory.

The owner of the Oracle bin directory (actually the entire oracle directory) has been changed:-- ls-al bin

Solution method

Chown-R oracle.oinstall / opt/orace

Reason 2: it is true that the disk is out of space-- df-h

Reason 3: disk Inodes is used up-- df-I

Reference: error when analog Linux disk partition has free space but no available iNodes: No space left on device

Error example:-- part of the network example 1: according to the error message, it can be judged that it is a directory permission problem that cannot be written.

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 2Pure-read-only file system-does not have write permission (possibly a problem with the file system)

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 Murray-there is no free space

# #

A 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 an entry for the audited action, which would 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.