How to Start the Sybase Database Service - Huawei Enterprise Support Community

Perform the following operations to start the Sybase database service in the single-server system:

Use PuTTY to log in to the OS as the ossuser user. Run the following command to switch to the root user.
```
$ su - root
Password: password for the root user
```

Run the following commands to start the Sybase database service:

# su - dbuser

$ . /opt/sybase/SYBASE.sh

$ cd /opt/sybase/ASE*/install

$ ./startserver -f ./RUN_DBSVR &

$ ./startserver -f ./RUN_DBSVR_back &

Run the following command to check whether the Sybase database service is running:

$ ./showserver

A message similar to the following will be displayed:

UID   PID  PPID   C    STIME TTY         TIME CMD
  dbuser  4195  4170   0 18:42:26 ?          70:35 /opt/sybase/ASE-15_0/bin/dataserver -ONLINE:1,0,0x6505fd2a, 10000000000, 0x18fc
  dbuser  4563  4559   0 18:42:50 ?           0:00 /opt/sybase/ASE-15_0/bin/backupserver -SDBSVR_back -e/opt/sybase/ASE-15_0/install
  dbuser  4170  4168   0 18:42:00 ?         546:12 /opt/sybase/ASE-15_0/bin/dataserver -sDBSVR -d/opt/sybase/data/lv_master -e/opt

NOTE:

If the displayed information contains /opt/sybase/ASE-15_0/bin/dataserver -ONLINE, /opt/sybase/ASE-15_0/bin/backupserver -SDBSVR_back and /opt/sybase/ASE-15_0/bin/dataserver -sDBSVR, the Sybase database service is running.

Perform the following operations to start the Sybase database service in the HA system:

Log in to the active site as the ossuser user. Run the following command to switch to the root user.
```
$ su - root
Password: password for the root user
```

Run the following commands to query Veritas resource names:

# haconf -makerw
# hares -list

Information similar to the following is displayed in a Solaris high availability system:

BackupServer  		Primary
DataFilesystem		Primary
DatabaseServer		Primary
NMSServer     		Primary
RVGPrimary    		Primary
datarvg       		Primary
wac           		Primary

Information similar to the following is displayed in a PC Linux high availability system:

APPBOND                 Primaster
BackupServer            Primary
DatabaseServer          Primary
NMSServer               Primary
RVGPrimary              Primary
datarvg                 Primary
mountRes                Primary
wac                     Primary

Run the hagrp -autoenable AppService -sys hostname command to set the AppService group to autoenable. Run the hares -modify resource name Enabled 1 command to change the status of all Veritas resources to Enabled. Use the resource names displayed in the previous command output as an example. Run the following commands to change the status of all the Veritas resources to Enabled:
For example, execute the following commands in a Solaris high availability system:
```
# hares -modify BackupServer Enabled 1
# hares -modify DataFilesystem Enabled 1
# hares -modify DatabaseServer Enabled 1
# hares -modify NMSServer Enabled 1
# hares -modify RVGPrimary Enabled 1
# hares -modify datarvg Enabled 1
# hares -modify wac Enabled 1
```
For example, execute the following commands in a PC Linux high availability system:
```
# hagrp -autoenable AppService -sys hostname
# hares -modify APPBOND Enabled 1
# hares -modify BackupServer Enabled 1
# hares -modify DatabaseServer Enabled 1
# hares -modify NMSServer Enabled 1
# hares -modify RVGPrimary Enabled 1
# hares -modify datarvg Enabled 1
# hares -modify mountRes Enabled 1
# hares -modify wac Enabled 1
```
NOTE:
hostname specifies the server name. You can run the hostname command to view the server name.
Run the following command to start the Sybase database service:
# hares -online BackupServer -sys hostname
NOTE:
hostname specifies the server name. You can run the hostname command to view the server name.