如何查看数据库alert日志文件 |
您所在的位置:网站首页 › Oracle查看日志路径 › 如何查看数据库alert日志文件 |
文章来自:脚本之家 本文将详细介绍下查看操作系统版本/查看预警日志文件(alert_sid.log)的位置/查看alert中的内容/看看数据库有哪些 可爱的ORA- 错误吧等等,感兴趣的你可以参考下 1、查看操作系统版本 SQL> select * from v$version; BANNEROracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for Linux: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production SQL> 2、查看预警日志文件(alert_sid.log)的位置 SQL> show parameter dump NAME TYPE VALUE background_core_dump string partial background_dump_dest string /u01/oracle/admin/bdump core_dump_dest string /u01/oracle/admin/cdump max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string /u01/oracle/admin/udump 3、创建目录alert 注意:directory不是实体,只是一个指向,指向os中一个路径 SQL> create or replace directory alert as ‘/u01/oracle/admin/bdump’; Directory created. SQL> 4、创建外部表alert SQL> create table alert 1 (log varchar2(1000)) 2 organization external 3 (type oracle_loader 4 default directory alert 5 access parameters 6 (records delimited by newline) 7 location (‘alert_PROD.log’)) 8 reject limit unlimited; Table created. 5、查看alert中的内容 SQL> select * from alert where rownum 6、看看数据库有哪些 可爱的ORA- 错误吧 SQL> select * from alert where log like ‘%ORA-%’; LOGORA-959 signalled during: alter database default tablespace users… ORA-959 signalled during: drop tablespace uses… ORA-12919 signalled during: drop tablespace users… ORA-1549 signalled during: drop tablespace users… ORA-1505 signalled during: alter database add logfile group 1 ORA-1184 signalled during: alter database add logfile group 1 ORA-1013 signalled during: alter tablespace tts read only… ORA-1013 signalled during: alter tablespace tts read only… ORA-1013 signalled during: alter tablespace users read only… ORA-1539 signalled during: alter tablespace users read only… |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |