linux How to query oracle Error log

This article introduces in detail “linux How to query oracle Error log ”, Detailed content , The steps are clear , The details are handled properly , Hope this article “linux How to query oracle Error log ” The article can help you solve your doubts , Let's follow Xiaobian's ideas and go deeper slowly , Let's learn new knowledge together .

linux Inquire about oracle Error logging method ：1、 utilize “show parameter background_dump_dest” Command to get the directory of the error log , Query the error log through the directory ;2、 Using error prompts PID To fuzzy query the corresponding error log , The grammar is “find -name "*ora* Error prompt PID*.trc"”.

The operating environment of this tutorial ：linux7.3 System 、Dell G3 The computer .

linux Inquire about oracle Error log

1 View the error log directory through the command ：

show parameter background_dump_dest　　/usr/oracle/app/diag/rdbms/orcl/orcl/trace

2 According to the error prompt PID:3159 Fuzzy query the corresponding error log

　　find -name "*ora*3159*.trc"　　more orcl_ora_3159.trc

Expanding knowledge ：

Query archive log

　　select * from v$recovery_file_dest;

　　 Delete archive log

Warning log

　　 Query the full name of the warning log ：find -name "alert*.log"

　　 Check the contents of the warning log

Read here , This article “linux How to query oracle Error log ” The article has been introduced , If you want to master the knowledge points of this article, you need to practice and use it yourself to understand , If you want to know more about this article , Welcome to the Yisu cloud industry information channel .