Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Denied Connection to SID using SQL*Plus

Denied Connection to SID using SQL*Plus

From: TH Lim <sshark_at_tm.net.my>
Date: Wed, 05 May 1999 01:31:04 GMT
Message-ID: <372f9f55.170892240@news.newsguy.com>


Hi,

I used SQL*Plus 8.0.3.0.0 to connect to Oracle 8.0.5(Linux) and the error returned was "ORA-12500: TNS listener failed to start a dedicated server process". The listener log showed,

03-MAY-99 19:09:17 *

(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\ORANT\BIN\PLUS80.e
xe)(HOST=RRP)(USER=sshark))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.130)(PORT=
1682)) * establish * ORCL * 12500
TNS-12500: TNS:listener failed to start a dedicated server process  TNS-12546: TNS:permission denied
  TNS-12560: TNS:protocol adapter error    TNS-00516: Permission denied
    Linux Error: 13: Permission denied

What could be the possible error and what is Linux error 13? I checked my tnsnames.ora and listener.ora (included), it seems right to ME.

#
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#

extproc_connection_data =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(CONNECT_DATA = (SID = extproc))

  )

ORCL =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= nucleus3.fortusgen.com)(Port=
1521))

(CONNECT_DATA = (SID = ORCL))

  )

WINNT =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= nucleus1.fortusgen.com)(Port=
1521))

(CONNECT_DATA = (SID = ORCL))

  )

ORCL_BEQ =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM =
/home/oracle/u01/app/oracle/product/8.
0.5)

               (argv0 = oracleORCL)
               (args = '(DESCRIPTION =
(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
               (envs =

'ORACLE_HOME=/home/oracle/u01/app/oracle/product/8.0.5,OR ACLE_SID=ORCL')
    )
  )

listenr.ora


LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= ORCL))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= nucleus3.fortusgen.com)(Port=
1521))
  )
SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
      (GLOBAL_DBNAME= nucleus3.fortusgen.com)
      (ORACLE_HOME= /home/oracle/u01/app/oracle/product/8.0.5)
      (SID_NAME = ORCL)

    )
(SID_DESC =
      (SID_NAME = extproc)
      (ORACLE_HOME = /home/oracle/u01/app/oracle/product/8.0.5)
      (PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF Received on Tue May 04 1999 - 20:31:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US