Environment Description:
Operating system: Rhel 5.4
Database version: Sybase Iq-15_1
Problem Description: Shanghai One customer Sybase iq-15_1 database host restart, Sybase Iq-15_1 database startup exception due to database administrator Sybase Iq-15_1
Lack of experience, login to local Sybase iq-15_1 console.
Problem-handling process:
First, solve the Iqdemo library login problem
1. Iqdemo database process was discovered through Ps-ef|grep Sybase
2. Temporarily configure the operating system local lang parameter, export
The operating system lang parameter is not configured and the login error is as follows:
Your Sybase home Directory is/opt/sybase. Check the environment variable bybase if it isn't the one you want!
Using The local name "ZH_CN." DGB "definied in environment variable
LANG locale name "ZH_CN. GBK "doesn ' t existIn your
/opt/sybase/locales/locales.dat file
An error occurred is attempting to allocate localization-related structures.
This error indicates the character set
ZH_CN.GBK in
does not exist in/opt/sybase/locales/locales.dat
3. Enter Sybase IQ installation directory/opt/sybase/, locate the interfaces file, execute more interfaces no content
The interfaces configuration is as follows (
IQ is host name, 2368 is the network port number in the Demo library control file Iqdemo.cfg file, note the interfaces configuration format）：
Iqdemo
Master TCP ether IQ 2638
Query TCP ether IQ2638
-- when the interfaces is not configured, the login error is as follows:
Ct-library Error:
ct_connect ():d irectory Service layer:internal directory control layer error:requested server name not fo und.
--When the interfaces configuration hostname DNS parsing is incorrect (this refers to the tab space in front of the master query), login error:
ct-library Error:
ct_connect ():d irectory Service layer:internal directory control layer error:invalid syntax found in interfaces file.< /c7>
--When the interfaces configuration is not properly formatted, the login error:
ct-library Error:
ct_connect (): Network packet layer:internal Net Library Error:protocol driver call to parse connection information fail Ed
--When the interfaces configuration network port is not positive, login error:
Ct-library Error:
Ct_connect ():d irectory Service layer:internal Directory control Layer error:net-lib protocol driver call to connect Dpoints failed
4. After the interfaces file is configured correctly, log in to the Sybase IQ console using a Sybase user
$iqsql-udba-psql-siqdemo
>
Second, handling User Service database start permissions issues
1. Sybase user tries to start Tpaic Library: Start_iq @/opt/sybase/tpaic/tpaic.cfg/opt/sybase/tpaic/tpaic.db, start error:
2, root user through Ls-l execution: ls-l/opt/sybase/tpaic/dsmsys01.iq, found that the file is a soft connection, linked to/DEV/RAW/RAW10
3, root user execution ls-l/dev/raw/raw*, found/dev/raw/raw* are root:root permissions
4, after communicating with the administrator, the customer accepts the temporary modification of the raw device permission, and modifies the command as follows:
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. Try to start the Sybase IQ database again with Sybase users
6, Login Tpaic Library
Here, the problem is resolved!
Sybase Iq-15_1 Local Login issues interfaces file configuration and data file permissions
