# HP-UX安裝Oracle 11.2.0.3單機執行任何命令均報錯Memory Fault(coredump)分析解決
## 1. 故障現象
> 順利無報錯安裝Oracle軟體之後，執行netca、dbca等任何Oracle相關命令均報錯Memory fault(coredump)
```shell
$ sqlplus / as sysdba
Memory fault(coredump)

$ expdp
Memory fault(coredump)

$ rman target /
Memory fault(coredump)

```
## 2. 分析
### 2.1 檢查引數
檢查作業系統引數以及ulimit限制，發現該報錯與引數與ulimit無關。

### 2.2 更換Oracle版本
透過安裝11.2.0.4版本，報錯依舊，依然是可以正常安裝軟體，執行命令報相同錯誤。

### 2.3 tusc追蹤
```shell
tusc -Dfaepo /tmp/sqlplus.out -T %T sqlplus / as sysdba
# 節選部分關鍵內容
# 在判斷當前時間以及訪問時區檔案之後就開始mmap分配記憶體
gettimeofday(0x9fffffffffffc6b0, NULL) ....................................................... = 0
stat("/usr/lib/tztab", 0x9fffffffffffc5d0) ................................................... = 0
open("/usr/lib/tztab", O_RDONLY|0x800, 01210) ................................................ = 9
mmap(NULL, 18261, PROT_READ, MAP_PRIVATE, 9, 0) .............................................. = 0x9fffffff7f568000
close(9) ..................................................................................... = 0
gettimeofday(0x9fffffffffffc6b0, NULL) ....................................................... = 0
gettimeofday(0x9fffffffffffc580, NULL) ....................................................... = 0
lseek(8, 1536, SEEK_SET) ..................................................................... = 1536
read(8, "\0\bbb81\0\0\08 bb82\0\0\086bb83".., 512) ........................................... = 512
mmap(NULL, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) .................... = 0x9fffffff7f564000
open("/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1", O_RDONLY|0x800, 0163060) = 9
# 分配記憶體
mmap(NULL, 8192, PROT_READ, MAP_PRIVATE, 9, 121794560) ....................................... = 0x9fffffff7f562000
# mmap分配之後其實檢測訊號掩碼之後就開始取消分配記憶體munmap
sigprocmask(SIG_SETMASK, 0x9ffffffffffd2560, 0x9ffffffffffd2580) ............................. = 0
sigprocmask(SIG_SETMASK, 0x9ffffffffffd2510, 0x9ffffffffffd2530) ............................. = 0
sigprocmask(SIG_SETMASK, 0x9ffffffffffd2530, 0x9ffffffffffd2510) ............................. = 0
sigsetreturn(NULL, 0x6211988, 48640) ......................................................... = 0
sigprocmask(SIG_SETMASK, 0x9ffffffffffd2510, 0x9ffffffffffd2530) ............................. = 0
sigprocmask(SIG_SETMASK, 0x9ffffffffffd2530, 0x9ffffffffffd2510) ............................. = 0
sigaction(SIGBUS, NULL, 0x9fffffff7f7d42b0) .................................................. = 0
# 省略相似輸出
sigaction(SIGSEGV, 0x9fffffff7f7d42e0, NULL) ................................................. = 0
sigprocmask(SIG_SETMASK, 0x9ffffffffffd2810, NULL) ........................................... = 0
munmap(0x9fffffff7f330000, 28672) ............................................................ = 0
munmap(0x9fffffff7f338000, 36864) ............................................................ = 0
munmap(0x9fffffff7f344000, 8192) ............................................................. = 0
close(12) .................................................................................... = 0
munmap(0x9fffffff7f346000, 8192) ............................................................. = 0
munmap(0x9fffffff7f560000, 8192) ............................................................. = 0
close(11) .................................................................................... = 0
munmap(0x9fffffff7f348000, 16384) ............................................................ = 0
munmap(0x9fffffff7f34c000, 49152) ............................................................ = 0
munmap(0x9fffffff7f567000, 4096) ............................................................. = 0
close(10) .................................................................................... = 0
munmap(0x9fffffff7f358000, 733184) ........................................................... = 0
munmap(0x9fffffff7f40c000, 1388544) .......................................................... = 0
munmap(0x9fffffff7f562000, 8192) ............................................................. = 0
close(9) ..................................................................................... = 0
  Received signal 11, SIGSEGV, in user mode, [SIG_DFL], partial siginfo
    Siginfo: si_code: SEGV_ACCERR, faulting address: 0x1, si_errno: 0
     PC: 00000001000000a0.0	     	break.m 0x16000 
exit(11) [implicit] .......................................................................... WIFSIGNALED(SIGSEGV)|WCOREDUMP

# 從上面可以看出，在判斷了當前系統時間之後，就開始分配記憶體，之後就取消分配記憶體，之後就報錯了，生成了core檔案。 
```
## 3. 解決
分析到2.3，去檢查了一下系統時間，基本就已經確定問題了，系統當前時間不正確，使用date命令確認一下如下：
```shell
# date
Thu Jul   2 11:21:05 MDT 1970

# 修改系統時間為正確時間，問題解決。
```

HP-UX執行Oracle相關命令報錯Memory fault(coredump)分析處理

相關文章