oracle營運之–aio引起sqlplus / as sysdba不能用

aio引起sqlplus / as sysdba不能用2008-04-23 11:40不單單是：“aio引起sqlplus / as sysdba不能用”

i2的系統，使用者自己維護的
OS:AIX 5.3
Oracle: 10.2

詢問並檢查了一下情況：

1. 重裝了作業系統，Oracle軟體和資料檔案在另外的VG中。
2. 環境變數恢複到重裝系統之前的狀態，Oracle使用者和組也已經建立(UID,GID都與原來相同)，檔案的許可權也都沒有改變。
3. 當sqlplus / as sysdba的時候報錯：

[qasmdm1:oracle] /oracle/home>> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Apr 23 10:34:49 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Could not load program oracledevmdm:
Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
        Symbol kaio_rdwr64 (number 1) is not exported from dependent
          module /unix.
        Symbol listio64 (number 2) is not exported from dependent
          module /unix.
        Symbol acancel64 (number 3) is not exported from dependent
          module /unix.
        Symbol iosuspend64 (number 4) is not exported from dependent
          module /unix.
        Symbol aio_nwait (number 5) is not exported from dependent
          module /unix.
        Symbol aio_nwait64 (number 6) is not exported from dependent
          module /unix.
        Symbol aio_nwait_timeout (number 7) is not exported from dependent
          module /unix.
        Symbol aio_nwait_timeout64 (number 8) is not exported from dependent
          module /unix.
System error: Error 0
Examine .loader section symbols with the 'dump -Tv' command.
ERROR:
ORA-12547: TNS:lost contact

metalink查了一下,說是aio的問題。檢查了一下AIO

PEKAX131:/dev>smit aio
                        Change/Show Characteristics of Asynchronous I/O

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

                                                        [Entry Fields]
MINIMUM number of servers                          [1]                                                                          #
MAXIMUM number of servers per cpu                  [15]                                                                         #
maximum number of REQUESTS                         [4096]                                                                       #
server PRIORITY                                    [39]                                                                         #
STATE to be configured at system restart            defined                                                                    +
State of fast path                                  enable  

確實沒有自動啟動，執行下面的操作啟動AIO:

PEKAX131:/>mkdev -l aio0
aio0 Available

並且smit aio 把STATE to be configured at system restart 修改為available

再sqlplus串連並啟動庫都沒有問題了

[qasmdm1:oracle] /oracle/home> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Apr 23 11:20:24 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup

經詢問，知道了原因：
使用者原來做過mksysb（AIX備份作業系統的命令方式）
出問題是在前一天晚上作業系統問題之後恢複了mksysb,而aix恢複完之後並沒有啟用aio.

正常情況，aix安裝oracle之前執行rootpre