cannot be loaded : Symbol resolution failed for /usr/lib/libc.a(aio.o)

-bash-4.3$ sqlplus " / as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 27 12:42:03 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

exec(): 0509-036 Cannot load program oracleorcl because of the following errors:
        0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
        0509-136   Symbol kaio_rdwr64 (number 0) is not exported from
                   dependent module /unix.
        0509-136   Symbol listio64 (number 1) is not exported from
                   dependent module /unix.
        0509-136   Symbol acancel64 (number 2) is not exported from
                   dependent module /unix.
        0509-136   Symbol iosuspend64 (number 3) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait (number 4) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait64 (number 5) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait_timeout (number 6) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait_timeout64 (number 7) is not exported from
                   dependent module /unix.
        0509-026 System error: Error 0
        0509-192 Examine .loader section symbols with the
                 'dump -Tv' command.
ERROR:
ORA-12547: TNS:lost contact

Cause
The IBM Informix Dynamic Server requires that the drivers for Asynchronous IO (AIO) be loaded on the AIX system where the IBM Informix Dynamic Server is used. The IBM Informix Dynamic Server executables use entry points defined by these drivers.

The error can be seen when AIO was not enabled at the AIX system.

Resolving the problem
Enable AIO in AIX operating system. These are two possible ways to do this:
As root:
1. From “smitty aio”
2. Change / Show Characteristics of Asynchronous I/O
3. STATE to be configured at system restart
4. Choose “available.”
5. Execute the following command:
/usr/sbin/mkdev -l aio0

This change does not require a reboot.
Consult AIX documentation for further details on enabling AIO at Operating System.

Posted in AIX

Ubuntu14.04搭建源服务器

1. 安装dpkg-dev和apache2
2. 创建目录存放安装包/var/www/html/pkgs
3. 修改apache配置文件
vi /etc/apache2/http.conf

ServerName 192.168.82.210
NameVirtualHost 192.168.82.210

    ServerName 192.168.82.210
    DocumentRoot /var/www/html/pkgs/
    
        Options Indexes FollowSymLinks
        AllowOverride None
        Order allow,deny
        Allow from all
    

4. 修改/etc/apt/sources.list文件
echo “” > /etc/apt/sources.list
增加内容deb file:/var/www/html/pkgs/ /
5. 执行如下命令
cd /var/www/html/pkgs
dpkg-scanpackages amd64 /dev/null | gzip > Packages.gz
6. 重启apache2
/etc/init.d/apache2 restart
7. 修改其他ubuntu的sources.list
echo “” > /etc/apt/sources.list
增加如下内容deb http://192.168.82.210/pkgs /
8. 更新源apt-get update
9. 在其他客户端即可安装源上的安装包了,方便快捷。

Informix数据表记录的增删查shell脚本

# including operation of create table , insert data into table , select data from table and delete data from table.
# first you should seting database's and table's name by dbname and tbname
# create table, execute the script with the parameter create like ./operation create
function create()
{
echo "create table "${tbname}"(id  integer,time datetime year to second)" > create.sql
dbaccess ${dbname} create.sql
}
# insert data into table, execute the script with the parameter insert and two integer like ./operation insert 0 10
# first integer decided the started id of insert data
# second integer decided the ended id of insert data
function insert()
{
n=$1
m=$2
echo $n
echo $m
for((i=$n;i< $m;i++))
do
echo "insert into  "${tbname}" values($i,sysdate);">insert.sql
dbaccess ${dbname} insert.sql
echo $i
sleep 1
done
}
# select data from table ,execute the script with the parameter select like ./operation select
function sel()
{
echo "select * from "${tbname}"" > select.sql
dbaccess ${dbname} select.sql
}
# delete all data from table , execute the script with the parameter delete like ./operation delete
function delete()
{
echo "delete  from "${tbname}"" > delete.sql
dbaccess ${dbname} delete.sql
}
dbname=was
tbname=ding
case $1 in
    create)
        create
    ;;
    insert)
        insert $2 $3
    ;;
    select)
        sel
    ;;
    delete)
        delete
    ;;
esac

Selenium Grid 和 Robot Framework 结合

1. 服务端

启动Hub

java -jar selenium-server-standalone-2.48.2.jar -role hub

运行Robot脚本

pybot -l /home/kyle/Desktop/wsx/ride/output.xml -l /home/kyle/Desktop/wsx/ride/log.html -r /home/kyle/Desktop/wsx/ride/report.html /home/kyle/Desktop/wsx/ride/TestDemo

脚本实例

*** Settings ***
Library           Selenium2Library

*** Variables ***
${BROWSER}        ff
${HUB}            http://127.0.0.1:4444/wd/hub

*** Test Cases ***
LoginDemo
    Open Browser    http://www.baidu.com    ${BROWSER}    b1    ${HUB}

2. 客户端

启动Node并注册到Hub

java -jar selenium-server-standalone-2.48.2.jar -role node -hub http://IP:4444/grid/register/

3. 效果

客户端启动浏览器跑脚本

Linux x86_64 安装 Oracle 32bit 的难题

make.log错误

gcc -o /u01/app/oracle/product/11.2.0/db_1/sysman/lib/nmo -L/u01/app/oracle/product/11.2.0/db_1/lib/ -L/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ -L/u01/app/oracle/product/11.2.0/db_1/lib/stubs/ `cat /u01/app/oracle/product/11.2.0/db_1/lib/sysliblist`  -lm `cat /u01/app/oracle/product/11.2.0/db_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/11.2.0/db_1/lib /u01/app/oracle/product/11.2.0/db_1/sysman/lib/s0nmo.o /u01/app/oracle/product/11.2.0/db_1/sysman/lib/libnmo.a -lcrypt -ldl    `cat /u01/app/oracle/product/11.2.0/db_1/lib/sysliblist` -ldl -lm
/usr/bin/ld: skipping incompatible /u01/app/oracle/product/11.2.0/db_1/lib/stubs//libdl.so when searching for -ldl
/usr/bin/ld: skipping incompatible /u01/app/oracle/product/11.2.0/db_1/lib/stubs//libm.so when searching for -lm
/usr/bin/ld: skipping incompatible /u01/app/oracle/product/11.2.0/db_1/lib/stubs//libpthread.so when searching for -lpthread
/usr/bin/ld: skipping incompatible /u01/app/oracle/product/11.2.0/db_1/lib/stubs//libnsl.so when searching for -lnsl
/usr/bin/ld: skipping incompatible /u01/app/oracle/product/11.2.0/db_1/lib//libirc.a when searching for -lirc
/usr/bin/ld: skipping incompatible /u01/app/oracle/product/11.2.0/db_1/lib/libirc.a when searching for -lirc
/usr/bin/ld: cannot find -lirc
collect2: ld returned 1 exit status
make[1]: Leaving directory `/u01/app/oracle/product/11.2.0/db_1/sysman/lib'
make[1]: *** [/u01/app/oracle/product/11.2.0/db_1/sysman/lib/nmo] Error 1
make: *** [nmo] Error 2
mv gcc gcc64
vi gcc
#!/bin/sh
gcc64 -m32 "$@"
chmod +x gcc

mysql-python安装时EnvironmentError: mysql_config not found

会出现错误

sh: mysql_config: not found
Traceback (most recent call last):
  File "setup.py", line 15, in 
    metadata, options = get_config()
  File "/home/zhxia/apps/source/MySQL-python-1.2.3/setup_posix.py", line 43, in get_config
    libs = mysql_config("libs_r")
  File "/home/zhxia/apps/source/MySQL-python-1.2.3/setup_posix.py", line 24, in mysql_config
    raise EnvironmentError("%s not found" % (mysql_config.path,))
EnvironmentError: mysql_config not found

没有安装:libmysqlclient-dev

apt-get install libmysqlclient-dev

找到mysql_config文件的路径

sudo updatedb
locate mysql_config

mysql_config的位置为:/usr/bin/mysql_config

在mysql-python源码包下找到:setup_posix.py 文件,然后找到文件中的 mysql_config.path 将其值改为:/usr/bin/mysql_config,然后 sudo python setup.py install ,就ok了