shared memory not initialized error in oninit -v

Previously my Informix server was running properly. But since last month IDS 11.5 is showing error as onscpah.exe failed on Windows XP startup. If you run oninit -v, following error is seen D:\\\\IBM\\\\Informix>oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file 'D:\\\\IBM\\\\Informix/etc/ONCONFIG.olr_khed_stn'...succeed ed Creating infos file "D:\\\\IBM\\\\Informix/etc/.infos.olr_khed_stn"...succeeded Linking conf file "D:\\\\IBM\\\\Informix/etc/.conf.olr_khed_stn"...succeeded Checking config parameters...succeeded Writing to infos file...succeeded Allocating and attaching to shared memory...succeeded Creating resident pool 4928 kbytes...succeeded Allocating 40016 kbytes for buffer pool of 4K page size...succeeded Initializing rhead structure...succeeded Initialization of Encryption...succeeded Initializing ASF...succeeded Initializing Dictionary Cache and SPL Routine Cache...succeeded Bringing up ADM VP...succeeded Creating VP classes...succeeded Onlining 0 additional cpu vps...succeeded Onlining 1 IO vps...succeeded Forking main_loop thread...succeeded Initializing DR structures...succeeded Forking 1 'soctcp' listener threads...succeeded Forking 1 'soctcp' listener threads...succeeded Starting tracing...succeeded Initializing 8 flushers...succeeded and after this it stops at prompt. In olr_khed_stn.log following error is seen 11:31:10 Warning: ONCONFIG dump directory (DUMPDIR) 'D:\\\\IBM\\\\Informix\\\\tmp' has insecure permissions 11:31:10 Booting Language <c> from module <> 11:31:10 Loading Module <CNULL> 11:31:10 Booting Language <builtin> from module <> 11:31:10 Loading Module <BUILTINNULL> 11:31:10 Could not disable priority aging: errno = 0 11:31:15 DR: DRAUTO is 0 (Off) 11:31:15 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 11:31:16 IBM Informix Dynamic Server Version 11.50.TC1DE Software Serial Number AAA#B000000 11:31:16 listener-thread: err = -25572: oserr = 49: errstr = : Network driver cannot bind a name to the port. System error = 49. 11:31:16 sql_listener: ASF_LISTEN failed 11:31:16 Attempting to bring listener thread down. 11:31:16 Server stopped. 11:31:16 IBM Informix Dynamic Server Stopped. Correct values are available in registry and hosts and services files. Previously following errors had been seen in olr_khed_stn in INFORMIXDIR file but since the machine is devlopment machine and not production machine no action was taken. But now the IDS is not starting at all. Also action required is not known to me. 11:47:53 Warning: The IBM IDS Developer Edition license restriction limits 11:47:53 the number of connections to this server to 20. 11:47:53 You already have 20 connections at this time. Any further connections 11:47:53 attempts will be rejected. Performance Advisory: Logical log file size might be too small for a checkpoint to complete. 12:25:29 Results: The size of individual logical log files is too small for the current workload, resulting in each log file filling very quickly. If log files fill in less than 30 seconds, the checkpoint might remain blocked because the last log file fills during the time needed to perform the checkpoint. 12:25:29 Action: Increase the size of the individual logical log files so that it takes at least 30 seconds to fill each one. Look at the online log to determine how quickly the log files are filling, and then increase the size of the files proportionately. 12:25:29 Logical Log 40 Complete, timestamp: 0x56ce9f. 12:25:31 Performance Advisory: Based on the current workload, the logical log space might be too small to accommodate the time it takes to flush the buffer pool. 12:25:31 Results: The server might block transactions during checkpoints. 12:25:31 Action: If transactions are blocked during the checkpoint, increase the size of the logical log space to at least 138776 KB. 12:25:31 Performance Advisory: The logical log space is too small for automatic checkpoints. 12:25:31 Results: Automatic checkpoints are disabled. 12:25:31 Action: To enable automatic checkpoints, increase the logical log space to at least 138776 KB.

Hi, listener-thread: err = -25572: oserr = 49: errstr = : Network driver cannot bind a name to the port. You have named a servername or serveralias, which is not startable as a socket listener. This occurs when you name a specific network interface in sqlhosts and reference it as active connection (servername/servicealias), but the interface address does not exist on your machine. To prevent this, check sqlhosts if there is a type on the IP adresses/hostnames or if the adress of your network interfaces has changed. Marcus -----Original Message----- From: PRAJAKTA CHIKHALE [mailto:prajakta_s_c@yahoo.co.in] Sent: Thursday, October 06, 2011 8:23 AM To: ids@iiug.org Subject: shared memory not initialized error in oninit -v [25127] Previously my Informix server was running properly. But since last month IDS 11.5 is showing error as onscpah.exe failed on Windows XP startup. If you run oninit -v, following error is seen D:\\\\IBM\\\\Informix>oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file 'D:\\\\IBM\\\\Informix/etc/ONCONFIG.olr_khed_stn'...succeed ed Creating infos file "D:\\\\IBM\\\\Informix/etc/.infos.olr_khed_stn"...succeeded Linking conf file "D:\\\\IBM\\\\Informix/etc/.conf.olr_khed_stn"...succeeded Checking config parameters...succeeded Writing to infos file...succeeded Allocating and attaching to shared memory...succeeded Creating resident pool 4928 kbytes...succeeded Allocating 40016 kbytes for buffer pool of 4K page size...succeeded Initializing rhead structure...succeeded Initialization of Encryption...succeeded Initializing ASF...succeeded Initializing Dictionary Cache and SPL Routine Cache...succeeded Bringing up ADM VP...succeeded Creating VP classes...succeeded Onlining 0 additional cpu vps...succeeded Onlining 1 IO vps...succeeded Forking main_loop thread...succeeded Initializing DR structures...succeeded Forking 1 'soctcp' listener threads...succeeded Forking 1 'soctcp' listener threads...succeeded Starting tracing...succeeded Initializing 8 flushers...succeeded and after this it stops at prompt. In olr_khed_stn.log following error is seen 11:31:10 Warning: ONCONFIG dump directory (DUMPDIR) 'D:\\\\IBM\\\\Informix\\\\tmp' has insecure permissions 11:31:10 Booting Language <c> from module <> 11:31:10 Loading Module <CNULL> 11:31:10 Booting Language <builtin> from module <> 11:31:10 Loading Module <BUILTINNULL> 11:31:10 Could not disable priority aging: errno = 0 11:31:15 DR: DRAUTO is 0 (Off) 11:31:15 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 11:31:16 IBM Informix Dynamic Server Version 11.50.TC1DE Software Serial Number AAA#B000000 11:31:16 listener-thread: err = -25572: oserr = 49: errstr = : Network driver cannot bind a name to the port. System error = 49. 11:31:16 sql_listener: ASF_LISTEN failed 11:31:16 Attempting to bring listener thread down. 11:31:16 Server stopped. 11:31:16 IBM Informix Dynamic Server Stopped. Correct values are available in registry and hosts and services files. Previously following errors had been seen in olr_khed_stn in INFORMIXDIR file but since the machine is devlopment machine and not production machine no action was taken. But now the IDS is not starting at all. Also action required is not known to me. 11:47:53 Warning: The IBM IDS Developer Edition license restriction limits 11:47:53 the number of connections to this server to 20. 11:47:53 You already have 20 connections at this time. Any further connections 11:47:53 attempts will be rejected. Performance Advisory: Logical log file size might be too small for a checkpoint to complete. 12:25:29 Results: The size of individual logical log files is too small for the current workload, resulting in each log file filling very quickly. If log files fill in less than 30 seconds, the checkpoint might remain blocked because the last log file fills during the time needed to perform the checkpoint. 12:25:29 Action: Increase the size of the individual logical log files so that it takes at least 30 seconds to fill each one. Look at the online log to determine how quickly the log files are filling, and then increase the size of the files proportionately. 12:25:29 Logical Log 40 Complete, timestamp: 0x56ce9f. 12:25:31 Performance Advisory: Based on the current workload, the logical log space might be too small to accommodate the time it takes to flush the buffer pool. 12:25:31 Results: The server might block transactions during checkpoints. 12:25:31 Action: If transactions are blocked during the checkpoint, increase the size of the logical log space to at least 138776 KB. 12:25:31 Performance Advisory: The logical log space is too small for automatic checkpoints. 12:25:31 Results: Automatic checkpoints are disabled. 12:25:31 Action: To enable automatic checkpoints, increase the logical log space to at least 138776 KB. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Just to be clear, you are using the Developer Edition of Informix which is for software development purposes only and cannot be used as a production server. If you want a free server for production use, you can download the Informix Innovator Edition. The message about already having 20 connections seems to indicate that you are using the Developer Edition outside of its license provisions. That's not why you are having trouble starting the server up, but I thought you should know this. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 6, 2011 at 2:23 AM, PRAJAKTA CHIKHALE <prajakta_s_c@yahoo.co.in>wrote: > Previously my Informix server was running properly. But since last month > IDS > 11.5 is showing error as onscpah.exe failed on Windows XP startup. > If you run oninit -v, following error is seen > > D:\\\\IBM\\\\Informix>oninit -v > Checking group membership to determine server run mode...succeeded > Reading configuration file > 'D:\\\\IBM\\\\Informix/etc/ONCONFIG.olr_khed_stn'...succeed > ed > Creating infos file "D:\\\\IBM\\\\Informix/etc/.infos.olr_khed_stn"...succeeded > Linking conf file "D:\\\\IBM\\\\Informix/etc/.conf.olr_khed_stn"...succeeded > Checking config parameters...succeeded > Writing to infos file...succeeded > Allocating and attaching to shared memory...succeeded > Creating resident pool 4928 kbytes...succeeded > Allocating 40016 kbytes for buffer pool of 4K page size...succeeded > Initializing rhead structure...succeeded > Initialization of Encryption...succeeded > Initializing ASF...succeeded > Initializing Dictionary Cache and SPL Routine Cache...succeeded > Bringing up ADM VP...succeeded > Creating VP classes...succeeded > Onlining 0 additional cpu vps...succeeded > Onlining 1 IO vps...succeeded > Forking main_loop thread...succeeded > Initializing DR structures...succeeded > Forking 1 'soctcp' listener threads...succeeded > Forking 1 'soctcp' listener threads...succeeded > Starting tracing...succeeded > Initializing 8 flushers...succeeded > > and after this it stops at prompt. > > In olr_khed_stn.log following error is seen > > 11:31:10 Warning: ONCONFIG dump directory (DUMPDIR) 'D:\\\\IBM\\\\Informix\\\\tmp' > has > insecure permissions > 11:31:10 Booting Language <c> from module <> > 11:31:10 Loading Module <CNULL> > 11:31:10 Booting Language <builtin> from module <> > 11:31:10 Loading Module <BUILTINNULL> > 11:31:10 Could not disable priority aging: errno = 0 > 11:31:15 DR: DRAUTO is 0 (Off) > 11:31:15 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 11:31:16 IBM Informix Dynamic Server Version 11.50.TC1DE Software Serial > Number AAA#B000000 > 11:31:16 listener-thread: err = -25572: oserr = 49: errstr = : Network > driver > cannot bind a name to the port. > System error = 49. > 11:31:16 sql_listener: ASF_LISTEN failed > > 11:31:16 Attempting to bring listener thread down. > > 11:31:16 Server stopped. > > 11:31:16 IBM Informix Dynamic Server Stopped. > > Correct values are available in registry and hosts and services files. > > Previously following errors had been seen in olr_khed_stn in INFORMIXDIR > file > but since the machine is devlopment machine and not production machine no > action was taken. But now the IDS is not starting at all. > > Also action required is not known to me. > > 11:47:53 Warning: The IBM IDS Developer Edition license restriction limits > 11:47:53 the number of connections to this server to 20. > 11:47:53 You already have 20 connections at this time. Any further > connections > 11:47:53 attempts will be rejected. > > Performance Advisory: Logical log file size might be too small for a > > checkpoint to complete. > 12:25:29 Results: The size of individual logical log files is too small for > > the current workload, resulting in each log file filling very > > quickly. If log files fill in less than 30 seconds, the checkpoint > > might remain blocked because the last log file fills during the time > > needed to perform the checkpoint. > 12:25:29 Action: Increase the size of the individual logical log files so > > that it takes at least 30 seconds to fill each one. Look at the > > online log to determine how quickly the log files are filling, and > > then increase the size of the files proportionately. > 12:25:29 Logical Log 40 Complete, timestamp: 0x56ce9f. > 12:25:31 Performance Advisory: Based on the current workload, the logical > log > space might be too small to > accommodate the time it takes to flush the buffer pool. > 12:25:31 Results: The server might block transactions during checkpoints. > 12:25:31 Action: If transactions are blocked during the checkpoint, > increase > the size of the > logical log space to at least 138776 KB. > 12:25:31 Performance Advisory: The logical log space is too small for > automatic checkpoints. > 12:25:31 Results: Automatic checkpoints are disabled. > 12:25:31 Action: To enable automatic checkpoints, increase the logical log > space to at least 138776 > KB. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6e8d1a958b7804ae9e101a

I know that I am using Developer edition. Typically in our company, we develop the programs on PCs and laptops where Developer version is installed so that we can modify table structures without interfering others work. Then when we are through and final with table structures we deploy them on model server where tables are created by DBAs and integration and system testing is done on model servers and finally when this gets through programs and tables are deployed on live production servers. Currently because of this problem I cannot use my laptop for select statement also leave aside table creation. Secondly I am not getting help how to delete logical / physical logs in IDS in Windows XP Developer edition. Net has lot for UNIX but very less info is available for Windows. Also when I am single user of the computer why are no of licenses crossing 20. Anyways this error are nowadays not seen in database. The error that are seen in olr_khed_stn.log are only "Network driver cannot bind a name to the port." I am not running any program which accesses database. Even after rebooting multiple times. Also today I tried uninstalling the IDS but still the problem persists. Also what permissions are required for 'D:\\\\IBM\\\\Informix\\\\tmp'. Windows Properties windows for the folder shows permissions as Readonly. 16:40:51 Warning: ONCONFIG dump directory (DUMPDIR) 'D:\\\\IBM\\\\Informix\\\\tmp' has insecure permissions 16:40:51 Booting Language <c> from module <> 16:40:51 Loading Module <CNULL> 16:40:51 Booting Language <builtin> from module <> 16:40:51 Loading Module <BUILTINNULL> 16:40:51 Could not disable priority aging: errno = 0 16:40:56 DR: DRAUTO is 0 (Off) 16:40:56 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 16:40:57 IBM Informix Dynamic Server Version 11.50.TC1DE Software Serial Number AAA#B000000 16:40:57 listener-thread: err = -25572: oserr = 49: errstr = : Network driver cannot bind a name to the port. System error = 49. 16:40:57 sql_listener: ASF_LISTEN failed 16:40:57 Attempting to bring listener thread down. 16:40:57 Server stopped. 16:40:57 IBM Informix Dynamic Server Stopped. Setting in Registry are correct. Does installing TCP/IP stack for IPv6 cause problems ?

Hi. Just a tip: another program (recently installed?) must be using the same port as your Informix engine, and is running before Informix. In case you didn´t change anything on Informix ports, look for other programs. Otherwise, choose any other available one for Informix. Please check all your running services, and watch for their communication ports. I´m sure you will find some some other, check it out. About your logical-logs, if you´re facing troubles to manipulate them via command prompt, I´d suggest you to install OAT (you could even administer all your developer´s instances, from only one installation) ;) that´s a great tool! Regards. Em 06/10/2011 07:43, PRAJAKTA CHIKHALE escreveu: > I know that I am using Developer edition. Typically in our company, we develop > the programs on PCs and laptops where Developer version is installed so that > we can modify table structures without interfering others work. Then when we > are through and final with table structures we deploy them on model server > where tables are created by DBAs and integration and system testing is done on > model servers and finally when this gets through programs and tables are > deployed on live production servers. Currently because of this problem I > cannot use my laptop for select statement also leave aside table creation. > > Secondly I am not getting help how to delete logical / physical logs in IDS in > Windows XP Developer edition. Net has lot for UNIX but very less info is > available for Windows. > > Also when I am single user of the computer why are no of licenses crossing 20. > > Anyways this error are nowadays not seen in database. The error that are seen > in olr_khed_stn.log are only "Network driver cannot bind a name to the port." > > I am not running any program which accesses database. Even after rebooting > multiple times. Also today I tried uninstalling the IDS but still the problem > persists. Also what permissions are required for 'D:\\\\IBM\\\\Informix\\\\tmp'. > Windows Properties windows for the folder shows permissions as Readonly. > > 16:40:51 Warning: ONCONFIG dump directory (DUMPDIR) 'D:\\\\IBM\\\\Informix\\\\tmp' has > insecure permissions > 16:40:51 Booting Language<c> from module<> > 16:40:51 Loading Module<CNULL> > 16:40:51 Booting Language<builtin> from module<> > 16:40:51 Loading Module<BUILTINNULL> > 16:40:51 Could not disable priority aging: errno = 0 > 16:40:56 DR: DRAUTO is 0 (Off) > 16:40:56 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 16:40:57 IBM Informix Dynamic Server Version 11.50.TC1DE Software Serial > Number AAA#B000000 > 16:40:57 listener-thread: err = -25572: oserr = 49: errstr = : Network driver > cannot bind a name to the port. > System error = 49. > 16:40:57 sql_listener: ASF_LISTEN failed > 16:40:57 Attempting to bring listener thread down. > 16:40:57 Server stopped. > 16:40:57 IBM Informix Dynamic Server Stopped. > > Setting in Registry are correct. Does installing TCP/IP stack for IPv6 cause > problems ? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70 IBM Information Management Informix Technical Professional v3

1. The Developer Edition thing was just an FYI, no worries. 2. Don't know why you are getting the 20 sessions warning if you are the only user, and you are right that is not why you are having a problem. 3. \\\\INFORMIX\\\\tmp should be owned by user informix, that is probably what it is complaining about. 4. Is it possible that you have used the IP address of the machine to configure its connections rather than its net name? If the IP address of the PC has changed since then that would explain the error you are seeing, as someone else suggested. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 6, 2011 at 7:43 AM, PRAJAKTA CHIKHALE <prajakta_s_c@yahoo.co.in>wrote: > I know that I am using Developer edition. Typically in our company, we > develop > the programs on PCs and laptops where Developer version is installed so > that > we can modify table structures without interfering others work. Then when > we > are through and final with table structures we deploy them on model server > where tables are created by DBAs and integration and system testing is done > on > model servers and finally when this gets through programs and tables are > deployed on live production servers. Currently because of this problem I > cannot use my laptop for select statement also leave aside table creation. > > Secondly I am not getting help how to delete logical / physical logs in IDS > in > Windows XP Developer edition. Net has lot for UNIX but very less info is > available for Windows. > > Also when I am single user of the computer why are no of licenses crossing > 20. > > Anyways this error are nowadays not seen in database. The error that are > seen > in olr_khed_stn.log are only "Network driver cannot bind a name to the > port." > > I am not running any program which accesses database. Even after rebooting > multiple times. Also today I tried uninstalling the IDS but still the > problem > persists. Also what permissions are required for 'D:\\\\IBM\\\\Informix\\\\tmp'. > Windows Properties windows for the folder shows permissions as Readonly. > > 16:40:51 Warning: ONCONFIG dump directory (DUMPDIR) 'D:\\\\IBM\\\\Informix\\\\tmp' > has > insecure permissions > 16:40:51 Booting Language <c> from module <> > 16:40:51 Loading Module <CNULL> > 16:40:51 Booting Language <builtin> from module <> > 16:40:51 Loading Module <BUILTINNULL> > 16:40:51 Could not disable priority aging: errno = 0 > 16:40:56 DR: DRAUTO is 0 (Off) > 16:40:56 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 16:40:57 IBM Informix Dynamic Server Version 11.50.TC1DE Software Serial > Number AAA#B000000 > 16:40:57 listener-thread: err = -25572: oserr = 49: errstr = : Network > driver > cannot bind a name to the port. > System error = 49. > 16:40:57 sql_listener: ASF_LISTEN failed > 16:40:57 Attempting to bring listener thread down. > 16:40:57 Server stopped. > 16:40:57 IBM Informix Dynamic Server Stopped. > > Setting in Registry are correct. Does installing TCP/IP stack for IPv6 > cause > problems ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba3fcc39af48dd04aea0e6bf

Thanks for responding. However, I have not changed IP address or hostname of the machine. But still the problem persists. I cannot format my PC because I have lots of applications installed which cannot be removed. I tried reinstalling the IBM Informix 11.5 software multiple times but the same error is seen. I had taken dbexport of the database before the problem as a part of periodic safeguard for me. Hence data is safe. Should I try installing newer 11.7 or I will face same problems with it ?

I reinstalled newer version of IDS 11.5 Developer edition iif.11.50.TC9DE.win2003.zip after downloading it from IBM website. With installation of this, the problem was solved.