Re: Two instances on same machine,conerr=-25592
On Mon, Feb 8, 2010 at 14:13, Ljiljana Zivanovic <ljiljana@mizuhocap.com>wrote:
>
> we are testing IDS 11.50.FC4 on SunSolaris 10.
>
> I am setting up two instances on the same machine and I have following
>
> connectivity problem.
>
> Server 1
>
> SERVERNUM 1
>
> DBSERVERALIASES nysrv>
> Server 2
>
> SERVERNUM 2
>
> DBSERVERALIASES nysrvbo>
> SQLHOSTS
>
> nysrv oltlitcp devtestdbs10.nyc nysrv
> nysrvbo oltlitcp devtestdbs10.nyc nysrvbo>
> /etc/services
>
> nysrv 1638/tcp
> nysrvbo 1695/tcp
>
> When I run
>
> dbaccess bo_db@nysrvbo;
>
> SELECT * FROM ny_db@nysrv:table_name;>
> I am getting following error:
>
> 908: Attempt to connect to database server (nysrv, conerr=-25592,
> oserr=4) failed.>
> I have no problem switching within dbaccess between instances:
>
> From bo_db@nysrvbo dbaccess ny_db@nysrv;
> works fine, but selecting from table on other instance gives me
> connection error.
>
> Am I missing something in setup, has anyone had same problem?
>
Did you modify the sqlhosts file since starting one of the instances?
If so, try restarting that instance.
Also, you showed just the DBSERVERALIASES values; did you also set
DBSERVERNAME too, to two different values?
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Joan Crawford<http://www.brainyquote.com/quotes/authors/j/joan_crawford.html>;
- "I, Joan Crawford, I believe in the dollar. Everything I earn, I
spend."
--000e0cd13a9e1106bb047f485eec
Thanks all for your help.
I had in sqlhosts file doubled instance name that was no longer used
of type onsoctcp and that is why I couldn't connect to correct
instance. Removing this entry from sqlhosts file fixed the problem
Thanks again,
Ljiljana
Jonathan Leffler wrote:
On Mon, Feb 8, 2010 at 14:13, Ljiljana Zivanovic
[1]<ljiljana@mizuhocap.com>wrote:
we are testing IDS 11.50.FC4 on SunSolaris 10.
I am setting up two instances on the same machine and I have following
connectivity problem.
Server 1
SERVERNUM 1
DBSERVERALIASES nysrv
Server 2
SERVERNUM 2
DBSERVERALIASES nysrvbo
SQLHOSTS
nysrv oltlitcp devtestdbs10.nyc nysrv
nysrvbo oltlitcp devtestdbs10.nyc nysrvbo
/etc/services
nysrv 1638/tcp
nysrvbo 1695/tcp
When I run
dbaccess bo_db@nysrvbo;
SELECT * FROM ny_db@nysrv:table_name;
I am getting following error:
908: Attempt to connect to database server (nysrv, conerr=-25592,
oserr=4) failed.
I have no problem switching within dbaccess between instances:
From bo_db@nysrvbo dbaccess ny_db@nysrv;
works fine, but selecting from table on other instance gives me
connection error.
Am I missing something in setup, has anyone had same problem?
Did you modify the sqlhosts file since starting one of the instances?
If so, try restarting that instance.
Also, you showed just the DBSERVERALIASES values; did you also set
DBSERVERNAME too, to two different values?
This e-mail contains information some or all of which may be confidential, prop
rietary and/or legally privileged. If an addressing or transmission error has
misdirected this e-mail, please notify the sender by replying to this e-mail.
If you are not the intended recipient you must not use, disclose, distribute, c
opy, print or rely on this e-mail.
If you have any queries, or if you no longer wish to receive email in accordanc
e with the Act on Regulation of the Transmission of Specified Electronic Mail,
please contact the sender of this email.
References
1. mailto:ljiljana@mizuhocap.com