ORA-12545 - Netware/Oracle/SQL*Net v2 Problem

From: Maureen T. English <snmte_at_orca.alaska.edu>
Date: 1996/10/09
Message-ID: <325BD653.4B15_at_orca.alaska.edu>#1/1

Hi All,

I know this topic has been discussed before, and some of my questions have been answered already. My problem is that I still can't connect to my database using SQL*Net version 2.

Here's what's been done so far:

1. We have Oracle7 installed on a Novell Netware v3.12 server

    Oracle Installer          3.0.10.3.2
    Oracle7 Server            7.1.4.3.2
    Required Support Files    7.1.4.3.2
    Oracle7 Utilities         7.1.4.3.2
    Oracle Distributed Option 7.1.4.3.2
    Parallel Query Option     7.1.4.3.2
    Oracle Server Manager     2.0.3.0.0

    SQL*Net SPX               1.1.3.0.3   I can connect to the database
                                          using the connect string
                                          X:ORASRV

    SQL*Net                   2.1.4.1.4   I cannot seem to connect to
                                          the database using any
                                          acceptable string

    SQL*Net TCP/IP            1.1.7.2.7

    Oracle TCP/IP Protocol Adapter 2.1.4.1.4

2) There is a database on the Netware server and I can connect to it

    using SQL*Net SPX.

3) From the console I loaded

    TNSLSNR (which also loads NTIT) and
    TCPSRV (which also loads SQLTCP)

    So, I have a listener up and running - as best I can tell. When I loaded lsnrctl and did a status command and a services command, I got information about the listener.

4) I tried to connect to the database using the connect string

    SID.net.alaska.edu, and got the error message     ORA-12545 TNS:name lookup failure. The manual says that there is     something wrong with either the TNSNAMES.ORA or the LISTENER.ORA.

TNSNAMES.ORA looks like (with substitutions for SID, HOST, & SUBNET...):

################


# Filename......: tnsnames.ora

# Name..........: LOCAL.world
# Date..........: 25-AUG-96 10:38:56

################

SID.net.alaska.edu =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


#          (COMMUNITY = TCP.net.alaska.edu)


          (PROTOCOL = TCP)
          (Host = host.net.alaska.edu)
          (Port = 1525)
        )

    )
    (CONNECT_DATA =

       (SID = SID)
       (GLOBAL_NAME = SID.net.alaska.edu)

    )
  )

LISTENER.ORA looks like (with substitutions for SID, HOST, & SUBNET...)

• Note that the commented out lines are directions from Oracle. -

################


# Filename......: listener.ora

# Name..........: host.net.alaska.edu
# Date..........: 16-JUN-96 15:19:31

################

LISTENER =
  (ADDRESS_LIST =
# (ADDRESS=
# (PROTOCOL=IPC)
# (KEY=SID.net.alaska.edu)
# )

        (ADDRESS = 


#           (COMMUNITY = tcpcom.alaska.edu)


          (PROTOCOL = TCP)
          (Host = host.net.alaska.edu)
          (Port = 1525)
        )

  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = SID)
      (ORACLE_HOME = oracle:oranw)
      (PRESPAWN_MAX = 10)

    )
  )

# The following parameters have default values

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF
TRACE_DIRECTORY_LISTENER=oracle:oranw\network\trace
TRACE_FILE_LISTENER=listener.trc

LOG_DIRECTORY_LISTENER=oracle:oranw\network\log LOG_FILE_LISTENER=listener.log

Later, I started lsnrctl and tried a version command and got only a connect line:

connecting to
(ADDRESS=(PROTOCOL=TCP)(HOST=host.net.alaska.edu)(PORT=1525))

and then it seemed to hang....

Can anyone enlighten me to what may be wrong? Is the 1525 causing a problem somewhere that I don't know about?

I do intend to look at the log and even set the trace level higher - but I need to do that when no one is accessing the server. It seems that I can't even stop the listener - it hangs on that command, too, and, I can't unload NTIT.NLM after unloading TNSLSNR.NLM in order to reload TNSLSNR.

Any help will be much appreciated.

Thanks,

Maureen English
University of Alaska
Statewide Financial Systems
snmte_at_orca.alaska.edu Received on Wed Oct 09 1996 - 00:00:00 CEST