简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Common Problem > body text

How to find the oracle log file path

angryTom
Release： 2020-02-29 10:46:14
Original
10896 people have browsed it

How to find the oracle log file path

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
Copy after login

The log file is (alert_.log): 

[oracle@oracle log]$ ll  
总计 848  
-rw-rw-r-- 1  aaa  aaa    962 06-20 15:57 alert_TESTDB.log
Copy after login

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
Copy after login

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!

Related labels：
oracle log file path
source：php.cn
Previous article：Which is the best PHP training school in Shanghai? Next article：Where is the best training for PHP development?
Statement of this Website
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
Latest Articles by Author
Latest Issues
Passing PHP variables to SQL query in oci_parse I'm passing PHP variables into an OracleSQL query. But it's not treating it properly and g...
From 2023-11-04 12:38:22
0
1
306
How to solve the problem of "ORA-00922: missing or invalid option" error? I entered the following SQL command in Oracle, but it reported the error "ORA-00922: ...
From 2023-08-22 18:45:24
0
2
270
How to add an image to the HTML body of an email template in Oracle APEX "This is a huge template that I want to exit from the app but can't make, can anyone ...
From 2023-08-01 17:21:36
0
1
291
How to solve the following problems ORA-01589: must use RESETLOGS or NORESETLOGS option for database open. The ORACLE database...
From 2021-04-07 16:53:00
0
0
608
PHP link oracle database configuration Integrated environment: win10+PHP toolbox opens extension: extension=php_oci8_12c.dll exte...
From 2019-03-29 10:28:17
0
3
827
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！