Oracle 實例啟動參數檔案解析 (2/2)：預設路徑與警示日誌分析

預設路徑查詢

SQL> SHOW PARAMETER dump_dest;
NAME                 TYPE   VALUE
background_dump_dest string ?/rdbms/log
core_dump_dest       string ?/dbs
user_dump_dest       string ?/rdbms/log

SQL> SHOW PARAMETER control_files;
NAME           TYPE   VALUE
control_files  string ?/dbs/cntrl@.dbf

警示日誌內容

Mon May 8 11:09:04 2006
Starting Oracle instance (normal)
WARNING: EINVAL creating segment of size 0x0000000006400000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up Oracle RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  db_name = julia
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7

日誌記錄背景進程啟動順序與非預設參數，是排查啟動問題的重要依據。