Help! SQL*NET 2.0 Listener won't connect on server

From: Dean Burell <dburell_at_primenet.com>
Date: 1996/01/13
Message-ID: <dburell.10.0E5953C8_at_primenet.com>#1/1


I am having a problem connecting to my database via my listener. The listener is running, and the listener.ora and tnsnames.ora files seem to be correct but when I try to connect to the database on the server using - sqlplus pm/pm_at_v3_db it doesn't recognize the username. I can however connect direct without going through SQL*net. I looked in the trace file and it had an entry about not finding a protocol.ora file, but everything else looked like it connected. I can't find anything in the SQL*Net or server documentation on this protocol.ora file. I did a complete search of my drive and do not have this file. I am stumped as to why I cannot connect. Can anyone suggest other things to look at? Or if you have a protocol.ora file, perhaps you can send me a copy to emulate. Any suggestions or help would be greatly appreciated.

I have attached the contents of the associated .ora files. My configuration is as follows:

IBM model 370 running AIX 4.1.3
Oracle 7.1.6
SQL*NET 2.0 Thanks in advance for your help.

Dean Burell
dburell_at_primenet.com

****************Begin listener.ora ***********************

LISTENER=(ADDRESS_LIST=
                (ADDRESS=
                      (PROTOCOL=TCP)

(HOST=pmdemo3)
(PORT=1521)
) ) SID_LIST_LISTENER= (SID_DESC=
(SID_NAME=PMV3)
(ORACLE_HOME=/oracle/716)
)

LOG_DIRECTORY_LISTENER=/tmp
LOG_FILE_LISTENER=listener.log
TRACE_LEVEL_LISTENER=ADMIN
TRACE_DIRECTOR_LISTENER=/tmp
  • End listener.ora *******************
  • Begin tnsnames.ora ****************** v3_db = (DESCRIPTION= (ADDRESS_LIST = (ADDRESS= (PROTOCOL=TCP) (HOST=pmdemo3) (PORT=1521) )) (CONNECT_DATA= (SID=PMV3) ) ) TRACE_FILE_LISTENER=listener.trc
    • End tnsnames.ora ******************
**************************/etc/services clip ************
..
..
LISTENER	1521/tcp
LISTENER        1521/udp

..
..
etc...
  • End /etc/services clip ***********
Received on Sat Jan 13 1996 - 00:00:00 CET

Original text of this message