Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Posts
    6

    Unanswered: facing problems in setting up the ER

    Hi Experts,
    I am trying to setup an ER between 2 Linux boxes, I have updated the sqlhosts, hosts, hosts.equiv, and services file. But on connecting via dbaccess, I am facing below error

    908: Attempt to connect to database server (ciscounity_ucbu_aricent_vm145)
    ISAM error: record is locked.

    Any thoughts why I am facing this issue.
    Here are the snippet of hosts file (trying to connect ucbu-aricent-vm145 from ucbu-aricent-vm450)

    # cat /etc/hosts.equiv
    ucbu-aricent-vm145
    ucbu-aricent-vm145.cisco.com

    # cat /etc/hosts
    127.0.0.1 localhost
    ::1 localhost
    10.65.156.221 ucbu-aricent-vm450.cisco.com ucbu-aricent-vm450
    10.65.156.49 ucbu-aricent-vm145.cisco.com ucbu-aricent-vm145

    #cat /usr/local/cm/db/informix/etc/sqlhosts
    ciscounity onsoctcp 127.0.0.1 1502
    ciscounityb onsoctcp 127.0.0.1 1503
    g_ciscounity_ucbu_aricent_vm450 group - - i=100
    ciscounity_ucbu_aricent_vm450 onsoctcp 10.65.156.221 1502 g=g_ciscounity_ucbu_aricent_vm450
    g_ciscounity_ucbu_aricent_vm145 group - - i=102
    ciscounity_ucbu_aricent_vm145 onsoctcp 10.65.156.49 1502 g=g_ciscounity_ucbu_aricent_vm145

    #cat /etc/services|grep 1502
    shivadiscovery 1502/tcp # Shiva
    shivadiscovery 1502/udp # Shiva

    Regards,
    Puja

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi Puja,


    both informix log files would say something interesting: did you check ?

  3. #3
    Join Date
    Jan 2012
    Posts
    6
    Thanks for the reply. Issue got resolved by putting off the firewall

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Ah, the firewall!

    I hate firewalls! Always there when you don't expect them

    Good news. Keep it running!

    Have a nice day
    Eric

Posting Permissions

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