Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006

    Exclamation Unanswered: HELP! can not start sql server

    When I restart my ASE125, it failed, in Errorlog, I found the following word:
    "Invalid Configuration: Unable to start SQL Server since the defined cache
    configuration consumes more memory than is available for buffer caches.
    The server may be started with a default configuration using the -c
    startserver option."
    anybody help me very thanks!

  2. #2
    Join Date
    Jan 2003
    Geneva, Switzerland
    Edit the configuration file (in $SYBASE/$SYBASE_ASE/<servername>.cfg) and reduce the size of the caches. The cache definition entries look like this

    [Named Cache:default data cache]
    cache size = DEFAULT
    cache status = default data cache
    cache replacement policy = DEFAULT
    local cache partition number = DEFAULT

    although in this case the values are set to DEFAULT, rather than some user defined amount. The size values are in logical pages (i.e. 2k units), so 512 means one meg.


  3. #3
    Join Date
    Jan 2006

    I defined it as default

    I changed my define to Default, but start server failed again, what's wrong?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts