TNS-12555: TNS:permission denied error resolution

  
 

Oracle 10g + Redhat5, the installation uses everything normal, install user oracle.

Starting sqlplus with oracle user today [abc@rhel4 admin]$ sqlplus /as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 23 12:11:25 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL>

However, start the listener At the time, the error was reported: [abc@rhel4 admin]$ lsnrctlLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2009 12:13:06Copyright (c) 1991, 2005, Oracle. All rights reserved.Welcome to LSNRCTL, type "help" for information.

LSNRCTL> startStarting /u01/app/oracle/product/10.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux : Version 10.2.0.1.0 - ProductionSystem parameter file is /u01/app/oracle/product/10.2.0/network/admin/listener.oraLog messages written to /u01/app/oracle/product/10.2.0/network/Log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.loc Aldomain)(PORT=1521)))Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))) TNS-12555: TNS:permission deniedTNS-12560: TNS:protocol adapter errorTNS-00525: Insufficient privilege for operationLinux Error: 1: Operation not permitted

The log error message shows that it should be related to permissions, and finally found a hidden message,

/var/tmp/.oracle The directory is special. If oracle does not have permission to operate this directory, the oracle user cannot enter the /var/tmp/.oracle folder. The

method is very simple, execute: chmod 777 /var/tmp/. Oracle

After ok.
zh-CN"],null,[0.82551461],zh-CN"]]]

Copyright © Windows knowledge All Rights Reserved