Help! SQL*NET 2.0 Listener won't connect on server
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 ***********