Re: SQL*NET error on remote connection attempt
Date: 27 Apr 1994 06:02:32 GMT
Message-ID: <2pkv5o$44a_at_nwfocus.wa.com>
In article <1994Apr19.120918_at_suned1.nswses.navy.mil>,
Mike Grapevine <grape_at_suned1.nswses.navy.mil> wrote:
>Hi,
> I am having a problem trying to connect using SQL*Net between Oracle
>running on an HP 900 750 and on a SUN. I installed and set up SQL*NET on the HP,
>and can connect to the Oracle instance on the SUN with say:
>
> sqlplus /_at_t:{SUN machine}:{SUN Oracle SID}
>
>but when I try to connect to the Oracle instance on the HP from the SUNs, I get:
I assume that you try something like:
sqlplus /_at_t:{HP machine}:{HP Oracle SID}
This would require the the unix userid (number) be synchronized on the
two machines, i.e. you cannot be eeg(201) on one and eeg(59) on the
other...
What result do you get if you try
sqlplus scott/tiger_at_t:{HP machine}:{HP Oracle SID} assuming that orasrv is running on HP and scott/tiger is a valid schema?
Just my two cents...
-Erik
>
>*********************************************************************
>
>SQL*Plus: Release 3.1.2.3.1 - Production on Tue Apr 19 10:59:44 1994
>
>Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
>
>ERROR: ORA-03113: end-of-file on communication channel
>
>
>Enter user-name:
>
>*********************************************************************
>
>Has anybody else seen and solved this problem. I am using Oracle 7.0.15.4.0
>on the SUNs and Oracle 7.0.13.1.0 on the HP. Also SQL*Net is running on
>both mathines
>--
> Michael D. Grapevine
> NSWC PHD
> Code 4G33
> Port Hueneme, CA 93043
> Email 1: grape_at_suned1.nswses.navy.mil
> Email 2: MIKE_GRAPEVINE_at_NSWSES_at_4G-GATEWAY.Nswses.Navy.Mil
> Email 3: grape_at_tecnet1.jcte.jcs.mil
> Bus: (805) 982-7791
>
> Any statements / opinions made here are mine, alone, not the Navy's.
Received on Wed Apr 27 1994 - 08:02:32 CEST