LISTENER PROBLEMS

From: avs <avs_at_grands.dp.ua>
Date: Wed, 24 Sep 2003 09:54:58 +0300
Message-ID: <bkrf3s$2fc9$1@pandora.alkar.net>

Excuse me for my bad English

After I've stoping DB (Oracle 9203+Windows 2000 SP4) with "shutdown normal" sqlplus command
and when I try then to start DB with "statup pfile="path_to_init_file"" Oracle said:

ORACLE instance started.
ORA-12500: TNS:listener failed to start a dedicated server process

Command "lsnrctl services" displays

Service "lotos2" has 2 instance(s).
  Instance "lot82", status UNKNOWN, has 1 handler(s) for this service...     Handler(s):

      "DEDICATED" established:0 refused:0
         LOCAL SERVER

  Instance "lot82", status BLOCKED, has 1 handler(s) for this service...     Handler(s):

      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER

The command completed successfully

I've interested why the service statement is BLOCKED?

My listener's files looks like following:

---

listener.ora

---

# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = admin)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)

    )
    (SID_DESC=

        (GLOBAL_DBNAME=lotos2)
        (ORACLE_HOME=d:\oracle\ora92)
        (SID_NAME=lot82)

    )
  )

---

sqlnet.ora

---

# SQLNET.ORA Network Configuration File: d:\oracle\ora92\network\admin\sqlnet.ora # Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES)

---

tnsnames.ora

---

# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

LOTOS2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = lotos2)

    )
  ) Received on Wed Sep 24 2003 - 01:54:58 CDT