AIX 未开启AIO引起SQLPLUS登陆报错exec(): 0509-036
来源:互联网 发布:soc软件品牌 编辑:程序博客网 时间:2024/06/05 10:25
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>
0 0
- AIX 未开启AIO引起SQLPLUS登陆报错exec(): 0509-036
- aix 系统 6.1 smitty aio 报错
- sqlplus 登陆报协议适配器错误
- sqlplus登陆报ora-12560错误
- oracle运维之--aio引起sqlplus / as sysdba不能用
- 【Android】手机连接豌豆夹USB未开启报错
- sqlplus报错了
- sqlplus启动报错
- sqlplus报错
- sqlplus 执行报错
- oracle的sqlplus登陆报错:ORA-12560: TNS: 协议适配器错误
- AIX 报错收集
- AIX 应用sqlplus例子
- 在vmware上安装操作系统报错 VT-X未开启错误
- 倍福TwinCAT(贝福Beckhoff)基础教程 松下官方软件开启报错伺服未就绪怎么办
- php开启报错
- 开启autotrace报错
- php开启报错
- 解决svn执行cleanup出现failed–previous operation has not finished; run cleanup if it was interrupted 的错误
- Android地图添加标记和文字【代码片段】
- poj 1511 Invitation Cards(2遍spfa)
- 安卓开发第十二天
- UVA 10194 Football (aka Soccer)
- AIX 未开启AIO引起SQLPLUS登陆报错exec(): 0509-036
- Mysql基本检索数据方法大全
- Openstack magnum 简介
- ubuntu 14.04 降内核版本 -- 原因是 perf 版本与内核版本不配套
- mysql workbench 报 tables could not be fetched.
- moc
- Linux系统装有多个PHP的版本切换问题
- 数据库常用操作
- vim配置