Yes they are the same. The remote site are going to try and flush(?) their
routers and they I will try again.
Al Rusnak
DeCA: 804-734-8453
[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, January 11, 2002 2:27 PM
To: Multiple recipients of list ORACLE-L
Subject: 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 [EMAIL PROTECTED];
>
> COUNT(*)
> ----------
> 199494
>
> On my production server:
> webprod:> select count(*) from [EMAIL PROTECTED];
> select count(*) from [EMAIL PROTECTED]
> *
> 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
> [EMAIL PROTECTED]
>
Firewall ?
--
Regards,
Stephane Faroult
Oriole Ltd
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Rusnak, George A.
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).