最近比较忙，比较烦，不想说话，想打人，想发脾气了；

这几天比较累，相当的累，这两个星期什么都不顺心，心情也很低落

这两个星期维护的移动、广电网络都出现问题了，o(︶︿︶)o 唉；

最烦的是广电的，我们公司好几百人都不会，没有人玩这个，这个咋办哦，崩溃呀！

唉，靠天、靠地、还不如靠自己；自己研究吧！经过一个星期的研究，最终成正果了；

下面是我的操作记录，分享给大家：

一、安装环境准备

到cisco官网下载下面问题，需要有coo帐号：

scms-cm-v355-b182-bundle-linux-tar.part1
scms-cm-v355-b182-bundle-linux-tar.part2
scms-cm-v355-b182-bundle-linux-tar.part3
scms-cm-v355-b182-bundle-linux-tar.part4
scms-cm-v355-b182-bundle-linux-tar.part5

 

此时可使用下面命令检查vsftpd和compat-libstdc++是否安装正确

[root@localhost share]# rpm -q -a |grep vsftpd
vsftpd-2.0.1-8.el4
[root@localhost share]# rpm -q -a |grep compat
compat-dapl-2.0.15-1.el4
compat-libstdc++-33-3.2.3-47.3
compat-libgcc-296-2.96-132.7.2
compat-libcom_err-1.0-5
compat-db-4.1.25-9
compat-libstdc++-296-2.96-132.7.2
compat-openldap-2.1.30-12.el4

echo "kernel.shmmax=536870912" >> /etc/sysctl.conf //在redhat上最大共享内存不建议超过4*1024*1024*1024-1=4294967295

这个更改在系统重新启动后生效。若不设置该参数，在安装Sybase数据库时会出现错误

设备host文件：

[root@localhost share]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.0.12 daybreak.com hubin
~
~

将把CM软件打包
root@localhost sce]# cat scms-cm-v355-b182-bundle-linux-tar.part1 scms-cm-v355-b182-bundle-linux-tar.part2 scms-cm-v355-b182-bundle-linux-tar.part3 scms-cm-v355-b182-bundle-linux-tar.part4 scms-cm-v355-b182-bundle-linux-tar.part5 > SCMS_CM_bundle_linux_v350.tar
[root@localhost sce]# ls
SCMS_CM_bundle_linux_v350.tar
scms-cm-v355-b182-bundle-linux-tar.part1
scms-cm-v355-b182-bundle-linux-tar.part2
scms-cm-v355-b182-bundle-linux-tar.part3
scms-cm-v355-b182-bundle-linux-tar.part4
scms-cm-v355-b182-bundle-linux-tar.part5
[root@localhost sce]# tar xvf SCMS_CM_bundle_linux_v350.tar 解压CM软件
NIFEST
CM_3.5.5_B182.tgz
HomeCM.tgz
extras/
extras/java/
extras/java/installjava.sh
extras/java/linux/
extras/java/linux/i686/
extras/java/linux/i686/jre1.5.0_14.sum
extras/java/linux/i686/jre1.5.0_14.tar.gz
extras/java/linux/x86_64/
sybase/config/09 devices.sql
sybase/config/10 tempdb.sql
sybase/config/11 apricot db.sql
sybase/config/12 apricot thresholds.sql
sybase/config/13 apricot abortran.sql
sybase/config/15 pqb_admin user.sql
sybase/config/16 restart
sybase/config/configsyb.sh
sybase/config/sybase-etc-init-script
sybase/installsyb.sh
sybase/Linux/
sybase/Linux/ANY_200604040202.lic
sybase/Linux/ase1502_linx86_32.sum
sybase/Linux/ase1502_linx86_32.tgz
sybase/Linux/check.sh
sybase/Linux/sqlsrv.res
sybase/Linux/sybsession.txt
sybase/syb_interfaces.sh
[root@localhost sce]# ls
CM_3.5.5_B182.tgz scms-cm-v355-b182-bundle-linux-tar.part1
doc scms-cm-v355-b182-bundle-linux-tar.part2
extras scms-cm-v355-b182-bundle-linux-tar.part3
HomeCM.tgz scms-cm-v355-b182-bundle-linux-tar.part4
install-scripts scms-cm-v355-b182-bundle-linux-tar.part5
MANIFEST sybase
SCMS_CM_bundle_linux_v350.tar
[root@localhost sce]# cd install-scripts/
[root@localhost install-scripts]# ls
Aggregation dbmig_21_250.sh install-cm.sh
check_prerequisites.sh dbmig_250_255.sh rpt-tmpl-scas-modifier.exe
check_syb.sh dbrename_25_300.sh set_shmmax.sh

运行install-scripts/check_prerequisites.sh 查系统是否符合sybase和cm的安装条件

[root@localhost install-scripts]# ./check_prerequisites.sh
Check: Minimal CPU Speed: 800
[Success] CPU Speed is sufficient: 2509MHz

Check: Minimal OS Version: RHEL4/5
[Success] Found RHEL4, Checking minimal update level:
[Success] Update level: 8

Check: Additional RPMS
[Success] Required library glibc installed
[Failed] Installed version is "kernel-2.6.9-89.EL"
[Notice] If installed version is greater than expected, you may ignore this error
[Success] Required library compat-libstdc++-33 installed

Check: Total memory
[Success] Found 1099556 KB memory

Check: Max Shared memory
[Failed] Found 33554432 bytes shared memory, need at least 512000000 bytes
[Failed] Run set_shmmmax.sh script

Check: Python in execution path
[Success] Python found at /usr/bin/python

Check: 8096000K free on intended CM home dir:
[Warning] No CM home directory given. Cannot verify there is enough free space to install CM

Check: 1024000K free on intended Sybase home dir:
[Warning] No sybase home directory given. Cannot verify there is enough free space to install Sybase

Check: 15000000K free on intended Sybase Data dir:
[Warning] No sybase Data directory given.
[Notice] Only applicable if you intend on using Datadir installation method

Check: Locale set to en_US
[Success] System Locale set to en_US
[Success] Current Locale set to en_US

Check: Names for all NIC's
[Success] IP Address 192.168.0.12 is resolvable through /etc/hosts
[Success] IP Address 127.0.0.1 is resolvable through /etc/hosts


[root@localhost install-scripts]# echo "kernel.shmmax=536870912" >> /etc/sysctl.conf 设置共享内存
现在我们需要把设备reboot下了啦，这样设置的一些参数，才可以生效的；

二、install sybase database

[root@daybreak ~]#
[root@daybreak ~]#
[root@daybreak ~]# cd /etc/sysc
sysconfig/ sysctl.conf
[root@daybreak ~]# cat /etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1
kernel.shmmax=536870912
[root@daybreak ~]# cd /home/sce/install-scripts/
[root@daybreak install-scripts]# ./check_prerequisites.sh
Check: Minimal CPU Speed: 800
[Success] CPU Speed is sufficient: 2528MHz

Check: Minimal OS Version: RHEL4/5
[Success] Found RHEL4, Checking minimal update level:
[Success] Update level: 8

Check: Additional RPMS
[Success] Required library glibc installed
[Failed] Installed version is "kernel-2.6.9-89.EL"
[Notice] If installed version is greater than expected, you may ignore this error
[Success] Required library compat-libstdc++-33 installed

Check: Total memory
[Success] Found 1099556 KB memory

Check: Max Shared memory
[Success] Found 536870912 bytes of shared memory

Check: Python in execution path
[Success] Python found at /usr/bin/python

Check: 8096000K free on intended CM home dir:
[Warning] No CM home directory given. Cannot verify there is enough free space to install CM

Check: 1024000K free on intended Sybase home dir:
[Warning] No sybase home directory given. Cannot verify there is enough free space to install Sybase

Check: 15000000K free on intended Sybase Data dir:
[Warning] No sybase Data directory given.
[Notice] Only applicable if you intend on using Datadir installation method

Check: Locale set to en_US
[Success] System Locale set to en_US
[Success] Current Locale set to en_US

Check: Names for all NIC's
[Success] IP Address 192.168.0.12 is resolvable through /etc/hosts
[Success] IP Address 127.0.0.1 is resolvable through /etc/hosts


[root@daybreak sybase]# ./installsyb.sh
[root@daybreak sybase]# Starting Sybase install sequence
Must specify Sybase home

Usage:
installsyb.sh --sybhome=SYBHOME --datadir=DATADIR [ --y | --n ]

SYBHOME is the new home directory of the Sybase user (should have 1000000 Kbytes free).
Data location options:
1) specify DATADIR as a directory in which all Sybase data will be stored in files
This location should be in a partition where at least 15GB is free, and must be an empty directory.
2) use --y to automatically answer YES to all error questions during installation (Halt on No errors)
3) use --n to automatically answer NO to all error questions during installation (Halt on All errors)

[root@daybreak sybase]# ./installsyb.sh --sybhome=/opt/sybase --datadir=/opt/data/
Starting Sybase install sequence
testing dist file integrity...done
Running platform-specific check file...done
Adding sybase user...done
NOTE: if this installation aborts or fails, you may want
to remove the sybase process/user before attempting again. This
can be done with the command:
pkill -9 -xU sybase; userdel -r sybase
 

Extracting dist file to /usr/tmp/sybinstall7269...done
Running Sybase installer - this will take a while...done
Configuring Sybase ASE ...
Building Adaptive Server 'pqbsyb1':
Writing entry into directory services...
Directory services entry complete.
Building master device...
Master device complete.
Writing RUN_pqbsyb1 file...
RUN_pqbsyb1 file complete.
Starting server...
Server started.
Building sysprocs device and sybsystemprocs database...
sysprocs device and sybsystemprocs database created.
Running installmaster script to install system stored procedures...
installmaster: 90% complete.
installmaster: 100% complete.
installmaster script complete.
Creating two-phase commit database...
Two phase commit database complete.
Installing common character sets (Code Page 437, Code Page 850, ISO Latin-1,
Macintosh and HP Roman-8)...
Character sets installed.
Setting server name in Adaptive Server...
Server name added.
Server 'pqbsyb1' was successfully created.
done
Stopping Sybase for interfaces update...
Waiting for Sybase to go down...
Waiting for Sybase to come up... (0 of 60)
Please enter SIZE in 2K blocks of file to be used for the "data[maximum is 15243036; minimum
The inserted data file size 15 is bigger than the maximum 15243036
Please enter SIZE in 2K blocks of file to be used for the "data[maximum is 15243036; minimum is 5242798]" device.
NOTE - the actual size required will include a 1.05 overhead on the amount you specify.
SIZE in 2K blocks: 10000000   设置数据库空间大小
Do you want to input the values again? (yes/no): no
Password correctly set.
(return status = 0)
Making symlinks in /etc/init.d and rcX.d ...

Beginning configuration of Sybase server, this can take up to THREE HOURS,
and produce lots of output.
IMPORTANT: Do not interrupt this process
/home/sce/sybase/config /home/sce/sybase/config
=== running sql script 03 net and memory.sql
00:00000:00015:2011/07/02 11:51:34.16 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.019'.
00:00000:00015:2011/07/02 11:51:34.16 server The configuration option 'max network packet size' has been changed by 'sa' from '2048' to '16384'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max network packet size 2048 0 16384
2048 bytes static

(1 row affected)
Configuration option changed. Since the option is static, Adaptive Server must
be rebooted in order for the change to take effect.
Changing the value of 'max network packet size' to '16384' reduces the amount of
memory ASE uses by 20 K. The reduced memory may be reused when this configure
value changes, but will not be released until ASE restarts.
(return status = 0)
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
tcp no delay 1 0 1
1 switch static

(1 row affected)
Resulting configuration value and memory use have not changed from previous
values: new configuration value 1, previous value 1.
(return status = 0)
00:00000:00015:2011/07/02 11:51:34.20 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.020'.
00:00000:00015:2011/07/02 11:51:34.20 server The configuration option 'allocate max shared memory' has been changed by 'sa' from '0' to '1'.
00:00000:00015:2011/07/02 11:51:34.21 kernel Allocating a shared memory segment of size 17833984 bytes.
00:00000:00015:2011/07/02 11:51:34.24 kernel Total shared memory allocated in this attempt. Number of segments(s): 1. Total size of allocation in bytes: 17833984
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
allocate max shared memory 0 0 1
1 switch dynamic

(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'allocate max shared memory' does not increase the amount
of memory Adaptive Server uses.
(return status = 0)
00:00000:00015:2011/07/02 11:51:34.27 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.021'.
00:00000:00015:2011/07/02 11:51:34.27 server The configuration option 'max memory' has been changed by 'sa' from '49152' to '250000'.
00:00000:00015:2011/07/02 11:51:34.27 kernel Allocating a shared memory segment of size 411336704 bytes.
00:00000:00015:2011/07/02 11:51:34.27 kernel Total shared memory allocated in this attempt. Number of segments(s): 1. Total size of allocation in bytes: 411336704
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 49152 500000 250000
250000 memory pages(2k) dynamic

(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'max memory' does not increase the amount of memory
Adaptive Server uses.
(return status = 0)
00:00000:00015:2011/07/02 11:51:34.39 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to  'procedure cache size' has been changed by 'sa' from '7000' to '12800'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
procedure cache size 7000 27104 12800
12800 memory pages(2k) dynamic

(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'procedure cache size' to '12800' increases the amount of
memory ASE uses by 313924 K.
(return status = 0)
00:00000:00015:2011/07/02 11:51:35.43 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.025'.
00:00000:00015:2011/07/02 11:51:35.43 server The configuration option 'additional network memory' has been changed by 'sa' from '0' to '122880'.
Msg 5853, Level 16, State 1:
Server 'pqbsyb1', Procedure 'sp_configure', Line 860:
'additional network memory' has been modified from '123000' to '122880' by the
verification routine.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
additional network memory 0 120 122880
122880 bytes dynamic

(1 Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
lock shared memory 0 0 1
0 switch static

(1 row affected)
Configuration option changed. Since the option is static, Adaptive Server must
be rebooted in order for the change to take effect.
Changing the value of 'lock shared memory' does not increase the amount of
memory Adaptive Server uses.
(return status = 0)
00:00000:00015:2011/07/02 11:51:35.47 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.027'.
00:00000:00015:2011/07/02 11:51:35.47 server The configuration option 'enable housekeeper GC' has been changed by 'sa' from '1' to '4'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
enable housekeeper GC 1 0 4
4 switch dynamic

(1 row affected)
------------ -------------------- ----------
number of locks 10000 7874 50000
50000 number dynamic

(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'number of locks' to '50000' increases the amount of
memory ASE uses by 6244 K.
(return status = 0)
00:00000:00015:2011/07/02 11:51:35.52 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.029'.
00:00000:00015:2011/07/02 11:51:35.53 server The configuration option 'heap memory per user' has been changed by 'sa' from '4096' to '16384'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
heap memory per user 4096 0 16384
16384 bytes dynamic

(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'heap memory per user' to '16384' increases the amount of
memory ASE uses by 330 K.
(return status = 0)
00:00000:00015:2011/07/02 11:51:35.55 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.030'.
00:00000:00015:2011/07/02 11:51:35.55 server The configuration option 'user log cache size' has been changed by 'sa' from '16384' to '32768'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
user log cache size 16384 0 32768
16384 bytes static

(1 row affected)
Configuration option changed. Since the option is static, Adaptive Server must
be rebooted in order for the change to take effect.
Changing the value of 'user log cache size' to '32768' increases the amount of
memory ASE uses by 1184 K.
(return status = 0)
00:00000:00015:2011/07/02 11:51:35.57 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.031'.
00:00000:00015:2011/07/02 11:51:35.57 server The configuration option 'number of user connections' has been changed by 'sa' from '25' to '200'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
number of user connections 25 41886 200
200 number dynamic

(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'number of user connections' to '200' increases the amount
of memory ASE uses by 45194 K.
(return status = 0)
00:00000:00015:2011/07/02 11:51:35.60 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.032'.
00:00000:00015:2011/07/02 11:51:35.60 server The configuration option 'number of open objects' has been changed by 'sa' from '500' to '1000'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
number of open objects 500 1658 1000
1000 number dynamic

(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'number of open objects' to '1000' increases the amount of
memory ASE uses by 2498 K.
(return status = 0)
00:00000:00015:2011/07/02 11:51:35.62 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.033'.
00:00000:00015:2011/07/02 11:51:35.63 server The configuration option 'number of open indexes' has been changed by 'sa' from '500' to '1000'.
apricot_log1
=== running sql script 09 C devices.sql
00:00000:00015:2011/07/02 11:53:30.96 kernel Initializing virtual device 5, '/opt/data//tempdb.dat' with dsync 'off'.
00:00000:00015:2011/07/02 11:53:30.96 kernel Virtual device 5 started using asynchronous i/o.
00:00000:00015:2011/07/02 11:53:30.97 kernel Initializing device /opt/data//tempdb.dat from offset 0 with zeros.
00:00000:00015:2011/07/02 11:53:37.29 kernel Finished initialization.
tempdb_dev
=== running sql script 09 devices.sql
going to activate data, log and temp disks
=== running sql script 10 tempdb.sql
tempdb
Extending database by 65536 pages (1024.0 megabytes) on disk tempdb_dev
Processed 26 allocation unit(s) out of 256 units (allocation page 7936). 10%
completed.
Processed 205 allocation unit(s) out of 256 units (allocation page 53760). 80%
completed.
Processed 231 allocation unit(s) out of 256 units (allocation page 60416). 90%
completed.
Processed 256 allocation unit(s) out of 256 units (allocation page 66816). 100%
completed.
Warning: Attempting to change database options for a temporary database.
Database options must be kept consistent across all temporary databases.
Database option 'select into/bulkcopy/pllsort' turned ON for database 'tempdb'.
Running CHECKPOINT on database 'tempdb' for option 'select
into/bulkcopy/pllsort' to take effect.
(return status = 0)
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
Segment reference to device dropped.
(return status = 0)
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
The last-chance threshold for database tempdb is now 16 pages.
Segment reference to device dropped.
(return status = 0)
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
Segment reference to device dropped.
WARNING: There are no longer any segments referencing device 'master'. This
device will no longer be used for space allocation.
(return status = 0)
00:00000:00017:2011/07/02 11:53:39.18 server Configuration file '/opt/sybase/ASE-15_0/pqbsyb1.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/pqbsyb1.034'.
00:00000:00017:2011/07/02 11:53:39.78 server The configuration option 'number of devices' has been changed by 'sa' from '10' to '30'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
number of devices 10 #34 30
30 number dynamic

(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'number of devices' to '30' reduces the amount of memory
ASE uses by 6 K. The reduced memory may be reused when this configure value
changes, but will not be released until ASE restarts.
(return status = 0)
=== running sql script 11 apricot db.sql

configuring data area
NOTE: THIS SCRIPT MAY RUN A LONG TIME (UP TO THREE HOURS)
WITHOUT PRODUCING OUTPUT. IT IS NOT STUCK - DO NOT INTERRUPT IT
CREATE DATABASE: allocating 1249792 logical pages (19528.0 megabytes) on disk
'apricot_data1'.
CREATE DATABASE: allocating 186112 logical pages (2908.0 megabytes) on disk
'apricot_log1'.
Processed 561 allocation unit(s) out of 5609 units (allocation page 1313280).
10% completed.
Processed 1122 allocation unit(s) out of 5609 units (allocation page 158464).
00:00000:00001:2011/07/02 11:57:07.35 server on top of default character set:
00:00000:00001:2011/07/02 11:57:07.35 server 'iso_1' (ID = 1).
00:00000:00001:2011/07/02 11:57:07.35 server Master device size: 240 megabytes, or 122880 virtual pages. (A virtual page is 2048 bytes.)
Waiting for Sybase to come up... (2 of 30)
Skipping file configsyb.sh
Skipping file sybase-etc-init-script
/home/sce/sybase/config
Done Sybase configuration sequence
done
cleaning up...done.

三、install CM


[root@daybreak sybase]# pwd
/home/sce/sybase
[root@daybreak sybase]# cd ..
[root@daybreak sce]# cd install-scripts/
[root@daybreak install-scripts]# ls
Aggregation dbmig_21_250.sh install-cm.sh
check_prerequisites.sh dbmig_250_255.sh rpt-tmpl-scas-modifier.exe
check_syb.sh dbrename_25_300.sh set_shmmax.sh
[root@daybreak install-scripts]# ./check_syb.sh 检查数据库的安装
Sybase is properly installed and configured
[root@daybreak install-scripts]# cd ..
[root@daybreak sce]# cd install-scripts/

cm文件夹不需要创建，否则出错：

[root@daybreak install-scripts]# ./install-cm.sh -d /opt/cm
verify_dir: /opt/cm already exists
Error - ./install-cm.sh - directory /opt/cm problem - exiting
[root@daybreak install-scripts]# rm /opt/cm
rm: cannot remove directory `/opt/cm': Is a directory
[root@daybreak install-scripts]# rmdir /opt/cm

安装cm
[root@daybreak install-scripts]# ./install-cm.sh -d /opt/cm
Adding/verifying user and group for SCMS-CM ...
Populating scmscm home /opt/cm ...
Populating scmscm home /opt/cm from ../HomeCM.tgz ...
Opening CM distribution ../CM*.tgz ...
...done
fixing sybase init.d script ...
...error
./install-cm.sh - problem fixing sybase symlinks - continuing 5
Installing java...
Checking CRC of linux/i686/jre1.5.0_14.tar.gz ......done
Extracting patch file...
jre1.5.0_14/bin/
jre1.5.0_14/bin/java
jre1.5.0_14/bin/ControlPanel
jre1.5.0_14/bin/java_vm
jre1.5.0_14/bin/javaws
jre1.5.0_14/lib/zi/Atlantic/
jre1.5.0_14/lib/zi/Atlantic/St_Helena
jre1.5.0_14/lib/zi/Atlantic/Cape_Verde
jre1.5.0_14/lib/zi/Atlantic/Madeira
jre1.5.0_14/lib/zi/Atlantic/Reykjavik
jre1.5.0_14/lib/zi/Atlantic/Faroe
jre1.5.0_14/lib/zi/Atlantic/Azores
jre1.5.0_14/lib/zi/Atlantic/Canary
jre1.5.0_14/lib/zi/Atlantic/Bermuda
jre1.5.0_14/lib/zi/Atlantic/Stanley
jre1.5.0_14/lib/zi/Atlantic/South_Georgia
jre1.5.0_14/lib/zi/Australia/
jre1.5.0_14/lib/zi/Australia/Melbourne
jre1.5.0_14/lib/zi/Australia/Adelaide
jre1.5.0_14/lib/zi/Australia/Perth
jre1.5.0_14/lib/zi/Australia/Lord_Howe
jre1.5.0_14/lib/zi/Australia/Hobart
jre1.5.0_14/lib/zi/Australia/Currie
jre1.5.0_14/README
jre1.5.0_14/THIRDPARTYLICENSEREADME.txt
jre1.5.0_14/Welcome.html
....done
Creating sym link ...
....done
done
...done
Making symlinks in /etc/init.d and rc*.d ...
done

Done installation. 安装完成

NOTE: The user name created for SCMS-CM is scmscm. You may want to set a password for this account now.

[root@daybreak install-scripts]# passwd scmscm 设置scmscm密码
Changing password for user scmscm.
New UNIX password:
BAD PASSWORD: it does not contain enough DIFFERENT characters
Retype new UNIX password:
Sorry, passwords do not match
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully. 设置成功

 


[root@daybreak install-scripts]# su scmscm
[scmscm@daybreak install-scripts]$ cd /opt/cm/cm/bin/
[scmscm@daybreak bin]$ pwd
/opt/cm/cm/bin


设置时间

[scmscm@daybreak bin]$ ./jselect-sce-tz.sh --offset=480
TIME_STAMP| OFFSET_MIN|
------------------------+------------------------+
2011-07-02 12:06:01.133| 480|

[scmscm@daybreak bin]$ ./jselect-sce-tz.sh --status 检查设置时间
TIME_STAMP| OFFSET_MIN|
------------------------+------------------------+
2011-07-02 12:06:01.133| 480|

[scmscm@daybreak bin]$ date
Sat Jul 2 12:06:22 EDT 2011
[scmscm@daybreak bin]$ clock -w
Sorry, only the superuser can change the Hardware Clock.
[scmscm@daybreak bin]$ su
Password:
[root@daybreak bin]# clock -w 保存时间设置

[root@daybreak bin]# date
Sat Jul 2 12:06:55 EDT 2011
[root@daybreak bin]# su scmscm
[scmscm@daybreak bin]$
[scmscm@daybreak bin]$
[scmscm@daybreak bin]$ ls
clumain.sh cm cm.jar jselect-sce-tz.sh p3rpc p3stats update_vlinks.sh
[scmscm@daybreak bin]$ ./p3
p3rpc p3stats
[scmscm@daybreak bin]$ ./p3
p3rpc p3stats
[scmscm@daybreak bin]$ ./p3rpc --set-user --username=scmscm --password=scmscm123 设置用户名和密码


[scmscm@daybreak ~]$ cd setup/
[scmscm@daybreak setup]$ ls
alive.sh mbean.py on-boot.py scmscm sybase
common.sh monitor RUN_0_cm STOP_1_cm syb_interfaces.sh
[scmscm@daybreak setup]$ ./alive.sh 检查cm运行状态
STATUS OK
[scmscm@daybreak setup]$ ls
alive.sh mbean.py on-boot.py scmscm sybase
common.sh monitor RUN_0_cm STOP_1_cm syb_interfaces.sh
[scmscm@daybreak setup]$ cd ..
[scmscm@daybreak ~]$ ls
cm db_maint doc python scmscm.csh scmscm.sh scripts setup unsupported
[scmscm@daybreak ~]$ cd scripts/
[scmscm@daybreak scripts]$ ls
adapterconf.py dbconf.sh dbtables.sh rdr-rate.py sybrestore.sh
common.sh dbfree.sh droptable.sh sceconf.sh
csvconf.sh dbperiodic.py prunetable.sh sybback.sh
[scmscm@daybreak scripts]$ ./dbfree.sh 查看数据库使用情况
Name % Data Free % Log Free
---------------------- ----------- ----------
Database 99 99
[scmscm@daybreak scripts]$ ./dbtables.sh
Executing query ...
name| num_lines| min_time| max_time|
------------------------+------------------------+------------------------+------------------------+
RPT_SUR| 0| null| null|
RPT_LUR| 0| null| null|
RPT_VLUR| 0| null| null|
RPT_PUR| 0| null| null|
RPT_TR| 0| null| null|
RPT_MALUR| 0| null| null|
RPT_MEDIA| 0| null| null|
RPT_GUR| 0| null| null|
RPT_TOPS_PERIOD0| 0| null| null|
RPT_TOPS_PERIOD1| 0| null| null|
_TOPS_PERIOD0_CUMULATIVE| 0| null| null|
_TOPS_PERIOD1_CUMULATIVE| 0| null| null|

[scmscm@daybreak scripts]$ date
Sat Jul 2 12:14:44 EDT 2011
[scmscm@daybreak scripts]$ ./sceconf.sh --op=list 检查sce链接

IP Rate Peak
------------ ----------- -----------

Command terminated successfully
[scmscm@daybreak scripts]$ su
Password:
[root@daybreak scripts]#
[root@daybreak scripts]#
[root@daybreak scripts]#
[root@daybreak scripts]# netstat -an |grep 4100 检查数据库连接情况
tcp 0 0 127.0.0.1:4100 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.12:4100 0.0.0.0:* LISTEN 连接成功
tcp 0 0 127.0.0.1:4100 127.0.0.1:32850 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32854 ::ffff:127.0.0.1:4100 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32855 ::ffff:127.0.0.1:4100 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32850 ::ffff:127.0.0.1:4100 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32851 ::ffff:127.0.0.1:4100 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32863 ::ffff:127.0.0.1:4100 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32856 ::ffff:127.0.0.1:4100 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32857 ::ffff:127.0.0.1:4100 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32864 ::ffff:127.0.0.1:4100 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32865 ::ffff:127.0.0.1:4100 ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:32866 ::ffff:127.0.0.1:4100 ESTABLISHED
[root@daybreak scripts]# netstat -an |grep 33000 检查cm连接情况
tcp 0 0 :::33000 :::* LISTEN
[root@daybreak scripts]# su sybase
[sybase@daybreak scripts]$ cd /opt/sybase/
ASE-15_0/ DataAccess/ OCS-15_0/
ASE150.csh DBISQL/ RPL-15_0/
ASE150.env .gtkrc .scUserPreferences43
ASE150.sh interfaces shared/
ASEP/ interf.old SYBASE.csh
.bash_logout .java/ SYBASE.env
.bash_profile jConnect-6_0/ SYBASE.sh
.bashrc jutils-2_0/ SYSAM-2_0/
charsets/ _jvm/ UAF-2_0/
collate/ .kde/ uninstall/
config/ locales/ vpd.properties
data/ log.txt
[sybase@daybreak scripts]$ cd /opt/sybase/OCS-15_0/
[sybase@daybreak OCS-15_0]$ ls
bin devlib lib sample sybhelp
config include lib3p scripts xappdefaults
[sybase@daybreak OCS-15_0]$ cd bin/
[sybase@daybreak bin]$ pwd
/opt/sybase/OCS-15_0/bin
[sybase@daybreak bin]$ ls
bcp certpk12 cobpre_r dscp installjava pwdcrypt
bcp_r certreq defncopy dsedit isql sybhelp
certauth cobpre defncopy_r extractjava isql_r

进入syabase数据库，检查table是否完整

[sybase@daybreak bin]$ ./isql -S pqbsyb1 -Upqb_admin -Ppqb_admin
1> sp_help
2> go
Name Owner
Object_type
------------------------------------------------------ ----------
--------------------------------
sysquerymetrics dbo
(1 row affected)
User_type Storage_type Length Nulls
Default_name Rule_name
Access_Rule_name
------------------ ------------------------ ------------ ----------
------------------------ ------------------
--------------------------------

Class_name Jar_name
-------------------- ----------------

Jar_name
--------------------

(return status = 0)
1>
[1]+ Stopped ./isql -S pqbsyb1 -Upqb_admin -Ppqb_admin
[sybase@daybreak bin]$
 

由于这个是我在客户那里安装好了，回来在VMware上安装的，所以有在查看表格和sce设备是都是空的

 

此次编写是为了，广大好学网络技术人员学习和技术讨论，本人在网上安装是就没有找到相关文章，所以我安装完成后进行整理；望此文档对好网络技术人员有所帮助！