Re: TNS Errors - Need some Help!

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 13 Aug 1999 15:04:18 -0700
Message-ID: <37B49662.6C1B7711_at_vnl.nl>

Dirk Freise wrote:

I am a student at an intership. We are runing a Oracle 8.0.5 on Red Hat
Linux 5.2

While startup the Listener they are the follow Errors:

TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Linux Error: 13: Permission denied
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))
TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied

At Red Hat 5.1 the Listener start without any error
What I had made wrong with Red Hat 5.2  ??? What need to do to eleminate the
errors?

thanks

LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 13-AUG-99 09:47:35

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Starting /database/oracle/app/oracle/product/8.0.5/bin/tnslsnr: please
wait...

TNSLSNR for Linux: Version 8.0.5.0.0 - Production
System parameter file is
/database/oracle/app/oracle/product/8.0.5/network/admin/listener.ora
Log messages written to
/database/oracle/app/oracle/product/8.0.5/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=cds))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=172.16.4.1)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=cds))
TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Linux Error: 13: Permission denied

If cds is *not* your SID, I can explain this. If it isn't, it looks like a permission error.

 
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))
TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Linux Error: 13: Permission denied

PNPKEY is your Plug-n-Play key, and this assumes a Well Known Names Server to be present.
If there isn't (did you install Oracle Names somewhere?), it is save to remove that from listener.ora

 
Connecting to
(ADDRESS=(PROTOCOL=TCP)(Host=www2.edw.regiocom.net)(Port=1521))

That seems to work; you can connect using tcp. However, for local connections, this is about
5 times slower than ipc. I did not see a sid descriptor for tcp either, so the question remains
what your sid is.

 
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.0.5.0.0 - Production
Start Date                13-AUG-99 09:47:38
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File
/database/oracle/app/oracle/product/8.0.5/network/admin/listener.ora
Listener Log File
/database/oracle/app/oracle/product/8.0.5/network/log/listener.log
Services Summary...
  cds  has 1 service handler(s)
  extproc  has 1 service handler(s)
The command completed successfully

 
 

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
V&L Informatica BV                   Hunzestraat 4
Palandijn 3, 7521 PN Enschede        7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046
053-4341500
  Received on Sat Aug 14 1999 - 00:04:18 CEST