Oracle sqlplus failed on AIX platform(/usr/lib/lib

简介: Oracle sqlplus failed on AIX platform(/usr/lib/lib

Oracle executables fail to run on AIX: Symbol resolution failed for /usr/lib/libc.a[aio_64.o]

  • Note:235537.1
  • fact: Oracle Server - Enterprise Edition 9.2.0.1
  • fact: AIX-Based Systems
  • symptom: Starting SQL*Plus error
  • symptom: exec(): 0509-036 Cannot load program oracleads1 because of the following errors:
  • symptom: 0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
  • symptom: 0509-136 Symbol kaio_rdwr64 (number 0) is not exported from dependent module /unix.
  • symptom: 0509-136 Symbol listio64 (number 1) is not exported from dependent module /unix.
  • symptom: 0509-136 Symbol acancel64 (number 2) is not exported from dependent module /unix.
  • symptom: 0509-136 Symbol iosuspend64 (number 3) is not exported from dependent module /unix.
  • symptom: 0509-136 Symbol aio_nwait (number 4) is not exported from dependent module /unix.
  • symptom: 0509-136 Symbol aio_nwait64 (number 5) is not exported from dependent module /unix.
  • symptom: 0509-136 Symbol aio_nwait_timeout (number 6) is not exported from dependent module /unix.
  • symptom: 0509-136 Symbol aio_nwait_timeout64 (number 7) is not exported from dependent module /unix.
  • symptom: 0509-026 System error: Error 0
  • symptom: 0509-192 Examine .loader section symbols with the 'dump -Tv' command.
  • symptom: Dependent module libc.a(aio_64.o) could not be loaded
  • change: Filesystem mode changed from JFS2 to JFS
  • cause: Asynchronous I/O has not been configured or started on the system.

fix: Make Asynchronous I/O available on system, following the next steps to set it up: 1. Log in as root 2. Type: mkdev -l aio0 This command attempts to verify that Asynchronous I/O services are running (available on system), if not, they are started. 3. To ensure it is configured at each system restart : a. Type: smit aio b. Select the menu item "Change/Show Characteristics of Asynchronous I/O" c. Change the field "STATE to be configured at system restart" from DEFINED to AVAILABLE. or just execute the next command and it will do the same as the previous a, b and c steps: chdev -l aio0 -a autoconfig='available' which should return the message "aio0 changed". Step 3 (either of the two ways) will toggle the state to be configured at system restart to be available, making asynchronous I/O available with each system reboot.

相关文章
|
5天前
|
SQL Oracle 关系型数据库
[已解决]使用sqlplus连接oracle,提示ORA-01034和ORA-27101
[已解决]使用sqlplus连接oracle,提示ORA-01034和ORA-27101
57 0
|
5天前
|
Oracle 关系型数据库
【Oracle】sqlplus 复制数据文件时出现拒绝访问
【Oracle】sqlplus 复制数据文件时出现拒绝访问
|
7月前
|
SQL Oracle 关系型数据库
Oracle数据库sqlplus命令行执行sql语句时,语句有中文报错解决
Oracle数据库sqlplus命令行执行sql语句时,语句有中文报错解决
|
7月前
|
SQL Oracle 关系型数据库
导出Oracle数据库sqlplus命令行查询的结果到文件
导出Oracle数据库sqlplus命令行查询的结果到文件
142 0
|
12月前
|
Oracle 关系型数据库
|
SQL Oracle 关系型数据库
oracle用SQL Plus输入命令为什么只显示2
oracle用SQL Plus输入命令为什么只显示2
475 0
oracle用SQL Plus输入命令为什么只显示2
|
Oracle 关系型数据库 数据库
Oracle的服务器端和客户端同时安装Sqlplus无法登陆的处理
Oracle的服务器端和客户端同时安装Sqlplus无法登陆的处理
153 0
Oracle的服务器端和客户端同时安装Sqlplus无法登陆的处理
|
SQL Oracle 关系型数据库
Oracle SQL Plus使用说明
本文目录 1. 简介 2. SQL Plus的登录和退出 3. SQL Plus查询命令
240 0
Oracle SQL Plus使用说明
|
SQL Oracle 关系型数据库
Oracle SQLcl - 替代 sqlplus 的利器
对于从事 Oracle 技术开发的同学,肯定都要连接 Oracle 数据库,而 Oracle 自带的 sqlplus 命令行工具功能太弱了,不支持命令联想、数据显示不美观,还要安装什么 Oracle Client,导致很多同学不得不用其他工具(PL/SQL Developer、Oracle SQL Developer)来连接数据库。
5276 0