Re: Listener help for a n00b.

Thanks for the response. Sorry for the delay in mine. Weekends.

Ok. The ping db2_net8 worked fine. I'm not using DNS, all of the entries are in my /etc/hosts files.

>Besides, listeners run on the server, so you want to fire up
>a db2 listener ON the db2 machine. Same for db3.

That's good to know. I checked on the db2 machine and the 1st thing I saw was the listener.ora wasn't there (rather, the link was missing). I linked it properly and got a bit further. It then told me the executable was missing. I'm not too surprised by this as I said the lnsrctl executable was missing, who knows what else was. I tar'ed the ../oracle/bin directory from the master(db1) and brought it over to the db2. Lo and behold the listener now starts (output below).

Unfortunately, that's not the end of the troubles. I have created the link on db1 as described in my 1st post. When I attempt to do a desc on the linked table I get the following. Is there any way to debug this one? Thanks again!

SQL> desc config_at_db2;
ERROR:
ORA-02068: following severe error from db2 ORA-03114: not connected to ORACLE

Defence off.
db2>lsnrctl start ocs-slee1_SEF

LSNRCTL for Solaris: Version 8.1.7.2.0 - Production on 09-JAN-2006 10:07:27

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Starting /in/oracle/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.1.7.2.0 - Production System parameter file is /in/oracle/network/admin/listener.ora Log messages written to /dev/null
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocs-slee1)(PORT=1526)))

Connecting to
(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=ocs-slee1_net8)(Port=1526)) STATUS of the LISTENER

Alias                     db_SEF
Version                   TNSLSNR for Solaris: Version 8.1.7.2.0 -
Production
Start Date                09-JAN-2006 10:07:27
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /in/oracle/network/admin/listener.ora
Listener Log File         /dev/null
Services Summary...
  db2                has 1 service handler(s)