問題描述:上海一客戶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庫
到此,問題解決完畢!