怎么查看oracle的alert_SID.log

晕倒，你用securecrt远程连接后，切换到oracle用户，然后sqlplus连接上oracle，执行那个命令，然后返回的结果就是bdump的目录，或者直接用root用户，执行find / -d -name 'bdump'

返回出bdump的目录，或者find / -name 'alert_SIDlog',这里的sid是你数据库的实例名

查看alert中的内容

SQL> select from alert where rownum<20;

LOG

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

Wed Feb 27 11:05:11 2013

Starting ORACLE instance (normal)

Cannot determine all dependent dynamic libraries for /proc/self/exe

Unable to find dynamic library libocr10so in search paths

RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:

LD_LIBRARY_PATH is not set!

The default library directories are /lib and /usr/lib

Unable to find dynamic library libocrb10so in search paths

Unable to find dynamic library libocrutl10so in search paths

Unable to find dynamic library libocrutl10so in search paths

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/oracle/product/1020/db_1/dbs/arch

Autotune of undo retention is turned on

IMODE=BR

ILAT =10

LICENSE_MAX_USERS = 0

SYS auditing is disabled

19 rows selected

SQL>

以上就是关于怎么查看oracle的alert_SID.log全部的内容，包括:怎么查看oracle的alert_SID.log、如何查看数据库alert日志文件、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！