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>
相關文章
- aix系統資料庫sqlplus登陸報錯處理一例AI資料庫SQL
- 登陸sqlplus hang /telnet很慢 for AixSQLAI
- oracle在AIX系統上通過tar包安裝,sqlplus報aio錯誤OracleAISQL
- sqlplus登陸方式SQL
- sqlplus 啟動報錯SQL
- sqlplus登陸資訊提示SQL
- windows 下用 as sysdba登陸報錯Windows
- Oracle RAC啟動CRS報錯:登陸許可權問題Oracle
- Oracle所有者不是dba 引起sqlplus / as sysdba 登入報錯ORA-01031OracleSQL
- 利用jnbSA啟動netbackup圖形介面報錯無法登陸
- mysql登陸報錯mysql: unknown variable 'basedir=MySql
- sqlplus / as sysdba無法登入的奇怪報錯SQL
- aix 遠端登陸緩慢問題AI
- Docker容器學習梳理 - 容器登陸方法梳理(attach、exec、nsenter)Docker
- 密碼過期引起的ssh無法登陸密碼
- ORACLE_HOME設定錯誤導致本地sqlplus無法登陸OracleSQL
- sqlplus"strace: exec: Exec format error"故障處理SQLORMError
- sqlplus本地登入報錯ORA-12545SQL
- mysql密碼遺忘和登陸報錯問題MySql密碼
- 10g Sqlplus工具登陸小改進SQL
- AIX aio與listener 的關係AI
- 開啟SUSE Linux的SSH密碼登陸Linux密碼
- MySQL服務開啟關閉及登陸- 2MySql
- 新搭建的mysql登陸報錯mysql Segmentation fault (core dumped)MySqlSegmentation
- 自定義容器啟動指令碼報錯:exec user process caused "no such file or directory"指令碼
- 登陸sqlplus出現問號的問題SQL
- aix6 AIO 動態調整AI
- [BUG反饋]onethink 登陸時呼叫$User = new UserApi; 報錯。API
- cacti登陸出現報錯:資料庫無法連線資料庫
- aix平臺執行sqlplus報:0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o]AISQLSymbol
- sqlplus登陸環境設定(glogin.sql)SQL
- xmanager登陸AIX遠端桌面故障解決-大全版AI
- 帝國cms登陸錯誤次數 帝國cms登陸錯誤次數超過
- 配置OGG到MYSQL複製時登陸MYSQL報錯解決MySql
- aix 開啟 sshAI
- 登入學習通報錯:瀏覽器沒有開啟cookie功能瀏覽器Cookie
- 11g啟動sqlplus報錯沒有許可權SQL
- InfoPackage無法開啟 報錯Package