Just a guess, but have you checked the firewall settings?
"Rusnak,
George A." To: Multiple recipients of list ORACLE-L
<rusnakga <[EMAIL PROTECTED]>
@hqlee.deca.m cc:
il> Subject: Connection problem
Sent by: root
01/11/2002
11:10 AM
Please
respond to
ORACLE-L
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]
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
