Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ASE15.X init script

3 posts in General Discussion Last posting was on 2010-01-07 18:40:24.0Z
hiro Posted on 2010-01-05 16:35:48.0Z
From: hiro <hiroysato@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: ASE15.X init script
Date: Tue, 5 Jan 2010 08:35:48 -0800 (PST)
Organization: http://groups.google.com
Lines: 127
Message-ID: <e655ac14-d4b3-4989-a09e-5e003af20b21@a21g2000yqc.googlegroups.com>
NNTP-Posting-Host: 211.19.98.177
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1262709348 14257 127.0.0.1 (5 Jan 2010 16:35:48 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 5 Jan 2010 16:35:48 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a21g2000yqc.googlegroups.com; posting-host=211.19.98.177; posting-account=IEn8rgoAAACMLW-fH7jZGmn6B_AGW-5l
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_8; ja-jp) AppleWebKit/531.21.8 (KHTML, like Gecko) Version/4.0.4 Safari/531.21.10,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!a21g2000yqc.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28827
Article PK: 78069

Dear Sybase Guru.

Does anybody know AES 15.x on linux 32bit platform.

The following script modified for ASE12.5.x init script
but cause segmentation fault.

however the following step is work fine.

# su - sybase
% . /usr/sybase/SYBASE.sh
% cd /usr/sybase/ASE-15_0/install/
% ./startserver -f RUN_SYBASE

I don't know what is the problem.

Version
Adaptive Server Enterprise/15.0.3/EBF 16743 ESD#2/P/Linux Intel/Linux
2.6.9-42.ELsmp i686/ase1503/2707/32-bit/FBO/Sun Jul 26 23:03:48 2009

Sincerely



#!/bin/sh
#
# sybase: Starts the available Servers
#
# Version: @(#) /etc/rc.d/init.d/sybase 1.2
#
# chkconfig: 345 85 15
#
# description: This script will browse through the /opt/sybase/install
# directory and launch all servers configured from this
location.

# Source function library.
. /etc/rc.d/init.d/functions

# SYBASE should point to the system administrated server area
#

export LANG=C

if [ -f /usr/sybase/SYBASE.sh ] ; then
. /usr/sybase/SYBASE.sh
fi



#
# Sybase Product Environment variables
#

#
# avoid backupserver cause segmentation fault
#
ulimit -s unlimited
export LD_POINTER_GUARD=0


if [ -n "${SYBASE}" -a -d "${SYBASE}" ]; then

# See how we were called.
case "$1" in
start)

echo -n "Starting Sybase ASE ... "
( cd ${SYBASE}/${SYBASE_ASE}/install ; unset LANG ;
unset LC_ALL ;
for run_server in RUN_* ; do
su -c "startserver -f ${run_server}" sybase > /dev/null
2>&1
echo -n "${run_server} " ; done )
echo

touch /var/lock/subsys/sybase
;;

stop)
echo -n "Shuting down Sybase ASE configured servers: "
killproc dataserver
killproc backupserver
killproc monserver

# Add your own openserver applications.
echo
;;

status)
showserver
;;

restart)
$0 stop
$0 start
;;
*)
echo "*** Usage: sybase {start|stop|status|restart}"
exit 1
esac

fi

exit 0


00:00000:00000:2010/01/06 01:11:04.56 kernel Using config area from
primary master device.
00:00000:00000:2010/01/06 01:11:04.57 kernel os_create_keyfile:
Removed old segment /usr/sybase/ASE-15_0/CHEETAH.krg
00:00000:00000:2010/01/06 01:11:04.57 kernel Could not allocate
memory using Huge Pages. Allocated using regular pages. For better
performance, reboot the server after configuring enough Huge Pages.
00:00000:00000:2010/01/06 01:11:04.57 kernel Could not allocate
memory using Huge Pages. Allocated using regular pages. For better
performance, reboot the server after configuring enough Huge Pages.
00:00000:00000:2010/01/06 01:11:04.57 kernel Attempt to attach shared
memory (id 1081345) at address (nil), with flags 0 failed
00:00000:00000:2010/01/06 01:11:04.57 kernel Cannot attach shared
memory : error = 12 (Cannot allocate memory)
00:00000:00000:2010/01/06 01:11:04.57 kernel os_create_region: shmat
(1081345): Cannot allocate memory
00:00000:00000:2010/01/06 01:11:04.57 kernel kbcreate: couldn't
create server region 0.
00:00000:00000:2010/01/06 01:11:04.57 kernel kistartup: could not
create shared memory


Michael Peppler [Team Sybase] Posted on 2010-01-06 05:55:17.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: ASE15.X init script
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2010.01.06.05.55.13.873206@peppler.org>
Newsgroups: sybase.public.ase.general
References: <e655ac14-d4b3-4989-a09e-5e003af20b21@a21g2000yqc.googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 5 Jan 2010 21:55:17 -0800
X-Trace: forums-1-dub 1262757317 10.22.241.152 (5 Jan 2010 21:55:17 -0800)
X-Original-Trace: 5 Jan 2010 21:55:17 -0800, vip152.sybase.com
Lines: 53
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28829
Article PK: 78071


On Tue, 05 Jan 2010 08:35:48 -0800, hiro wrote:

> Dear Sybase Guru.
>
> Does anybody know AES 15.x on linux 32bit platform.
>
> The following script modified for ASE12.5.x init script
> but cause segmentation fault.
>
> however the following step is work fine.
>
> # su - sybase
> % . /usr/sybase/SYBASE.sh
> % cd /usr/sybase/ASE-15_0/install/
> % ./startserver -f RUN_SYBASE
>
> I don't know what is the problem.
>
> Version
> Adaptive Server Enterprise/15.0.3/EBF 16743 ESD#2/P/Linux Intel/Linux
> 2.6.9-42.ELsmp i686/ase1503/2707/32-bit/FBO/Sun Jul 26 23:03:48 2009

I see you are setting LD_POINTER_GUARD - which version of linux are you
using?

>
> 00:00000:00000:2010/01/06 01:11:04.56 kernel Using config area from
> primary master device.
> 00:00000:00000:2010/01/06 01:11:04.57 kernel os_create_keyfile:
> Removed old segment /usr/sybase/ASE-15_0/CHEETAH.krg
> 00:00000:00000:2010/01/06 01:11:04.57 kernel Could not allocate
> memory using Huge Pages. Allocated using regular pages. For better
> performance, reboot the server after configuring enough Huge Pages.
> 00:00000:00000:2010/01/06 01:11:04.57 kernel Could not allocate
> memory using Huge Pages. Allocated using regular pages. For better
> performance, reboot the server after configuring enough Huge Pages.
> 00:00000:00000:2010/01/06 01:11:04.57 kernel Attempt to attach shared
> memory (id 1081345) at address (nil), with flags 0 failed
> 00:00000:00000:2010/01/06 01:11:04.57 kernel Cannot attach shared
> memory : error = 12 (Cannot allocate memory)
> 00:00000:00000:2010/01/06 01:11:04.57 kernel os_create_region: shmat
> (1081345): Cannot allocate memory
> 00:00000:00000:2010/01/06 01:11:04.57 kernel kbcreate: couldn't
> create server region 0.
> 00:00000:00000:2010/01/06 01:11:04.57 kernel kistartup: could not
> create shared memory

That looks like a completely different problem - the shmmax kernel setting
appears to be set too low.

Michael


hiro Posted on 2010-01-07 18:40:24.0Z
From: hiro <hiroysato@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: ASE15.X init script
Date: Thu, 7 Jan 2010 10:40:24 -0800 (PST)
Organization: http://groups.google.com
Lines: 167
Message-ID: <027de402-b1d8-4495-b146-e61a75f0a987@l30g2000yqb.googlegroups.com>
References: <e655ac14-d4b3-4989-a09e-5e003af20b21@a21g2000yqc.googlegroups.com> <pan.2010.01.06.05.55.13.873206@peppler.org>
NNTP-Posting-Host: 211.19.98.177
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1262889624 1717 127.0.0.1 (7 Jan 2010 18:40:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 7 Jan 2010 18:40:24 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: l30g2000yqb.googlegroups.com; posting-host=211.19.98.177; posting-account=IEn8rgoAAACMLW-fH7jZGmn6B_AGW-5l
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_8; ja-jp) AppleWebKit/531.21.8 (KHTML, like Gecko) Version/4.0.4 Safari/531.21.10,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeed.news2me.com!newsfeed2.telusplanet.net!newsfeed.telus.net!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!l30g2000yqb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28844
Article PK: 78085

Hi Michael

Thank your for your information.

On 1月6日, 午後2:55, "Michael Peppler [Team Sybase]"

<mpepp...@peppler.org> wrote:
> On Tue, 05 Jan 2010 08:35:48 -0800, hiro wrote:
> > Dear Sybase Guru.
>
> >  Does anybody know AES 15.x on linux 32bit platform.
>
> > The following script modified for ASE12.5.x init script
> > but cause segmentation fault.
>
> > however the following step is work fine.
>
> > # su - sybase
> > % . /usr/sybase/SYBASE.sh
> > % cd /usr/sybase/ASE-15_0/install/
> > % ./startserver -f RUN_SYBASE
>
> > I don't know what is the problem.
>
> > Version
> > Adaptive Server Enterprise/15.0.3/EBF 16743 ESD#2/P/Linux Intel/Linux
> > 2.6.9-42.ELsmp i686/ase1503/2707/32-bit/FBO/Sun Jul 26 23:03:48 2009
>
> I see you are setting LD_POINTER_GUARD - which version of linux are you
> using?
>

I'm using CentOS5.4 (RHEL5.4)


>
>
>
>
>
>
> > 00:00000:00000:2010/01/06 01:11:04.56 kernel  Using config area from
> > primary master device.
> > 00:00000:00000:2010/01/06 01:11:04.57 kernel  os_create_keyfile:
> > Removed old segment /usr/sybase/ASE-15_0/CHEETAH.krg
> > 00:00000:00000:2010/01/06 01:11:04.57 kernel  Could not allocate
> > memory using Huge Pages. Allocated using regular pages. For better
> > performance, reboot the server after configuring enough Huge Pages.
> > 00:00000:00000:2010/01/06 01:11:04.57 kernel  Could not allocate
> > memory using Huge Pages. Allocated using regular pages. For better
> > performance, reboot the server after configuring enough Huge Pages.
> > 00:00000:00000:2010/01/06 01:11:04.57 kernel  Attempt to attach shared
> > memory (id 1081345) at address (nil), with flags 0 failed
> > 00:00000:00000:2010/01/06 01:11:04.57 kernel  Cannot attach shared
> > memory : error = 12 (Cannot allocate memory)
> > 00:00000:00000:2010/01/06 01:11:04.57 kernel  os_create_region: shmat
> > (1081345): Cannot allocate memory
> > 00:00000:00000:2010/01/06 01:11:04.57 kernel  kbcreate: couldn't
> > create server region 0.
> > 00:00000:00000:2010/01/06 01:11:04.57 kernel  kistartup: could not
> > create shared memory
>
> That looks like a completely different problem - the shmmax kernel setting
> appears to be set too low.

The default shmmax value of CentOS (RHEL) is the following.
This is default value.

# /sbin/sysctl -a | grep shm
kernel.shmmni = 4096
kernel.shmall = 268435456
kernel.shmmax = 4294967295

After this question, I tried the following scripts.
This script worked fine.

The difference is here

Good
# not set ulimit
# ulimit -s unlimited


% ulimit -s
10240

BAD
# set ulimit
ulimit -s unlimited

% ulimit -s
unlimited

I don't know why
I set ulimit because I read the following article.
http://dbaspot.com/forums/sybase/365175-starting-multiple-engines-rhel5-ase-15-0-2-a.html

#!/bin/sh
# sybase: Starts the available Servers
#
# Version: @(#) /etc/rc.d/init.d/sybase 1.2
#
# chkconfig: 345 85 15
#
# description: This script will browse through the /opt/sybase/install
# directory and launch all servers configured from this
location.
#
. /etc/rc.d/init.d/functions

export SYBASE="/usr/sybase"

#export LD_POINTER_GUARD=0
#ulimit -s unlimited
. /usr/sybase/SYBASE.sh

if [ -n "${SYBASE}" -a -d "${SYBASE}" ]; then

SYBASE_ASE=ASE-15_0
SYBASE_OCS=OCS-15_0
PATH="${SYBASE}/${SYBASE_ASE}/bin:${SYBASE}/${SYBASE_OCS}:${SYBASE}/$
{SYBASE_ASE}/install:${PATH}"
export SYBASE SYBASE_ASE SYBASE_OCS PATH

case "$1" in
start)
echo -n "Starting Sybase ASE ... "
( cd ${SYBASE}/${SYBASE_ASE}/install ; unset LANG ;
unset LC_ALL ;
for run_server in RUN_* ; do su -c "startserver -f $
{run_server}" sybase > /dev/null 2>&1 ; echo -n "$
{run_server} " ; done )
echo

touch /var/lock/subsys/sybase
;;

stop)
echo -n "Shuting down Sybase ASE configured servers: "
killproc dataserver
killproc backupserver
killproc monserver

echo
;;

status)
showserver
;;

restart)
$0 stop
$0 start
;;
*)
echo "*** Usage: sybase {start|stop|status|restart}"
exit 1
esac

fi

exit 0