RE: Connection problem

Is tnsnames.ora pointing to the same place on both servers?

-----Original Message-----
Sent: Friday, January 11, 2002 1:15 PM
To: Multiple recipients of list ORACLE-L

"Rusnak, George A." wrote:
>
> Group,
> I have a development and a production system. Both are Sun/Solaris, Oracle
> 8.1.7.2.
> I have an identical db link to a remote server on both of my servers. I
can
> connect to remote host using the user/password that is in the db link.
>
> On my development server:
> webdev:> select count(*) from bookings_at_ibs_prod.deca.mil;
>
> COUNT(*)
> ----------
> 199494
>
> On my production server:
> webprod:> select count(*) from bookings_at_ibs_prod.deca.mil;
> select count(*) from bookings_at_ibs_prod.deca.mil
> *
> ERROR at line 1:
> ORA-02068: following severe error from IBS_PROD
> ORA-03114: not connected to ORACLE
>
> We ran a trace from our end and saw where we reached the remote site from
> our production server and then
> received a disconnect from the remote host. We have no privs on the remote
> host. I have passed this info on to my POC at the remote host. Can anyone
> either explain this or suggest places to investigate to resolve this
issue.
>
> TIA
>
> Al Rusnak
>
> DeCA: 804-734-8453
> rusnakga_at_hqlee.deca.mil
>

Firewall ?

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: rlsmith_at_kmg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).