为什么SAP ECC的系统,数据库总是和SAP的应用安装在一起
SAP PI服务器,版本731 SYBASE数据库运维故障解决2粒
中午解决一粒SYBASE数据库故障,得益于网上能查到部分资料。我也描述一下,也许其它管理员会用到。
环境:
AIX7 SAP-ECC6 SYBASE12.5
数据库无法启动报错:
00:0000:00000:00000:2019/06/18 13:33:43.03 kernel SySAM: Using licenses from: /sybase/ED2/SYSAM-2_0/licenses/SYBASE.lic:/sybase/ED2/SYSAM-2_0/licenses/SYBASE_ASE_DE.lic
00:0000:00000:00000:2019/06/18 13:33:43.04 kernel SySAM: Checked out license for 4 ASE_CORE (2014.1231/permanent/1296 8FE3 0A83 A167).
00:0000:00000:00000:2019/06/18 13:33:43.04 kernel This product is licensed to: SAP, for use with SAP Business Applications.
00:0000:00000:00000:2019/06/18 13:33:43.04 kernel Checked out license ASE_CORE
00:0000:00000:00000:2019/06/18 13:33:43.04 kernel Adaptive Server Enterprise (Enterprise Edition)
00:0000:00000:00000:2019/06/18 13:33:43.05 kernel Using config area from primary master device.
00:0000:00000:00000:2019/06/18 13:33:43.06 kernel SySAM: Checked out license for 4 ASE_PARTITIONS (2014.1231/permanent/1296 8FE3 0A83 A167).
00:0000:00000:00000:2019/06/18 13:33:43.06 kernel Checked out license ASE_PARTITIONS
00:0000:00000:00000:2019/06/18 13:33:43.06 kernel SySAM: Checked out license for 4 ASE_COMPRESSION (2014.1231/permanent/1296 8FE3 0A83 A167).
00:0000:00000:00000:2019/06/18 13:33:43.06 kernel Checked out license ASE_COMPRESSION
00:0000:00000:00000:2019/06/18 13:33:43.07 kernel SySAM: Checked out license for 4 ASE_ASM (2014.1231/permanent/1296 8FE3 0A83 A167).
00:0000:00000:00000:2019/06/18 13:33:43.07 kernel Checked out license ASE_ASM
00:0000:00000:00000:2019/06/18 13:33:43.07 kernel os_find_good_keyfile: Could not open file /sybase/ED2/ASE-15_0/ED2.krg: File exists
00:0000:00000:00000:2019/06/18 13:33:43.07 kernel kbcreate: couldn't get shmid for kernel region.
00:0000:00000:00000:2019/06/18 13:33:43.07 kernel kistartup: could not create shared memory
场景描述:
SYBASE数据库日志满,导致数据库故障。管理员杀掉进程服务,导致数据库锁文件产生。
然后无法再次启动数据库。
解决办法:
对锁文件 ED2.krg 改名,数据库启动时没有锁文件限制,可以正常启动。
每一次启动都会清空日志文件,日志也不需要手动清理了。