如何查看ORACLE日志和日志位置

1、查看操作系统版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle 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