淄博市建设工程质量协会网站,wordpress 插件 升级,wordpress流程,家庭装修公司最近比较忙#xff0c;比较烦#xff0c;不想说话#xff0c;想打人#xff0c;想发脾气了#xff1b; 这几天比较累#xff0c;相当的累#xff0c;这两个星期什么都不顺心#xff0c;心情也很低落 这两个星期维护的移动、广电网络都出现问题了#xff0c;o(︶︿︶)o… 最近比较忙比较烦不想说话想打人想发脾气了 这几天比较累相当的累这两个星期什么都不顺心心情也很低落 这两个星期维护的移动、广电网络都出现问题了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是否安装正确 [rootlocalhost share]# rpm -q -a |grep vsftpd vsftpd-2.0.1-8.el4 [rootlocalhost 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.shmmax536870912 /etc/sysctl.conf //在redhat上最大共享内存不建议超过4*1024*1024*1024-14294967295 这个更改在系统重新启动后生效。若不设置该参数在安装Sybase数据库时会出现错误 设备host文件 [rootlocalhost 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软件打包 rootlocalhost 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 [rootlocalhost 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 [rootlocalhost 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 [rootlocalhost 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 [rootlocalhost sce]# cd install-scripts/ [rootlocalhost 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的安装条件 [rootlocalhost 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 NICs [Success] IP Address 192.168.0.12 is resolvable through /etc/hosts [Success] IP Address 127.0.0.1 is resolvable through /etc/hosts [rootlocalhost install-scripts]# echo kernel.shmmax536870912 /etc/sysctl.conf 设置共享内存 现在我们需要把设备reboot下了啦这样设置的一些参数才可以生效的 二、install sybase database [rootdaybreak ~]# [rootdaybreak ~]# [rootdaybreak ~]# cd /etc/sysc sysconfig/ sysctl.conf [rootdaybreak ~]# 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.shmmax536870912 [rootdaybreak ~]# cd /home/sce/install-scripts/ [rootdaybreak 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 NICs [Success] IP Address 192.168.0.12 is resolvable through /etc/hosts [Success] IP Address 127.0.0.1 is resolvable through /etc/hosts [rootdaybreak sybase]# ./installsyb.sh [rootdaybreak sybase]# Starting Sybase install sequence Must specify Sybase home Usage: installsyb.sh --sybhomeSYBHOME --datadirDATADIR [ --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) [rootdaybreak 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 [rootdaybreak sybase]# pwd /home/sce/sybase [rootdaybreak sybase]# cd .. [rootdaybreak sce]# cd install-scripts/ [rootdaybreak 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 [rootdaybreak install-scripts]# ./check_syb.sh 检查数据库的安装 Sybase is properly installed and configured [rootdaybreak install-scripts]# cd .. [rootdaybreak sce]# cd install-scripts/ cm文件夹不需要创建否则出错 [rootdaybreak install-scripts]# ./install-cm.sh -d /opt/cm verify_dir: /opt/cm already exists Error - ./install-cm.sh - directory /opt/cm problem - exiting [rootdaybreak install-scripts]# rm /opt/cm rm: cannot remove directory /opt/cm: Is a directory [rootdaybreak install-scripts]# rmdir /opt/cm 安装cm [rootdaybreak 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. [rootdaybreak 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. 设置成功 [rootdaybreak install-scripts]# su scmscm [scmscmdaybreak install-scripts]$ cd /opt/cm/cm/bin/ [scmscmdaybreak bin]$ pwd /opt/cm/cm/bin 设置时间 [scmscmdaybreak bin]$ ./jselect-sce-tz.sh --offset480 TIME_STAMP| OFFSET_MIN| ------------------------------------------------ 2011-07-02 12:06:01.133| 480| [scmscmdaybreak bin]$ ./jselect-sce-tz.sh --status 检查设置时间 TIME_STAMP| OFFSET_MIN| ------------------------------------------------ 2011-07-02 12:06:01.133| 480| [scmscmdaybreak bin]$ date Sat Jul 2 12:06:22 EDT 2011 [scmscmdaybreak bin]$ clock -w Sorry, only the superuser can change the Hardware Clock. [scmscmdaybreak bin]$ su Password: [rootdaybreak bin]# clock -w 保存时间设置 [rootdaybreak bin]# date Sat Jul 2 12:06:55 EDT 2011 [rootdaybreak bin]# su scmscm [scmscmdaybreak bin]$ [scmscmdaybreak bin]$ [scmscmdaybreak bin]$ ls clumain.sh cm cm.jar jselect-sce-tz.sh p3rpc p3stats update_vlinks.sh [scmscmdaybreak bin]$ ./p3 p3rpc p3stats [scmscmdaybreak bin]$ ./p3 p3rpc p3stats [scmscmdaybreak bin]$ ./p3rpc --set-user --usernamescmscm --passwordscmscm123 设置用户名和密码 [scmscmdaybreak ~]$ cd setup/ [scmscmdaybreak setup]$ ls alive.sh mbean.py on-boot.py scmscm sybase common.sh monitor RUN_0_cm STOP_1_cm syb_interfaces.sh [scmscmdaybreak setup]$ ./alive.sh 检查cm运行状态 STATUS OK [scmscmdaybreak setup]$ ls alive.sh mbean.py on-boot.py scmscm sybase common.sh monitor RUN_0_cm STOP_1_cm syb_interfaces.sh [scmscmdaybreak setup]$ cd .. [scmscmdaybreak ~]$ ls cm db_maint doc python scmscm.csh scmscm.sh scripts setup unsupported [scmscmdaybreak ~]$ cd scripts/ [scmscmdaybreak 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 [scmscmdaybreak scripts]$ ./dbfree.sh 查看数据库使用情况 Name % Data Free % Log Free ---------------------- ----------- ---------- Database 99 99 [scmscmdaybreak 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| [scmscmdaybreak scripts]$ date Sat Jul 2 12:14:44 EDT 2011 [scmscmdaybreak scripts]$ ./sceconf.sh --oplist 检查sce链接 IP Rate Peak ------------ ----------- ----------- Command terminated successfully [scmscmdaybreak scripts]$ su Password: [rootdaybreak scripts]# [rootdaybreak scripts]# [rootdaybreak scripts]# [rootdaybreak 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 [rootdaybreak scripts]# netstat -an |grep 33000 检查cm连接情况 tcp 0 0 :::33000 :::* LISTEN [rootdaybreak scripts]# su sybase [sybasedaybreak 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 [sybasedaybreak scripts]$ cd /opt/sybase/OCS-15_0/ [sybasedaybreak OCS-15_0]$ ls bin devlib lib sample sybhelp config include lib3p scripts xappdefaults [sybasedaybreak OCS-15_0]$ cd bin/ [sybasedaybreak bin]$ pwd /opt/sybase/OCS-15_0/bin [sybasedaybreak 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是否完整 [sybasedaybreak 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 [sybasedaybreak bin]$ 由于这个是我在客户那里安装好了回来在VMware上安装的所以有在查看表格和sce设备是都是空的 此次编写是为了广大好学网络技术人员学习和技术讨论本人在网上安装是就没有找到相关文章所以我安装完成后进行整理望此文档对好网络技术人员有所帮助 转载于:https://blog.51cto.com/hyperbin/602131
