Net8 configuration - external procedures

From: <toffermann_at_my-deja.com>
Date: Tue, 08 Feb 2000 12:32:33 GMT
Message-ID: <87p2d1$cua$1@nnrp1.deja.com>

I've installed Oracle8i on RedHat Linux 6.1 and I have been trying for the last couple of days to get Net8 configured properly for external procedures and I've been having NO luck. When I test with tnsping, I get the following error:

[oracle_at_fred oracle]$ tnsping extproc_connection_data

TNS-03505: Failed to resolve name

However, when I try connecting via TCP, I have no problem:

[oracle_at_fred oracle]$ tnsping ora8.fred.selectstuffers.com

Attempting to contact
(address=(protocol=tcp)(port=1521)(host=fred.selectstuffers.com))
OK (10 msec)

When I start the listener, everything seems OK:

[oracle_at_fred oracle]$ lsnrctl start

LSNRCTL for Linux: Version 8.1.5.0.0 - Production on 08-FEB-00 04:11:17

Starting /ora8/m01/app/oracle/product/8.1.5/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.1.5.0.0 - Production System parameter file is
/ora8/m01/app/oracle/product/8.1.5/network/admin/listener.ora Log messages written to
/ora8/m01/app/oracle/product/8.1.5/network/log/listener.log Listening on:
(address=(protocol=tcp)(host=fred.selectstuffers.com)(port=1521))
Listening on: (address=(protocol=ipc)(key=extproc0)) Listening on: (address=(protocol=ipc)(key=ora8))

Connecting to
(address=(protocol=tcp)(host=fred.selectstuffers.com)(port=1521))
STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.1.5.0.0 -
Production
Start Date                08-FEB-00 04:11:17
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/ora8/m01/app/oracle/product/8.1.5/network/admin/listener.ora Listener Log File
/ora8/m01/app/oracle/product/8.1.5/network/log/listener.log Services Summary...

  ora8		has 1 service handler(s)
  plsextproc		has 1 service handler(s)

The command completed successfully

But even though the listener reports that it is listening for extproc0, it doesn't seem to be working. From what I have read on this newsgroup, the most common reasons for external procedures not working are incorrect listener.ora, tnsnames.ora, and sqlnet.ora files. Here is my listener.ora file:

listener =

(address_list =
(address = (protocol = tcp)(host = fred.selectstuffers.com)(port = 1521))

     (address = (protocol = ipc)(key = extproc0))
     (address = (protocol = ipc)(key = ora8))
     (protocol_stack =
       (presentation = ttc)
       (session = ns)
     )

)

sid_list_listener =
(sid_list =
(sid_desc =

      (sid_name = plsextproc)
      (oracle_home = /ora8/m01/app/oracle/product/8.1.5)
      (program = extproc)

)
(sid_desc =

      (global_dbname = ora8.fred.selectstuffers.com)
      (oracle_home = /ora8/m01/app/oracle/product/8.1.5)
      (sid_name = ora8)

)
)

Here is my tnsnames.ora file:

extproc_connection_data =
  (description =
    (source_route = off)
    (address_list =
      (address = (protocol = ipc)(key = extproc0))     )
    (connect_data =
      (sid = plsextproc)
    )
  )

ora8.fred.selectstuffers.com =
  (description =
    (address_list =
      (address = (protocol = tcp)(port = 1521)(host = fred.selectstuffers.com))

    )
    (connect_data =
      (service_name = ora8.fred.selectstuffers.com)     )
  )

And here is my sqlnet.ora file:

names.default_domain = fred.selectstuffers.com sqlnet.expire_time = 0
names.directory_path = (tnsnames)

Can someone help me troubleshoot this? I would greatly appreciate it. I'm completely stuck and have no idea of what to try next!

Thanks,
Tom

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 08 2000 - 06:32:33 CST