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 > error while defining servers in CDR

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-20-04, 03:00
shreedhar_tase shreedhar_tase is offline
Registered User
 
Join Date: Feb 2004
Location: india
Posts: 45
error while defining servers in CDR

Hi
I am facing one problem in cdr.I am geting following message while defineing servers.

I am issuing command

D:\informix>cdr define server -c ol_pund2k352 -I ol_pund2k352

I am geting following message:-

command failed -- server not defined in sqlhosts (35)

For command

D:\informix>cdr define server -c g_ol_pund2k352 -I g_ol_pund2k352

connect to g_ol_pund2k352 failed *Error* <-25555> is not a known Enterprise Repl
ication error (-25555)

I am trying CDR on two W2K machines and hosts file description from registry is like this :

machine:- pund2k352

g_ol_pund2k352

HOST -
OPTIONS i=101
PROTOCOL group
SERVICE -

ol_pund2k352

HOST pund2k352
OPTIONS g=g_ol_pund2k352
PROTOCOL olsoctcp
SERVICE turbo1

machine:- pund2k314

g_ol_pund2k314

HOST -
OPTIONS i=102
PROTOCOL group
SERVICE -

ol_pund2k3141

HOST pund2k314
OPTIONS g=g_ol_pund2k314
PROTOCOL olsoctcp
SERVICE ids_san

Both machines has Services files having entry

ids_san 3182/tcp #ol_pund2k314
turbo1 1527/tcp #ol_pund2k352

hosts.equiv has entries for both machines

sanjkuma@pund2k314.adprod.bmc.com
stase@pund2k352.adprod.bmc.com
pund2k352
pund2k314
pund2k352.adprod.bmc.com
pund2k314.adprod.bmc.com

Can anyone help ?
Reply With Quote
  #2 (permalink)  
Old 02-25-04, 08:09
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Re: error while defining servers in CDR

Quote:
Originally posted by shreedhar_tase
Hi
I am facing one problem in cdr.I am geting following message while defineing servers.

I am issuing command

D:\informix>cdr define server -c ol_pund2k352 -I ol_pund2k352

I am geting following message:-

command failed -- server not defined in sqlhosts (35)

For command

D:\informix>cdr define server -c g_ol_pund2k352 -I g_ol_pund2k352

connect to g_ol_pund2k352 failed *Error* <-25555> is not a known Enterprise Repl
ication error (-25555)

I am trying CDR on two W2K machines and hosts file description from registry is like this :

machine:- pund2k352

g_ol_pund2k352

HOST -
OPTIONS i=101
PROTOCOL group
SERVICE -

ol_pund2k352

HOST pund2k352
OPTIONS g=g_ol_pund2k352
PROTOCOL olsoctcp
SERVICE turbo1

machine:- pund2k314

g_ol_pund2k314

HOST -
OPTIONS i=102
PROTOCOL group
SERVICE -

ol_pund2k3141

HOST pund2k314
OPTIONS g=g_ol_pund2k314
PROTOCOL olsoctcp
SERVICE ids_san

Both machines has Services files having entry

ids_san 3182/tcp #ol_pund2k314
turbo1 1527/tcp #ol_pund2k352

hosts.equiv has entries for both machines

sanjkuma@pund2k314.adprod.bmc.com
stase@pund2k352.adprod.bmc.com
pund2k352
pund2k314
pund2k352.adprod.bmc.com
pund2k314.adprod.bmc.com

Can anyone help ?
Hi,

Yo need define $INFORMIXDIR/etc/sqlhosts file of the following way

In Server_1
DBSERVERNAME_1 onipcshm hostname_1 dbservername_1
DBSERVERALIAS_1 onsoctcp hostname_1 services_name_1
DBSERVERALIAS_2 onsoctcp hostname_2 service_name_2

In server_2
DBSERVERNAME_2 onipcshm hostname_2 dbservername_2
DBSERVERALIAS_2 onsoctcp hostname_2 services_name_2
DBSERVERALIAS_1 onsoctcp hostname_1 service_name_1

Gustavo
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