SYBASE FOR sun3500

 

1．sun3500描述：

Sun-nanhai 192.168.172.210

Ifconfig –a

如下：

lo0: flags=1000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4> mtu 8232 index 1

        inet 127.0.0.1 netmask ff000000

ge0: flags=1000863<UP,BROADCAST,NOTRAILERS,RUNNING,MULTICAST,IPv4> mtu 1500 index 2

        inet 192.168.172.210 netmask ffffff00 broadcast 192.168.172.255

        ether 8:0:20:e6:5c:8d

ge0:1: flags=1000863<UP,BROADCAST,NOTRAILERS,RUNNING,MULTICAST,IPv4> mtu 1500 index 2

        inet 192.168.172.214 netmask ffffff00 broadcast 192.168.172.255

hme0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 3

        inet 192.168.1.2 netmask ffffff00 broadcast 192.168.1.255

        ether 8:0:20:ac:f6:af

hme1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 4

        inet 192.168.2.2 netmask ffffff00 broadcast 192.168.2.255

        ether 8:0:20:ac:f6:af

/etc/hosts如下：

127.0.0.1       localhost

#192.168.172.211 nanhai nanhai.labour.gov.cn

#192.168.172.210 sun-nanhai     loghost

 

192.168.172.210 nanhaild       sun-nanhai      nanhaild.labour.gov.cn loghost

192.168.172.216 nanhai

 

192.168.172.214 NH2003

 

192.168.1.2     hananhai2

192.168.1.1     hananhai1

 

192.168.2.1     heartb1

192.168.2.2     heartb2

 

.profile文件描述如下：

# @(#)local.profile 1.8   99/03/26 SMI

stty istrip

PATH=/usr/bin:/usr/ucb:/etc:.

export PATH

 

#

# If possible, start the windows system

#

if [ "`tty`" = "/dev/console" ] ; then

       if [ "$TERM" = "sun" -o "$TERM" = "sun-color" -o "$TERM" = "AT386" ]

       then

 

              if [ ${OPENWINHOME:-""} = "" ] ; then

                     OPENWINHOME=/usr/openwin

                     export OPENWINHOME

              fi

 

              echo ""

              echo "Starting OpenWindows in 5 seconds (type Control-C to interrupt)"

              sleep 5

              echo ""

              $OPENWINHOME/bin/openwin

 

              clear              # get rid of annoying cursor rectangle

              exit         # logout after leaving windows system

 

       fi

fi

#. /sybase/SYBASE.sh

SYBASE=/sybase

export SYBASE

SYBASE_FTS=FTS-12_0

export SYBASE_FTS

PATH=/sybase/ASE-12_0/bin:/sybase/OCS-12_0/bin:$PATH

export PATH

SYBASE_OCS=OCS-12_0

export SYBASE_OCS

SYBASE_ASE=ASE-12_0

export SYBASE_ASE

LM_LICENSE_FILE=/sybase/SYSAM-1_0/licenses/license.dat:$LM_LICENSE_FILE

export LM_LICENSE_FILE

LD_LIBRARY_PATH=/sybase/ASE-12_0/lib:/usr/local/openwin/lib:/sybase/FTS-12_0/lib:/sybase/OCS-12_0/lib:/usr/local/openwin/lib:/usr/lib:/sybase/SQLRemote/lib:$LD_LIBRARY_PATH

export LD_LIBRARY_PATH

SYBASE_SYSAM=SYSAM-1_0

export SYBASE_SYSAM

DSQUERY=hgd

export DSQUERY

DISPLAY=192.168.172.210:0.0

export DISPLAY

LANG=C

export LANG

10.168.77.136的/etc/system

set shmsys:shminfo_shmmax=200000000

set shmsys:shminfo_shmseg=8

 

Nanhai      192.168.172.215

客户端连接192.168.172.214 NH2003 映射为10.168.77.136

两组心跳线：

192．168．1．1

192．168．1．2

 

192．168．2．1

192．168．2．2

 

相关命令：

tar -cvf bea.tar /bea

Tar –cvf X.tar /Sybase

Tar –vxf X.tar

tar tvf usr.tar | more

Route add default 网关     添加缺省网关

Route add 网段 网关

Etc/defaultroute 网关IP

Ifconfig ge0 地址1 掩码 地址2

 

 

Roseha安装目录：

/opt/roseha    ./gui.sh 客户端

Sybase服务在/opt/roseha/bin下的两个sh脚本控制sybase服务启动和停止

 

Veritas volume manager相关命令：

Mount 磁盘

Vxdg list 查看磁盘

在停止sybase服务后可以umount /Sybase

datadg由deport状态变为import状态之后：

mount /dev/vx/dsk/datadg/vol01 /sybase

Vxdg deport datadg 逐出

Vxdg import datadg 导入

 

Recover datadg 恢复

 

/opt/VRTSvmsa/bin/vmsa   管理工具

 

 

Sybase用户安装目录：

/usr/sybase0

相关重要文件：.profile

劳动数据库nanhai数据和日志文件所在目录：

/usr/data_bak

Labor数据库数据和日志文件所在目录：

/Sybase/data

 

 

劳动信息系统数据备份目录：/export/home&&/sybase/labor_data_bak

清除数据库日志：

dump transaction nanhai with no_log

dump transaction nanhai with truncate_only

 

备份数据库：

dump database nanhai to “/sybase/labor_data_bak/2004-02-17-11”

 

 

 

 

 

 

Ps –aux 可以详细的显示当前进程情况

/usr/local/apache/bin/httpd

 

 

Solaris系统的cron.deny所在路径为/etc/cron.d

用户所建立的crontab文件存于/var/spool/cron/crontabs

 

备份sybase数据库（在工作日每天的23：00备份数据）crontab -e

0 23 * * 2 su - sybase0 -c “/sybase/OCS-12_0/bin/isql -Usa -P -Shgd -i /usr/sybase0/dump2.sql”

 

 

先清除数据库日志，再备份数据库

dump transaction nanhai with truncate_only

go

 

dump database nanhai to "/sybase/labor_data_bak/2004labor03"/*备份从最近一周内的数据*/

go

如果表存在就用insert……select 如果表不存在就用select into

select into LCC05NEW from LCC05

sp_dboption nanhai,“select into/bulkcopy/pllsort”,”true”