license类型与server配置不匹配导致SybaseASE无法启动

一天,为了忙着下班,就没有将虚拟机的SYBASE ASE 没有关掉服务,也就是停掉数据库,就只是直接在系统层执行poweroff ,第二天,想着继续研究SYBASE,但却发现,无法启动sybase,sybase起不来啦。

查看日志,有如下信息:

————
00:00000:00000:2011/02/10 11:44:45.58 kernel SySAM: Using licenses from: D:\sybase\\SYSAM-2_0\licenses
00:00000:00000:2011/02/10 11:44:45.71 kernel SySAM: Failed to obtain 1 license(s) for ASE_CORE feature from license file(s) or server(s).
00:00000:00000:2011/02/10 11:44:45.71 kernel SySAM: Licenses exist for ASE, but a license containing the configured (PE=EE;LT=SR) attributes could not be obtained. Verify that ASE is configured to use the correct type of license, and either reconfigure; or generate and deploy the desired license from the Sybase Product Download Center.
00:00000:00000:2011/02/10 11:44:45.71 kernel SySAM: License feature name: ASE_CORE
00:00000:00000:2011/02/10 11:44:45.71 kernel SySAM: License search path: D:\sybase\\SYSAM-2_0\licenses\ANY_201101120518.lic;D:\sybase\\SYSAM-2_0\licenses\ANY_201101120519.lic;
00:00000:00000:2011/02/10 11:44:45.71 kernel SySAM: FLEXnet Licensing error:-73,125
00:00000:00000:2011/02/10 11:44:45.71 kernel SySAM: For further information, refer to the Sybase Software Asset Management website at http://www.sybase.com/sysam
00:00000:00000:2011/02/10 11:44:45.71 kernel There is no valid license for ASE server product. Installation date is not found or installation grace period has expired. Server will not boot.
———–

提示没有有效的license。俺安装的是sybase15.7的开发版,应该不会存在lic问题。

阅读更多

Linux 下静默式创建与安装数据实例 方法

静默安装数据库实例 (在oracle 用户安装)
在这里需要配置静默安装数据库响应的模板文件,也是在安装软件包中解压在database下的response 目录下的dbca_rsp 文件,具体配置如下:
[oracle@localhost response]# vim dbca.rsp
[GENERAL]
RESPONSEFILE_VERSION = “11.2.0”
OPERATION_TYPE = “createDatabase”
[CREATEDATABASE]
GDBNAME = “lanmao” #全局数据库的名字
SID = “orcl” # 数据库实例,根据上面的你写的SID 一样的,随便写。
TEMPLATENAME = “General_Purpose.dbc” # 这个可以是默认的模板,不会写默认的,最好是默认,
这里是我们dba 写的,所以就用上。
SYSPASSWORD = “2011@oracle”
SYSTEMPASSWORD = “2011@oracle”
SYSMANPASSWORD = “2011@oracle”
DBSNMPPASSWORD = “2011@oracle” # 前面这四个都可以不管,默认就行
CHARACTERSET = “ZHS16GBK” #编码
NATIONALCHARACTERSET=“UTF8” #编码
[createTemplateFromDB]
SOURCEDB = “myhost:1521:orcl”
SYSDBAUSERNAME = “system”
TEMPLATENAME = “My Copy TEMPLATE”
[createCloneTemplate]
SOURCEDB = “orcl”
TEMPLATENAME = “My Clone TEMPLATE”
[DELETEDATABASE]
SOURCEDB = “orcl”
[generateScripts]
TEMPLATENAME = “New Database”
GDBNAME = “orcl11.us.oracle.com”
[CONFIGUREDATABASE]
[ADDINSTANCE]
DB_UNIQUE_NAME = “orcl11g.us.oracle.com”
NODELIST=
SYSDBAUSERNAME = “sys”
[DELETEINSTANCE]
DB_UNIQUE_NAME = “orcl11g.us.oracle.com”
INSTANCENAME = “orcl11g”
SYSDBAUSERNAME = “sys”

阅读更多

Linux下静默安装 Oracle11gr2

1.操作系统及oracle版本
Linux版本:CentOS release 6.5
Oracle版本:1.ORACLE11G
2.linux.x64_11gR2
2.硬件检测
物理内存不少于1G
硬盘可以空间不少于5G
Sqap分区空间不少于2G
支持256色以上显卡
Cpu主频不少于550mHZ

cat /etc/issue —查看linux系统
Uanme -r
Grep MemTotal /proc/meminfo
Grep SwapTotal /proc/meminfo
Grep “model name” /proc/cpuinfo
Free
df -k /tmp

3.检查安装依赖系统包
操作系统依赖的具体包,请参考官方安装文档。
以下为 Asianux 3, Oracle Linux 5, Red Hat Enterprise Linux 5, CentOS 5 操作系统依赖的包
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
sysstat-7.0.2
unixODBC-2.2.11 (32-bit) or later
unixODBC-devel-2.2.11 (64-bit) or later
unixODBC-2.2.11 (64-bit) or later
检查依赖包
rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc-2.5 glibc-common glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel
如果包有显示is not installed(没安装),就用yum install 命令安装,如:
yum install compat-libstdc++-33

4.创建所需的操作系统组和用户
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
设置oracle用户密码
passwd oracle

阅读更多