If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > facing problems in setting up the ER

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-24-12, 03:18
pujakalra pujakalra is offline
Registered User
 
Join Date: Jan 2012
Posts: 2
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
Reply With Quote
  #2 (permalink)  
Old 02-21-12, 13:44
begooden-it begooden-it is offline
Registered User
 
Join Date: Sep 2011
Location: Pont l'Abbé, Brittany, France
Posts: 183
Hi Puja,


both informix log files would say something interesting: did you check ?
Reply With Quote
  #3 (permalink)  
Old 02-24-12, 03:15
pujakalra pujakalra is offline
Registered User
 
Join Date: Jan 2012
Posts: 2
Thanks for the reply. Issue got resolved by putting off the firewall
Reply With Quote
  #4 (permalink)  
Old 02-24-12, 03:23
begooden-it begooden-it is offline
Registered User
 
Join Date: Sep 2011
Location: Pont l'Abbé, Brittany, France
Posts: 183
Ah, the firewall!

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

Good news. Keep it running!

Have a nice day
Eric
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On