Re: SQL*NET error on remote connection attempt

Steven Whatley (swhatley_at_blkbox.COM) wrote:
: grape_at_suned1.nswses.navy.mil (Mike Grapevine) writes:
 

: >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:
: >*********************************************************************
: >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
 

: If I remembor right, the OPS$ login only works if you are logged into the
: system account that owns the Oracle account. When using SQL*Net you must
: give the username and password. A '/' is not sufficant.
 

: Hope this helps,
: Steven Whatley

--
You can use just / as long as you have defined

remote_os_authent = YES
os_authent_prefix = OPS$    --if you still use this prefix!

in the init.ora file and the username exists on both machines or both
machines are running YP (NIS) and are in the same domain.

See your oracle installation guide for the SUN and/or HP.

+------------------+----------------------------------------+
| Brett England    | Internet: bmenglan_at_apanix.apana.org.au |
 +------------------+----------------------------------------+