1.Oracle叢集日誌的檔案路徑
Oracle叢集涉及的日誌主要位於“$GRID_HOME/log”和“$ORACLE_HOME/log”目錄中。
2.日誌目錄結構
clusterware 層的日誌結構：
grid@rac1:/home/grid>tree -d $ORACLE_HOME/log
/opt/rac/11.2.0/grid/log
|-- crs
|-- diag
| `-- clients
| `-- user_root
| `-- host_1874443374_76
| |-- alert
| |-- cdump
| |-- incident
| |-- incpkg
| |-- lck
| |-- metadata
| |-- stage
| |-- sweep
| `-- trace
`-- rac1
|-- admin
|-- agent
| |-- crsd
| | |-- oraagent_grid
| | |-- oraagent_oracle
| | `-- orarootagent_root
| `-- ohasd
| |-- oraagent_grid
| |-- oracssdagent_root
| |-- oracssdmonitor_root
| `-- orarootagent_root
|-- client
|-- crsd
|-- cssd
|-- ctssd
|-- diskmon
|-- evmd
|-- gipcd
|-- gnsd
|-- gpnpd
|-- mdnsd
|-- ohasd
|-- racg
| |-- racgeut
| |-- racgevtf
| `-- racgmain
`-- srvm
42 directories
RMDBS 層的日誌結構：
oracle@rac1:/opt/rac/oracle/diag/rdbms/rac>tree -d rac1
rac1
|-- alert
|-- cdump
|-- hm
|-- incident
|-- incpkg
|-- ir
|-- lck
|-- metadata
|-- stage
|-- sweep
`-- trace
11 directories
其中“rac1”是主機名。
3.日誌目錄功能說明
1）CRS日誌存放在“$GRID_HOME/log/<hostname>/crsd”目錄，系統會對該日誌每10M進行歸檔一次；
2）CSS日誌存放在“$GRID_HOME/log/<hostname>/cssd”目錄，系統會對該日誌每20M進行歸檔一次；
3）EVM日誌存放在“$GRID_HOME/log/<hostname>/evmd”目錄；
4）“$GRID_HOME/log/<hostname>”和“$ORACLE_HOME/log/<hostname>”目錄中的racg目錄中記錄了RACG可執行檔案對應的日誌；
5）“$GRID_HOME/log/<hostname>/client”和“$ORACLE_HOME/log/<hostname>/client”目錄記錄了與srvctl、ocrdump、ocrconfig以及ocrcheck命令對應的日誌資訊。
4.Oracle叢集的alert日誌
Oracle RAC環境中的alert日誌檔案與Oracle單例項的alert日誌一樣。該檔案位於“在 $ORACLE_BASE/rdbms/<hostname>/trace”目錄下，命名規則為“alert_<nodename>.log”
該警告日誌記錄了有關Oracle叢集rdbms 層面的重要警告資訊。
oracle@rac1:/opt/rac/oracle/diag/rdbms/rac/rac1/trace>more alert_rac1.log
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
Using parameter settings in client-side pfile /opt/rac/oracle/admin/rac/pfile/init.ora on machine rac1
System parameters with non-default values:
processes = 150
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 1584M
control_files = "+DATA2/rac/controlfile/current.260.781821965"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=+DATA2"
log_archive_format = "yangdb_%t_%s_%r.dbf"
db_create_file_dest = "+DATA2"
undo_tablespace = "UNDOTBS1"
instance_number = 1
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=racXDB)"
remote_listener = "scan:1521"
audit_file_dest = "/opt/rac/oracle/admin/rac/adump"
audit_trail = "DB"
db_name = "rac"
open_cursors = 300
diagnostic_dest = "/opt/rac/oracle"
Cluster communication is configured to use the following interface(s) for this instance
10.10.10.10
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sat Apr 28 20:50:38 2012
PMON started with pid=2, OS id=16042
VKTM started with pid=3, OS id=16044 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Sat Apr 28 20:50:39 2012
GEN0 started with pid=4, OS id=16048
DIAG started with pid=5, OS id=16050
DBRM started with pid=6, OS id=16052
5.小結
熟悉Oracle叢集環境下日誌檔案的位置和功能有助於快速定位故障的位置，善用之。
ORA-29780: unable to connect GPnP daemon [CLSGPNP_ERR]
安裝完成 11GR2 Grid 之後，使用asmca建立磁碟組的時候遇到如下報錯：
Started getting following error
ORA-29780: unable to connect to GPnP daemon [CLSGPNP_ERR]
google 一把 和環境變數有關：(CRS/GRID 是執行正常的).
grid@rac1 /oragrid/dbs> env | grep ORA
GRID_HOME=/opt/11.2.0/grid <====== 從老的bash_profle 中繼承的！
ORACLE_SID=+ASM1
ORACLE_BASE=/opt/rac/grid
ORACLE_HOME=/opt/rac/11.2.0/grid
$GRID_HOME變數必須和$ORACLE_HOME 保持一致,否則在使用asmca建立磁碟的時候 會認不到asm 磁碟!
1.Oracle叢集日誌的檔案路徑
Oracle叢集涉及的日誌主要位於“$GRID_HOME/log”和“$ORACLE_HOME/log”目錄中。
2.日誌目錄結構
clusterware 層的日誌結構：
grid@rac1:/home/grid>tree -d $ORACLE_HOME/log
/opt/rac/11.2.0/grid/log
|-- crs
|-- diag
| `-- clients
| `-- user_root
| `-- host_1874443374_76
| |-- alert
| |-- cdump
| |-- incident
| |-- incpkg
| |-- lck
| |-- metadata
| |-- stage
| |-- sweep
| `-- trace
`-- rac1
|-- admin
|-- agent
| |-- crsd
| | |-- oraagent_grid
| | |-- oraagent_oracle
| | `-- orarootagent_root
| `-- ohasd
| |-- oraagent_grid
| |-- oracssdagent_root
| |-- oracssdmonitor_root
| `-- orarootagent_root
|-- client
|-- crsd
|-- cssd
|-- ctssd
|-- diskmon
|-- evmd
|-- gipcd
|-- gnsd
|-- gpnpd
|-- mdnsd
|-- ohasd
|-- racg
| |-- racgeut
| |-- racgevtf
| `-- racgmain
`-- srvm
42 directories
RMDBS 層的日誌結構：
oracle@rac1:/opt/rac/oracle/diag/rdbms/rac>tree -d rac1
rac1
|-- alert
|-- cdump
|-- hm
|-- incident
|-- incpkg
|-- ir
|-- lck
|-- metadata
|-- stage
|-- sweep
`-- trace
11 directories
其中“rac1”是主機名。
3.日誌目錄功能說明
1）CRS日誌存放在“$GRID_HOME/log/<hostname>/crsd”目錄，系統會對該日誌每10M進行歸檔一次；
2）CSS日誌存放在“$GRID_HOME/log/<hostname>/cssd”目錄，系統會對該日誌每20M進行歸檔一次；
3）EVM日誌存放在“$GRID_HOME/log/<hostname>/evmd”目錄；
4）“$GRID_HOME/log/<hostname>”和“$ORACLE_HOME/log/<hostname>”目錄中的racg目錄中記錄了RACG可執行檔案對應的日誌；
5）“$GRID_HOME/log/<hostname>/client”和“$ORACLE_HOME/log/<hostname>/client”目錄記錄了與srvctl、ocrdump、ocrconfig以及ocrcheck命令對應的日誌資訊。
4.Oracle叢集的alert日誌
Oracle RAC環境中的alert日誌檔案與Oracle單例項的alert日誌一樣。該檔案位於“在 $ORACLE_BASE/rdbms/<hostname>/trace”目錄下，命名規則為“alert_<nodename>.log”
該警告日誌記錄了有關Oracle叢集rdbms 層面的重要警告資訊。
oracle@rac1:/opt/rac/oracle/diag/rdbms/rac/rac1/trace>more alert_rac1.log
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
Using parameter settings in client-side pfile /opt/rac/oracle/admin/rac/pfile/init.ora on machine rac1
System parameters with non-default values:
processes = 150
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 1584M
control_files = "+DATA2/rac/controlfile/current.260.781821965"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=+DATA2"
log_archive_format = "yangdb_%t_%s_%r.dbf"
db_create_file_dest = "+DATA2"
undo_tablespace = "UNDOTBS1"
instance_number = 1
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=racXDB)"
remote_listener = "scan:1521"
audit_file_dest = "/opt/rac/oracle/admin/rac/adump"
audit_trail = "DB"
db_name = "rac"
open_cursors = 300
diagnostic_dest = "/opt/rac/oracle"
Cluster communication is configured to use the following interface(s) for this instance
10.10.10.10
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sat Apr 28 20:50:38 2012
PMON started with pid=2, OS id=16042
Sat Apr 28 20:50:38 2012
VKTM started with pid=3, OS id=16044 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Sat Apr 28 20:50:39 2012
GEN0 started with pid=4, OS id=16048
Sat Apr 28 20:50:39 2012
DIAG started with pid=5, OS id=16050
Sat Apr 28 20:50:39 2012
DBRM started with pid=6, OS id=16052
5.小結
熟悉Oracle叢集環境下日誌檔案的位置和功能有助於快速定位故障的位置，善用之。
ORA-29780: unable to connect GPnP daemon [CLSGPNP_ERR]
安裝完成 11GR2 Grid 之後，使用asmca建立磁碟組的時候遇到如下報錯：
Started getting following error
ORA-29780: unable to connect to GPnP daemon [CLSGPNP_ERR]
google 一把 和環境變數有關：(CRS/GRID 是執行正常的).
grid@rac1 /oragrid/dbs> env | grep ORA
GRID_HOME=/opt/11.2.0/grid <====== 從老的bash_profle 中繼承的！
ORACLE_SID=+ASM1
ORACLE_BASE=/opt/rac/grid
ORACLE_HOME=/opt/rac/11.2.0/grid
$GRID_HOME變數必須和$ORACLE_HOME 保持一致,否則在使用asmca建立磁碟的時候 會認不到asm 磁碟!