[work log] Errors when run sqlplus and svrmgrl after relink oracle server

原创 2004年07月13日 11:31:00

July 12. 2004

I met a couple of time the problem.  The nearest time was last week.

solution - from Metalink note.

Problem Description:
Running SVRMGRL (or any other Oracle tool such as SQL*Plus) on an IBM AIX RS/6000
machine returns:

On AIX prior to 4.3:
Could not load program oracle
Symbol kaio_rdwr in /usr/lib/libc.a is undefined
Symbol iosuspend in /usr/lib/libc.a is undefined
Symbol cancel in /usr/lib/libc.a is undefined
Symbol listio in /usr/lib/libc.a is undefined
Could not load library libc.a[aio.o]
Error was: Exec format error
Cannot startup oracle.

On AIX 4.3.x:
exec(): 0509-036 Cannot load program svrmgrl because of the following errors:
0509-023 Symbol kaio_rdwr in /usr/lib/libc_r.a is not defined.
0509-023 Symbol listio in /usr/lib/lib c_r.a is not defined.
0509-023 Symbol acancel in /usr/lib/libc_r.a is not defined.
0509-023 Symbol iosuspend in /usr/lib/libc_r.a is not defined.
0509-022 Cannot load library libc_r.a[aio.o].
0509-026 System error: Cannot run a file that does not have a valid format.

Problem Explanation:
Asynchronous I/O has not been configured or started on the system.

Solution Description:
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.

Solution Explanation:
Oracle executables need of Asynchronous I/O to work properly.

Search words:
libc_r.a, libc.a, Async, Undefined, Symbol, Asynchronous
kaio_rdwr, aio.o, forma

Oracle 11gR2 Relink 脚本 新特性 说明

一.11gR2 中 Relink 脚本说明 前面将了OracleOption 和其link的2篇Blog,如下:OracleBinary Options 说明http://blog.csdn.net/...
  • tianlesoftware
  • tianlesoftware
  • 2012年05月17日 21:13
  • 4918

【Oracle学习】之 在sqlplus设置格式 和 case...when 和 decode

一、在sqlplus设置格式 (1)指定行的长度SQLplus输出行的默认长度为80//查看输出行的长度 show linesize; set linesize 100; (2)指定分页的尺寸//查看...
  • fanfan4569
  • fanfan4569
  • 2017年03月01日 16:10
  • 390

Oracle PL/SQLWarning: Function created with compilation errors.

How to handle "Warning: Function created with compilation errors." when create Oracle function. ...
  • HiHui
  • HiHui
  • 2016年10月18日 21:07
  • 778

sqlplus -help

因为前面一个错误,觉得自己对于sqlplus这个命令了解的太少,特贴出sqlplus帮助,并加以简要的注释。 SQL*Plus: Release Production -...
  • ghostliming
  • ghostliming
  • 2015年12月09日 20:55
  • 1047

【翻译自mos文章】检查$ORACLE_HOME是否是RAC的HOME的方法以及relink RAC的Oracle binary的方法

检查$ORACLE_HOME是否是RAC的HOME的方法以及relink RAC的Oracle binary的方法
  • msdnchina
  • msdnchina
  • 2016年02月10日 11:34
  • 1735

oracle语法错误解决办法-在sqlplus中执行;用命令 show error 可查看具体错误地方

oracle语法错误解决办法-在sqlplus中执行;用命令 show error 可查看具体错误地方...
  • fujianianhua
  • fujianianhua
  • 2012年07月25日 16:49
  • 1822


最近用 postfix + dovecot 搭建了一个邮件服务器, 被人当做垃圾邮件转发器,经过配置postfix 的黑白名单, postfix 提示成功的 REJECT 了垃圾邮件, 不过还是有无数...
  • langeldep
  • langeldep
  • 2014年08月20日 12:26
  • 6160


在linux或者unix系统上使用sqlplus命令来登录用户的时候我们经常会直接使用以下命令来登录: sqlplus scott/scott; 但是这样登录在安全性上来说是不好的 我们可以...
  • u011214505
  • u011214505
  • 2016年01月08日 10:53
  • 10767

装好Oracle后打开sqlplus权限不足:cannot restore segment prot after reloc: Permission denied

问题: [root@Kernelry ~]# su - oracle [oracle@Kernelry ~]$ sqlplus sys/oralinux as sysdba sqlplus: erro...
  • a756041482
  • a756041482
  • 2015年09月10日 16:09
  • 643

Failed to run the WC DB work queue associated with 错误的解决

svn checkout 代码是出现如标题的错误,提示我clean up ,clean up失败,于是网上搜到了这一clean up 失败的解决方法,clean up 后再进入代码update 就可以...
  • alan00000
  • alan00000
  • 2015年03月05日 16:27
  • 28747
您举报文章:[work log] Errors when run sqlplus and svrmgrl after relink oracle server