cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase 12 can't start up

Edgar Alejandro
Occasional Visitor

Sybase 12 can't start up

I had those errors everytime that I want to start a dataserver up

thanks
before all
00:00000:00005:2002/02/22 18:56:31.40 server Cannot allocate a gtrid object descriptor. Retry later, or a user with System Administrator (SA) role to reconfigure your system for more total memory.
"think in the incredible and take a chance of the impossible"
3 REPLIES
Andreas D. Skjervold
Honored Contributor

Re: Sybase 12 can't start up

Hi

Wild guess: Increase your shmmax parameter setting equal to physical memory...

Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Dennis J Robinson
Frequent Advisor

Re: Sybase 12 can't start up

Looks like your buffer pools are setup too big for amount of physical memory on the box.

You need to shrink your buffer pools so that when dataserver is up that there is some memory left over on the box.

Let see the entire errorlog when you try to startup, also the config file.

Thanks,

Dennis J Robinson
You know the drill
Mike Hassell
Respected Contributor

Re: Sybase 12 can't start up

Edgar,

I know you're working with Sybase ASE 12, however the following tech doc from Sybase may give you some idea of what is going wrong:

http://my.sybase.com/detail?id=20101

There are two things that come into play here:

1. Kernel paramters that effect shared memory (SHMAX, etc.)
2. Enabling the dataserver binary to utilize a large amount of shared memory.

Use the following syntax to enable the dataserver binary to utilize large amounts of shared memory:

/usr/bin/chatr -M $SYBASE/bin/dataserver

Take the value given in your sybase config file for 'total memory' and multiply this by 2048 to determine how many bytes of memory you are trying to give to Sybase and then ensure that your kernel parameters are set high enough to meet this setting. If you are using more than 1.75GB, than use 'chatr' on the binary and you should be set.

If you have any other problems, read up on the install procedures found here:

http://manuals.sybase.com/onlinebooks/group-as/asg1200e/@Generic__CollectionView;pt=asg1192e

Hope that helps.

-Mike
The network is the computer, yeah I stole it from Sun, so what?