Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Denied Connection to SID using SQL*Plus
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
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 #
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 =
listenr.ora
LISTENER =
(ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= ORCL)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= nucleus3.fortusgen.com)(Port=1521))
(GLOBAL_DBNAME= nucleus3.fortusgen.com) (ORACLE_HOME= /home/oracle/u01/app/oracle/product/8.0.5) (SID_NAME = ORCL)
(SID_NAME = extproc) (ORACLE_HOME = /home/oracle/u01/app/oracle/product/8.0.5) (PROGRAM = extproc)
![]() |
![]() |