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.

相关文章
|
3月前
|
Oracle 关系型数据库
Navicat 连接Oracle ORA-28547: connection to server failed, probable Oracle Net admin error
Navicat 连接Oracle ORA-28547: connection to server failed, probable Oracle Net admin error
112 0
|
6月前
|
存储 NoSQL 关系型数据库
实时计算 Flink版操作报错之抽取Oracle11g时,报错: "Retrieve schema history failed, the schema records for engine ... has been removed",怎么处理
在使用实时计算Flink版过程中,可能会遇到各种错误,了解这些错误的原因及解决方法对于高效排错至关重要。针对具体问题,查看Flink的日志是关键,它们通常会提供更详细的错误信息和堆栈跟踪,有助于定位问题。此外,Flink社区文档和官方论坛也是寻求帮助的好去处。以下是一些常见的操作报错及其可能的原因与解决策略。
|
6月前
|
SQL Oracle 关系型数据库
[已解决]使用sqlplus连接oracle,提示ORA-01034和ORA-27101
[已解决]使用sqlplus连接oracle,提示ORA-01034和ORA-27101
119 0
|
6月前
|
Oracle 关系型数据库
【Oracle】sqlplus 复制数据文件时出现拒绝访问
【Oracle】sqlplus 复制数据文件时出现拒绝访问
|
SQL Oracle 关系型数据库
Oracle数据库sqlplus命令行执行sql语句时,语句有中文报错解决
Oracle数据库sqlplus命令行执行sql语句时,语句有中文报错解决
103 0
|
SQL Oracle 关系型数据库
导出Oracle数据库sqlplus命令行查询的结果到文件
导出Oracle数据库sqlplus命令行查询的结果到文件
842 0
|
SQL Oracle 关系型数据库
oracle用SQL Plus输入命令为什么只显示2
oracle用SQL Plus输入命令为什么只显示2
636 0
oracle用SQL Plus输入命令为什么只显示2
|
Oracle 关系型数据库 数据库
Oracle的服务器端和客户端同时安装Sqlplus无法登陆的处理
Oracle的服务器端和客户端同时安装Sqlplus无法登陆的处理
187 0
Oracle的服务器端和客户端同时安装Sqlplus无法登陆的处理