SQL*Net V2 listener problem
Date: 28 Oct 92 03:58:25 GMT
Message-ID: <1992Oct28.035825.7837_at_exu.ericsson.se>
Hi,
I am trying to set up the ORACLE7 (V7.0.9.3.1) Developer's Release in a SunOS 4.1.1 client/server configuration, using SQL*Net V2.
Everything works fine if I connect the V7 client (SQL*Plus) to the V7 RDBMS with SQL*Net V1, i.e. it seems like the RDBMS itself runs okay and I don't have any communication problems.
But when I try to start an SQL*Net V2 listener, I get the following error:
TNS-01153: Failed to register SID "proto": check trace file for port specific problems.
The trace file does not contain any additional information, as the message suggest.
The SID is "proto" on a server named "sqlnet". My /etc/listener.ora file (on the server) looks like this:
TNSSTOP=yes
STOP_LISTENER=YES
TRACE_LEVEL_LISTENER=ON
listener = (ADDRESS=(PROTOCOL=tcp)(HOST=sqlnet)(PORT=1600))
proto = (SID=(ORACLE_HOME=/export/home2/oracle7))
and the /etc/tnsnames.ora (on both the server and client) looks like this:
v7_proto = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(PORT=1600)(HOST=sqlnet))
(CONNECT_DATA=(SID=proto))
)
What am I missing? Any hints would be very much appreciated.
--- Hans ----- Hans Bergsten Internet : ebuhob_at_ebu.ericsson.se Ericsson Business Communications MEMO : ERI.EBU.EBUHOB (God forbid.) 525 N. Muller St. Voice : +1 (714) 491-6264 Anaheim, CA 92803, USA FAX : +1 (714) 535-1789Received on Wed Oct 28 1992 - 04:58:25 CET