Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the problem of sqlplus connection error ORA-09925". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "how to solve the problem of sqlplus connection error ORA-09925"!

The questions are as follows

Marven@hpserver2 ~] $sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.4.0-Production on Wed Feb 1 15:55:07 2012Copyright (c) 1982, 2007, Oracle. All Rights Reserved.ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 30: Read-only 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

At first, I thought it was a file directory permission problem. After troubleshooting for a long time, there was no problem with Oracle directory permissions, but every layer of vi test.txt under the Oracle_HOME path could not be written successfully. Finally, it was not checked out. After rebooting the host, it was OK to test vi test.txt, and there was no problem with sqlplus connection. Now we will make a summary of the problems collected on the Internet.

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

Such as:

$sqlplus Plus: Release.. Production Thu May, Oracle. : Unable audit trail x86_64 Error:: Unable audit trail x86_64 Error:

When the above error occurs, there are three possibilities:

1. The disk space is full, so the audit file cannot be created. Use df-h to query the disk space.

2. The disk inodes has been used up, so the new file cannot be opened. Use df-I to check the inode usage.

3. Insufficient path permissions, unable to create audit file, and check path permissions ls-l.

But all three may have different false positives:

Insufficient disk space or running out of inodes: Linux-x86_64 Error: 28: No space left on device

Insufficient permissions: Linux-x86_64 Error: 30: Read-only file system or Linux Error: 13: Permission denied

According to the error reported above, it is due to insufficient permissions. After checking, it is because the permission of the / U01 path is root:root, which is normal after being modified to Oracle:oinstall.

When the inode is used up, you need to delete some files under the corresponding path. The following inode has used 100%.

At this point, I believe you have a deeper understanding of "how to solve the sqlplus connection error ORA-09925". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.