AIX 未開啟AIO引起SQLPLUS登陸報錯exec(): 0509-036
AIX Version 5.3
Oracle8i Enterprise Edition Release 8.1.7.4.0
*******
oracle@AAAAA:/u01>sqlplus '/ as sysdba'
exec(): 0509-036 Cannot load program sqlplus because of the following errors:
0509-130 Symbol resolution failed for /usr/lib/libc.a(aio.o) because:
0509-136 Symbol kaio_rdwr (number 1) is not exported from
dependent module /unix.
0509-136 Symbol listio (number 2) is not exported from
dependent module /unix.
0509-136 Symbol acancel (number 3) is not exported from
dependent module /unix.
0509-136 Symbol iosuspend (number 4) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait (number 5) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait64 (number 6) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait_timeout (number 7) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait_timeout64 (number 8) is not exported from
dependent module /unix.
0509-026 System error: Error 0
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
檢視非同步IO設定:
AAAAA:/# lslpp -l bos.rte.aio
Fileset Level State Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
bos.rte.aio 5.3.7.3 APPLIED Asynchronous I/O Extension
Path: /etc/objrepos
bos.rte.aio 5.3.7.0 COMMITTED Asynchronous I/O Extension
AAAAA:/# lsattr -El aio0
autoconfig defined STATE to be configured at system restart True
fastpath enable State of fast path True
kprocprio 39 Server PRIORITY True
maxreqs 4096 Maximum number of REQUESTS True
maxservers 10 MAXIMUM number of servers per cpu True
minservers 1 MINIMUM number of servers True
重啟主機:
AAAAAt:/# shutdown -Fr
重啟後正常:
oracle@AAAAA.prod:/oracle>sqlplus '/ as sysdba'
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 30 16:08:23 2015
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL>
Oracle8i Enterprise Edition Release 8.1.7.4.0
新接手一個環境,主機是從其它小機恢復來的,遇到一些問題,記錄一下。
*******
oracle@AAAAA:/u01>sqlplus '/ as sysdba'
exec(): 0509-036 Cannot load program sqlplus because of the following errors:
0509-130 Symbol resolution failed for /usr/lib/libc.a(aio.o) because:
0509-136 Symbol kaio_rdwr (number 1) is not exported from
dependent module /unix.
0509-136 Symbol listio (number 2) is not exported from
dependent module /unix.
0509-136 Symbol acancel (number 3) is not exported from
dependent module /unix.
0509-136 Symbol iosuspend (number 4) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait (number 5) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait64 (number 6) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait_timeout (number 7) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait_timeout64 (number 8) is not exported from
dependent module /unix.
0509-026 System error: Error 0
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
檢視非同步IO設定:
AAAAA:/# lslpp -l bos.rte.aio
Fileset Level State Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
bos.rte.aio 5.3.7.3 APPLIED Asynchronous I/O Extension
Path: /etc/objrepos
bos.rte.aio 5.3.7.0 COMMITTED Asynchronous I/O Extension
AAAAA:/# lsattr -El aio0
autoconfig defined STATE to be configured at system restart True
fastpath enable State of fast path True
kprocprio 39 Server PRIORITY True
maxreqs 4096 Maximum number of REQUESTS True
maxservers 10 MAXIMUM number of servers per cpu True
minservers 1 MINIMUM number of servers True
------------------
改變AIO設定:
AAAAA:/# chdev -P -l aio0 -a autoconfig='available'重啟主機:
AAAAAt:/# shutdown -Fr
重啟後正常:
oracle@AAAAA.prod:/oracle>sqlplus '/ as sysdba'
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 30 16:08:23 2015
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL>
相關文章
- sqlplus登入資料庫報錯ORA-12547: TNS:lost contactSQL資料庫
- 密碼過期引起的ssh無法登陸密碼
- sqlplus as sysdb登入報ora-01017SQL
- strace解決sqlplus登陸緩慢的問題一例SQL
- 硬碟開機報錯是什麼原因引起的硬碟
- sqlplus執行sql檔案報錯SQL
- [BUG反饋]onethink 登陸時呼叫$User = new UserApi; 報錯。API
- 帝國cms登陸錯誤次數 帝國cms登陸錯誤次數超過
- 思科路由器:開啟telnet和ssh遠端登陸路由器
- tar (child): bzip2: Cannot exec: No such file or directory 報錯
- [重慶思莊每日技術分享]-sqlplus登入資料庫時報錯:ORA-12547SQL資料庫
- 登入學習通報錯:瀏覽器沒有開啟cookie功能瀏覽器Cookie
- SSH安全登陸原理:密碼登陸與公鑰登陸密碼
- 登陸Epic後只賣了9套?《幸福工廠》官推引起熱議
- 前端開發--登陸註冊前端
- 登入harbor報錯
- sqlplus / as sysdba報錯ORA-01017: invalid username/password; logon deniedSQLGo
- windows oracle11g資料庫使用sqlplus登入的時候出現ora-01017報錯WindowsOracle資料庫SQL
- 索尼2020財年報告:未來將讓更多第一方作品登陸PC
- 三層登陸程式碼及錯誤集錦
- discuz教程QQ登陸提示錯誤程式碼:2000
- sqlplus啟動失敗SQL
- 登入BOS開啟開發方案報"缺少根元素"
- DG備庫未啟動SCN 新特性引起ORA-600 2252
- tp登陸
- 共享登陸
- 大型非同步多人遊戲《幻影深淵》登陸Steam,開啟EA版非同步遊戲
- sqlplus常用的幾種登入方式SQL
- [20211108]sqlplus 本地登入緩慢.txtSQL
- 主機安裝zblog 無法登陸:錯誤原因:登入失敗
- Linux配置SSH免密登陸(公私鑰登陸)Linux
- pycharm開啟debug模式報錯彙總PyCharm模式
- 資料檔案Resize引起的ORA-03297報錯
- linux 實現開機自動登陸Linux
- Ubuntu下開啟php除錯模式報錯如何解決UbuntuPHP除錯模式
- ORACLE 審計目錄碎檔案過多ORA09925導致sqlplus無法登陸控制檯OracleSQL
- Sqlserver作業系統使用者Administrator本地登陸SSMS報錯18456的解決方法SQLServer作業系統SSM
- 機房重構七層登陸之錯誤集錦
- 登陸驗證