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

This article mainly shows you "how to do ORA-09817 error in oracle", the content is simple and easy to understand, clear organization, I hope to help you solve doubts, let Xiaobian lead you to study and learn "how to do ORA-09817 error in oracle" this article.

The following error occurred when using oracle database to connect database with sysdba

ORA-09817 error occurred when connecting Oracle:

# sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 17 16:35:02 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:

ORA-09817: Write to audit file failed.

Enter user-name:

1. Enter df -lh on the command line to check disk space. If you find that disk space is full, go to step 2.

2. SELECT VALUE FROM V$PARAMETER WHERE NAME = 'user_dump_dest'//find path to trace folder

Note: This command needs to be logged in to find it. My path is/usr/u01/app/diag/rdbms/orcl/orcl/trace, which is available for reference.

3. The command line goes one level above the trace folder and deletes some trace files to make room. Oracle's tarce file is a log generated by Oracle database during runtime. The trace file can be deleted and has no impact on the system. For example, look at trace files 30 days ago: find trace -ctime +30| more

Delete trace files older than 30 days: find trace -ctime +30| xargs rm -f

After completing the above, you can free up part of the space.

4. Try shutting down the database (log in to oracle database and run shutdown immediate) before restarting the computer. If the normal database shutdown fails, shut down the computer directly.

5. Restart oracle database

Switch to root and enter the following commands. The database service starts successfully.

lsnrctl start

Ordinary users

sqlplus / as sysdba

After logging in,

startup

The above is "oracle ORA-09817 error how to do" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

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.