Operating System - HP-UX
1753736 Members
4399 Online
108799 Solutions
New Discussion юеВ

Re: sysbase cannot startup,

 
hua_1
Frequent Advisor

sysbase cannot startup,

sybase cannot startup.
here is the beginning of the eroor message:

2004/06/17 17:28:33.88 kernel Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2004/06/17 17:28:41.56 kernel Using config area from primary master device.
00:00000:00000:2004/06/17 17:28:41.56 server Configuration Error: Configuration file, '/home/sybase/SQ97.cfg', does not exist.
00:00000:00000:2004/06/17 17:28:41.56 kernel Warning: A configuration file was not specified and the default file '/home/sybase/SQ97.cfg' does not exist. SQL Server creates the default file with the default configuration.
00:00000:00000:2004/06/17 17:28:41.57 kernel Warning: Using default file '/home/sybase/SQ97.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2004/06/17 17:28:41.81 kernel Using 1024 file descriptors.
00:00000:00000:2004/06/17 17:28:41.81 kernel Adaptive Server Enterprise/12.5.0.3/EBF 11447 ESD#4/P/HP9000-879/HP-UX 11.0/rel12503/1939/64-bit/FBO/Sun Sep 21 06:02:05 2003
00:00000:00000:2004/06/17 17:28:41.81 kernel Confidential property of Sybase, Inc.
00:00000:00000:2004/06/17 17:28:41.81 kernel Copyright 1987, 2003
00:00000:00000:2004/06/17 17:28:41.81 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2004/06/17 17:28:41.81 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/06/17 17:28:41.81 kernel
00:00000:00000:2004/06/17 17:28:41.81 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/06/17 17:28:41.81 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2004/06/17 17:28:41.81 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2004/06/17 17:28:41.81 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2004/06/17 17:28:41.81 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2004/06/17 17:28:41.81 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/06/17 17:28:41.81 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2004/06/17 17:28:41.81 kernel Using '/home/sybase/SQ97.cfg' for configuration information.
00:00000:00000:2004/06/17 17:28:41.81 kernel Logging ASE messages in file '/home/sybase/ASE-12_5/install/SQ97.log'.
00:00000:00000:2004/06/17 17:28:41.84 kernel kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2004/06/17 17:28:41.85 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/06/17 17:28:41.85 kernel SQL Server booted with TCP_NODELAY enabled.
00:00000:00000:2004/06/17 17:28:41.85 kernel SSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2004/06/17 17:28:41.85 kernel Network and device connection limit is 1014.
00:00000:00000:2004/06/17 17:28:42.09 server Number of blocks left for proc headers: 3192.
00:00000:00000:2004/06/17 17:28:42.10 server Proc header memory allocated 1596 pages for each per engine cache
00:00000:00000:2004/06/17 17:28:42.10 server Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2004/06/17 17:28:42.10 server Size of the 2K memory pool: 8192 Kb
00:00000:00000:2004/06/17 17:28:42.10 kernel Initializing virtual device 0, '/dev/vg_sybase/rsybmaster' with dsync 'on'.
00:00000:00000:2004/06/17 17:28:42.10 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/06/17 17:28:42.10 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/06/17 17:28:42.11 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2004/06/17 17:28:42.11 kernel Unix interval timer enabled for sysclk interrupts.
00:00000:00000:2004/06/17 17:28:42.11 kernel engine 0, os pid 6784 online
00:00000:00000:2004/06/17 17:28:42.11 server No active traceflags
00:00000:00001:2004/06/17 17:28:42.11 kernel libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.3/EBF 11447 ESD#4/P/HP9000-879/HP-UX 11.0/rel12503/1939/64-bit/FBO/Sun Sep 21 06:02:05 2003'.
00:00000:00001:2004/06/17 17:28:42.11 kernel libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10818 ESD#8-1/DRV.12.5.0.4/hpux/HP-UX 11.0/BUILD125-016-1/64bit/OPT/Wed Dec 4 18:28:30 2002'
00:00000:00001:2004/06/17 17:28:42.11 server The logical pagesize of the server is 2 Kb.
00:00000:00001:2004/06/17 17:28:42.11 server Database 'master' appears to be at an older revision than the present installation; SQL Server will assess it, and upgrade it as required.
00:00000:00001:2004/06/17 17:28:42.11 server Database 'master': beginning upgrade step [ID 1]: Initialize disk and create empty allocation units on master device.
00:00000:00001:2004/06/17 17:28:45.14 server Database 'master': beginning upgrade step [ID 2]: Bootstrap basic system catalogs in database.
00:00000:00001:2004/06/17 17:28:45.53 server Database 'master': beginning upgrade step [ID 3]: creating index (table systypes, index ncsystypes)
00:00000:00001:2004/06/17 17:28:45.67 server Database 'master': beginning upgrade step [ID 4]: creating index (table sysobjects, index ncsysobjects)
00:00000:00001:2004/06/17 17:28:45.81 server Database 'master': beginning upgrade step [ID 20]: creating table (table sysusages)
00:00000:00001:2004/06/17 17:28:46.04 server Database 'master': beginning upgrade step [ID 21]: creating table (table sysdatabases)
00:00000:00001:2004/06/17 17:28:46.33 server Database 'master': beginning upgrade step [ID 22]: creating table (table sysdevices)
00:00000:00001:2004/06/17 17:28:46.55 server Database 'master': beginning upgrade step [ID 23]: creating table (table sysmessages)
00:00000:00001:2004/06/17 17:28:49.63 server Database 'master': beginning upgrade step [ID 24]: creating table (table sysconfigures)
00:00000:00001:2004/06/17 17:28:49.95 server Database 'master': beginning upgrade step [ID 25]: creating table (table syscharsets)
00:00000:00001:2004/06/17 17:28:50.24 server Database 'master': beginning upgrade step [ID 26]: creating table (table sysprocedures)
00:00000:00001:2004/06/17 17:28:50.50 server Database 'master': beginning upgrade step [ID 27]: creating table (table syscomments)
00:00000:00001:2004/06/17 17:28:50.69 server Database 'master': beginning upgrade step [ID 28]: creating table (table syssegments)
00:00000:00001:2004/06/17 17:28:50.83 server Database 'master': beginning upgrade step [ID 29]: creating table (table sysprotects)
00:00000:00001:2004/06/17 17:28:51.10 server Database 'master': beginning upgrade step [ID 30]: creating table (table sysusers)
00:00000:00001:2004/06/17 17:28:51.43 server Database 'master': beginning upgrade step [ID 31]: creating table (table sysalternates)
00:00000:00001:2004/06/17 17:28:51.64 server Database 'master': beginning upgrade step [ID 32]: creating table (table sysdepends)
00:00000:00001:2004/06/17 17:28:52.40 server Database 'master': beginning upgrade step [ID 33]: creating table (table syskeys)
00:00000:00001:2004/06/17 17:28:52.72 server Database 'master': beginning upgrade step [ID 35]: creating table (table sysprocesses)
00:00000:00001:2004/06/17 17:28:52.93 server Database 'master': beginning upgrade step [ID 36]: creating table (table syslogins)
00:00000:00001:2004/06/17 17:28:53.30 server Database 'master': beginning upgrade step [ID 37]: creating table (table syslocks)
00:00000:00001:2004/06/17 17:28:53.48 server Database 'master': beginning upgrade step [ID 38]: creating table (table syscurconfigs)
00:00000:00001:2004/06/17 17:28:53.60 server Database 'master': beginning upgrade step [ID 39]: creating table (table sysservers)
00:00000:00001:2004/06/17 17:28:53.86 server Database 'master': beginning upgrade step [ID 40]: creating table (table sysremotelogins)
00:00000:00001:2004/06/17 17:28:54.08 server Database 'master': beginning upgrade step [ID 41]: creating table (table sysmonitors)
00:00000:00001:2004/06/17 17:28:54.25 server Database 'master': beginning upgrade step [ID 42]: creating table (table sysengines)
00:00000:00001:2004/06/17 17:28:54.38 server Database 'master': beginning upgrade step [ID 43]: creating table (table syslanguages)
00:00000:00001:2004/06/17 17:28:54.73 server Database 'master': beginning upgrade step [ID 44]: creating table (table systestlog)
00:00000:00001:2004/06/17 17:28:54.77 server Database 'master': beginning upgrade step [ID 45]: creating table (table syssrvroles)
00:00000:00001:2004/06/17 17:28:55.07 server Database 'master': beginning upgrade step [ID 46]: creating table (table sysloginroles)
00:00000:00001:2004/06/17 17:28:55.39 server Database 'master': beginning upgrade step [ID 80]: creating table (table sysattributes)
00:00000:00001:2004/06/17 17:28:55.83 server Database 'master': beginning upgrade step [ID 81]: Load initial set of attribute-definition rows into SYSATTRIBUTES.
00:00000:00001:2004/06/17 17:29:00.23 server Warning: Using only the first 30 characters for password
00:00000:00001:2004/06/17 17:29:20.11 server Database 'master': beginning upgrade step [ID 251]: creating table (table syslogshold)
00:00000:00001:2004/06/17 17:29:20.38 server Database 'master': beginning upgrade step [ID 252]: creating table (table syslisteners)
00:00000:00001:2004/06/17 17:29:20.61 server Database 'master': beginning upgrade step [ID 253]: creating table (table syssecmechs)
00:00000:00001:2004/06/17 17:29:20.80 server Database 'master': beginning upgrade step [ID 600]: creating table (table sysreferences)
00:00000:00001:2004/06/17 17:29:21.23 server Database 'master': beginning upgrade step [ID 601]: creating table (table sysconstraints)
00:00000:00001:2004/06/17 17:29:21.60 server Database 'master': beginning upgrade step [ID 602]: creating table (table sysusermessages)
00:00000:00001:2004/06/17 17:29:21.95 server Database 'master': beginning upgrade step [ID 603]: creating table (table systhresholds)
00:00000:00001:2004/06/17 17:29:22.22 server Database 'master': beginning upgrade step [ID 604]: creating table (table sysroles)
00:00000:00001:2004/06/17 17:29:22.48 server Database 'master': beginning upgrade step [ID 605]: executing SQL statement (declare @rid smallint delete sysro)
00:00000:00001:2004/06/17 17:29:22.72 server Database 'master': beginning upgrade step [ID 606]: executing SQL statement (select lct_admin('lastchance', db_i)
00:00000:00001:2004/06/17 17:29:22.85 server Database 'master': beginning upgrade step [ID 1013]: creating table (table syspartitions)
00:00000:00001:2004/06/17 17:29:23.12 server Database 'master': beginning upgrade step [ID 1025]: creating table (table systimeranges)
00:00000:00001:2004/06/17 17:29:23.37 server Database 'master': beginning upgrade step [ID 1026]: executing SQL statement (if not exists (select 1 from systim)
00:00000:00001:2004/06/17 17:29:23.42 server Database 'master': beginning upgrade step [ID 1027]: creating table (table sysresourcelimits)
00:00000:00001:2004/06/17 17:29:26.56 server Database 'master': beginning upgrade step [ID 1082]: executing SQL statement (if not exists (select 1 from sysatt)
00:00000:00001:2004/06/17 17:29:26.70 server Database 'master': beginning upgrade step [ID 1124]: creating table (table systabstats)
00:00000:00001:2004/06/17 17:29:27.06 server Database 'master': beginning upgrade step [ID 1125]: creating table (table sysstatistics)
00:00000:00001:2004/06/17 17:29:27.54 server Database 'master': beginning upgrade step [ID 1126]: Initialize systabstats with valid statistics
00:00000:00001:2004/06/17 17:29:31.43 server Database 'master': beginning upgrade step [ID 1131]: Creating/Updating the last chance threshold for logsegment.
00:00000:00001:2004/06/17 17:29:31.55 server Database 'master': beginning upgrade step [ID 1201]: creating table (table sysxtypes)
00:00000:00001:2004/06/17 17:29:32.01 server Database 'master': beginning upgrade step [ID 1205]: creating table (table sysjars)
00:00000:00001:2004/06/17 17:29:32.50 server Database 'master': beginning upgrade step [ID 1206]: executing SQL statement (if not exists (select 1 from systyp)
00:00000:00001:2004/06/17 17:29:32.63 server Database 'master': beginning upgrade step [ID 1212]: creating table (table systransactions)
3 REPLIES 3
harry d brown jr
Honored Contributor

Re: sysbase cannot startup,



You should contact sybase, it appears you have a license issue.

live free or die
harry d brown jr
Live Free or Die
hua_1
Frequent Advisor

Re: sysbase cannot startup,

here is more info:
Using config area from primary master device.
00:00000:00000:2005/03/18 15:18:41.45 kernel os_create_region: can't allocate 2963591168 bytes
00:00000:00000:2005/03/18 15:18:41.45 kernel kbcreate: couldn't create kernel region.
00:00000:00000:2005/03/18 15:18:41.45 kernel kistartup: could not create shared memory
dan_365
New Member

Re: sysbase cannot startup,

Check your shmmax kernel parameter. It looks like your sybase cfg memory is higher than the shared memory the kernel is set too.

also check your $SYBASE/ASE-12_0/install/RUN* file and make sure your changing the right *.cfg file, because your first weird thing to me is this "A configuration file was not specified and the default file '/home/sybase/SQ97.cfg' does not exist". I see the license complains on our systems as well, and it will not impact the main ASE sybser nor do I believe that is what it is talking about, think it affects optional features only. (Sybase could confirm this)