導讀:1建站知識本文將詳細介紹下查看操作系統版本/查看預警日志文件（alert_sid.log）的位置/查看alert中的內容/看看數據庫有哪些 可高端網站建設網站seo優化。

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 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<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 libocr10.so 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 libocrb10.so in search paths Unable to find dynamic library libocrutl10.so in search paths Unable to find dynamic library libocrutl10.so 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/10.2.0/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> 6、看看數據庫有哪些 可愛的ORA- 錯誤吧 SQL> select * from alert where log like '%ORA-%'; LOG ------------------------------------------------------------------------------------------------------------------------------------------------------------------seo網站優化培訓-----------企業網站建設--------------------------- ORA-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 gr建設網站oup 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...相關高端網站建設網站seo優化。

關鍵詞標簽: 標簽 數據庫