问题描述:上海一客户Sybase IQ-15_1数据库主机重启,Sybase IQ-15_1数据库启动异常,由于数据库管理员Sybase IQ-15_1
Your sybase home directory is /opt/sybase. Check the environment variable BYBASE if it is not the one you want!
An error occurred when attempting to allocate localization-related structures.
ct_connect():directory service layer:internal directory control layer error:Net-Lib protocol driver call to connect two endpoints failed
4、interfaces文件配置正确后,使用sybase用户登录sybase iq控制台
$iqsql -UDBA -Psql -Siqdemo
>
二、处理用户业务数据库启动权限问题
1、sybase用户尝试启动tpaic库:start_iq @/opt/sybase/tpaic/tpaic.cfg /opt/sybase/tpaic/tpaic.db,启动报错:
2、root用户通过ls -l执行:ls -l /opt/sybase/tpaic/DSMSYS01.iq,发现该文件是个软连接,链接到/dev/raw/raw10
3、root用户执行ls -l /dev/raw/raw*,发现
/dev/raw/raw*均为root:root权限
4、经与管理员沟通后,客户接受进行raw设备权限的临时修改,修改命令如下:
chown sybase:sybase /dev/raw/raw10
chown sybase:sybase /dev/raw/raw9
chown sybase:sybase /dev/raw/raw8
chown sybase:sybase /dev/raw/raw7
chown sybase:sybase /dev/raw/raw6
chown sybase:sybase /dev/raw/raw5
chown sybase:sybase /dev/raw/raw4
chown sybase:sybase /dev/raw/raw3
chown sybase:sybase /dev/raw/raw2
chmod 0660 /dev/raw/raw2
chmod 0660 /dev/raw/raw3
chmod 0660 /dev/raw/raw4
chmod 0660 /dev/raw/raw5
chmod 0660 /dev/raw/raw6
chmod 0660 /dev/raw/raw7
chmod 0660 /dev/raw/raw8
chmod 0660 /dev/raw/raw9
chmod 0660 /dev/raw/raw10
5、再次尝试使用sybase用户启动sybase iq数据库
6、登录tpaic库
到此,问题解决完毕!