ORA-12500

From
Oleg Khrulev (2:5020/175.2)
To
All (2:5054/37.63)
Date
2005-04-13T16:48:24Z
Area
RU.RDBMS.ORACLE
From: "Oleg Khrulev" <oleg@prologue.rustel-net.ru>

Hi All,

После установки при попытке коннекта к базе Oracle 10g с помощью Toad 8.0
вылетает следующая ошибка:

"ORA-12500:  TNS:Listener failed to start a dedicated server process"

В чем причина? Как исправить? Переустановка не помогла.

Файлы конфигурации:
=========================================================================
# listener.ora 

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle10g\product\10.1.0\Db_2)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = oleg)(PORT = 1521))
      )
    )
  )
=========================================================================
# tnsnames.ora

GAME =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oleg)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = GAME)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
=========================================================================
# sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
=========================================================================

Олег

--- ifmail v.2.15dev5
 * Origin: FidoNet Online - http://www.fido-online.com (2:5020/175.2)
SEEN-BY: 50/203 450/186 451/30 452/25 454/9 461/33 74 106 640 464/34 465/204
SEEN-BY: 469/125 550/5068 4623/56 4625/9 4626/100 4641/444 4646/1 4653/10
SEEN-BY: 4657/50 5001/5001 5002/76 5002 5003/34 57 5004/58 5010/53 5011/13
SEEN-BY: 5015/4 28 5020/20 52 104 115 128 150 175 400 401 545 600 639 642 715
SEEN-BY: 5020/758 794 894 921 968 982 1100 1169 1212 1234 1356 1604 1626 1642
SEEN-BY: 5020/1873 1930 2020 2200 2238 4400 4441 5021/3 44 5022/128 5023/11
SEEN-BY: 5025/19 151 750 5026/45 78 5030/69 195 382 920 966 1016 1063 1339
SEEN-BY: 5030/1900 5032/11 16 5033/21 35 5034/8 5035/10 5036/13 5037/21
SEEN-BY: 5040/33 47 5041/4 10 5042/13 5045/7 42 5049/157 5050/9 41 5051/35
SEEN-BY: 5053/16 5054/1 8 9 28 35 37 45 50 5056/16 5058/77 5059/20 5060/90
SEEN-BY: 5062/1 5063/5 41 51 5064/7 35 36 5070/26 66 1222 5071/22 5079/23 49
SEEN-BY: 5080/80 1003 5082/6 5083/13 21 5090/23 5093/27 5100/113 6000/12
PATH: 5020/175 4441 52 5054/1 37