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
”