--linux下查看alert日志文件的两种方法:
--方法1:
SQL> show parameter background_dump_dest; NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /home/oracle/admin/ora125/bdump SQL> ho ls /home/oracle/admin/ora125/bdump
alert_ora125.log ora125_lgwr_3527.trc ora125_lgwr_3833.trc ora125_lgwr_3
ora125_lgwr_15114.trc ora125_lgwr_3535.trc ora125_lgwr_3849.trc ora125_lgwr_3
ora125_lgwr_15497.trc ora125_lgwr_3554.trc ora125_lgwr_3860.trc ora125_lgwr_4
ora125_lgwr_3518.trc ora125_lgwr_3574.trc ora125_lgwr_3867.trc ora125_lgwr_4
ora125_lgwr_3521.trc ora125_lgwr_3668.trc ora125_lgwr_3888.trc ora125_lgwr_4
ora125_lgwr_3523.trc ora125_lgwr_3677.trc ora125_lgwr_3906.trc ora125_lgwr_4 或: ls /home/oracle/admin/ora125/bdump 使用: cat alert_ora125.log 或 vi alert_ora125.log 进行查看 --方法2:
oracle@suse11:~> find -name "alert_ora125.log"
./admin/ora125/bdump/alert_ora125.log --将目前目录及其子目录下 oracle@suse11:~> cd admin/ora125/bdump
oracle@suse11:~/admin/ora125/bdump> 使用: cat alert_ora125.log 或 vi alert_ora125.log 进行查看 linux命令解释:
将目前目录及其子目录下所有延伸档名是 c 的档案列出来
# find . -name "*.c"