Informix

 View Only

  • 1.  SHARED Memory segment issue

    Posted Sun March 14, 2021 03:13 AM
    Hello All,

          I've installed IDS 12.10.FC9TL on Suse Linux 15 .

          While initializing the instance first time getting below error :

    informix@localhost:~/etc> oninit -ivy
    Your evaluation license will expire on 2021-06-12 00:00:00
    oninit: DBSERVERNAME 'nebula21' not in sqlhosts file or sqlhosts file contents
    are damaged.
    Reading configuration file '/home/informix/etc/onconfig.nebula21'...succeeded
    Creating /INFORMIXTMP/.infxdirs...succeeded
    Allocating and attaching to shared memory...succeeded
    Creating resident pool 4310 kbytes...succeeded
    Creating infos file "/home/informix/etc/.infos.nebula21"...succeeded
    Linking conf file "/home/informix/etc/.conf.nebula21"...succeeded

    WARNING: server initialization failed or timed out.
    Check the message log, online.log, for errors.
    informix@localhost:~/etc>


    ===================ONLINE.LOG==================
    Message Log File: /home/informix/online.log
    The default memory page size will be used.
    13:56:42 Segment locked: addr=0x484af000, size=53919744
    13:57:22 IBM Informix Dynamic Server Started.
    13:57:22 Requested shared memory segment size rounded from 4308KB to 4796KB
    13:58:44 IBM Informix Dynamic Server Started.
    13:58:44 Insufficient free huge pages in /proc/meminfo for shared memory segment.
    Requested: 4911104 bytes. Available: 0 bytes.
    The default memory page size will be used.
    13:58:44 Requested shared memory segment size rounded from 4308KB to 4796KB
    13:58:44 Segment locked: addr=0x10a000000, size=4911104
    13:58:44 Insufficient free huge pages in /proc/meminfo for shared memory segment.
    Requested: 539197440 bytes. Available: 0 bytes.
    The default memory page size will be used.
    13:58:44 Segment locked: addr=0x10a4af000, size=539197440
    13:59:37 IBM Informix Dynamic Server Started.
    13:59:37 Requested shared memory segment size rounded from 4308KB to 4796KB
    14:03:09 IBM Informix Dynamic Server Started.
    14:03:09 Requested shared memory segment size rounded from 4308KB to 4796KB
    14:03:59 IBM Informix Dynamic Server Started.
    14:03:59 Requested shared memory segment size rounded from 4308KB to 4796KB
    informix@localhost:~/etc

    =====================ONCONFIG FILE===============

    ESIDENT 0
    SHMBASE 0x48000000L
    SHMVIRTSIZE 52656
    SHMADD 8192
    EXTSHMADD 8192
    SHMTOTAL 0
    SHMVIRT_ALLOCSEG 0,3
    SHMNOACCESS
    =============================================

    Please let me know what value should I change?


    Thanks
    Amit Patel

    ------------------------------
    AMIT PATEL
    ------------------------------

    #Informix


  • 2.  RE: SHARED Memory segment issue

    IBM Champion
    Posted Sun March 14, 2021 07:01 AM

    Hello,
    since this is the first error:
    "oninit: DBSERVERNAME 'nebula21' not in sqlhosts file or sqlhosts file contents are damaged."
    please post sqlhosts file as well as server settings from onconfig.

    Hrvoje



    ------------------------------
    Hrvoje Zokovic
    ------------------------------

    Original Message


  • 3.  RE: SHARED Memory segment issue

    Posted Sun March 14, 2021 09:27 AM
    Dear Hrvoje,

                Thanks for let me know the issue in SQLHOSTS file without checking the SQLHOSTS file :) 

                 I had changed the DBSERVERNME and NETTYPE misplaced , Now put in right place and now instance is in online state.


    Thanks
    Amit Patel

    ------------------------------
    AMIT PATEL
    ------------------------------

    Original Message