How to find the oracle log file path
- angryTomOriginal
- 2020-02-29 10:46:1410989browse
How to find the path of the oracle log file
1. By default, the oracle log file is recorded in the $ORACLE/rdbms/log directory
[oracle@oracle log]$ pwd /home/oracle/oracle/product/11.2.0/db_1/rdbms/log
The log file is (alert_6a43a68debf05a68961b60e0f0fbc463.log):
[oracle@oracle log]$ ll 总计 848 -rw-rw-r-- 1 aaa aaa 962 06-20 15:57 alert_TESTDB.log
2. If it is not in the default location, you can query the log file location through sql:
SQL> show parameter dump_dest NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ background_dump_dest string /home/oracle/oracle/admin/TESTDB/bdump core_dump_dest string /home/oracle/oracle/admin/TESTDB/cdump user_dump_dest string /home/oracle/oracle/admin/TESTDB/udump
The value of background_dump_dest is the storage location of the log file
PHP Chinese website, a large number of mysql introductory videos tutorials, welcome to learn!
The above is the detailed content of How to find the oracle log file path. For more information, please follow other related articles on the PHP Chinese website!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Which is the best PHP training school in Shanghai?Next article：Which is the best PHP training school in Shanghai?