Shulou(Shulou.com)06/01 Report--

Environment description:

Operating system: rhel 5.4

Database version: Sybase IQ-15_1

Problem description: a customer in Shanghai Sybase IQ-15_1 database host restarts, Sybase IQ-15_1 database starts abnormally, due to database administrator Sybase IQ-15_1

Inexperienced and unable to log in to the local Sybase IQ-15_1 console.

Problem handling process:

First, solve the login problem of iqdemo library.

1. Iqdemo database process is found through ps-ef | grep sybase

2. Temporarily configure the local LANG parameters of the operating system, export LANG=en

The operating system LANG parameter is not configured. The login error is as follows:

Your sybase home directory is / opt/sybase. Check the environment variable BYBASE if it is not the one you want!

Using local name "zh_cn.DGB" definied in environment variable LANG locale name "zh_CN.GBK" doesn't exist in your

/ opt/sybase/locales/locales.dat file

An error occurred when attempting to allocate localization-related structures.

The error prompt character set zh_CN.GBK does not exist in / opt/sybase/locales/locales.dat

3. Go to the sybase iq installation directory / opt/sybase/, to find the interfaces file, and execute more interfaces without content

The interfaces configuration is as follows (IQ is the hostname, 2368 is the network port number in the iqdemo.cfg file of the demo library control file, note the interfaces configuration format):

Iqdemo

Master tcp ether IQ 2638

Query tcp ether IQ 2638

-- when interfaces is not configured, the login error is as follows:

CT-LIBRARY error:

Ct_connect (): directory service layer:internal directory control layer error:Requested server name not found.

-- when interfaces configures hostname DNS resolution incorrectly (here refers to the tab space before master query), login error:

CT-LIBRARY error:

Ct_connect (): directory service layer:internal directory control layer error:Invalid syntax found in interfaces file.

-- when the interfaces configuration format is incorrect, the login error is reported:

CT-LIBRARY error:

Ct_connect (): network packet layer:internal net library error:Protocol driver call to parse connection information failed

-- when interfaces configures the network port incorrectly, the login error is reported:

CT-LIBRARY error:

Ct_connect (): directory service layer:internal directory control layer error:Net-Lib protocol driver call to connect two endpoints failed

4. After the interfaces file is configured correctly, log in to the sybase iq console using the sybase user

$iqsql-UDBA-Psql-Siqdemo

>

Second, deal with the start-up authority of the user business database

1. Sybase users try to start the tpaic library: start_iq @ / opt/sybase/tpaic/tpaic.cfg / opt/sybase/tpaic/tpaic.db, and start the error report:

2. Root users execute ls-l / opt/sybase/tpaic/DSMSYS01.iq via ls-l, and find that the file is a soft connection, linked to / dev/raw/raw10

3. Root users have root:root permissions to perform ls-l / dev/raw/raw*, discovery / dev/raw/raw*.

4. After communicating with the administrator, the customer accepts the temporary modification of raw device permissions. The modification command is 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 using the sybase user again

6. Log in to the tpaic library

At this point, the problem is solved!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.