oracle 监听程序服务无法启动,ORA-12500: TNS: 监听程序无法启动专用服务器进程-优快云博客

环境： windows 2003 oracle9i 单机

C:\Windows\System32>sqlplus "scott/oracle"@test"

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 7月 30 09:10:18 2014

ERROR:

ORA-12500: TNS: 监听程序无法启动专用服务器进程

查看alert.log 没有相关报错，

查看监听日志：

29-7月 -2014 16:45:35 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=

(PROTOCOL=tcp)(HOST=192.168.56.5)(PORT=1430)) * establish * orcl * 12500

TNS-12500: TNS：监听器未能启动专用的服务器进程

TNS-12546: TNS: 拒绝许可

TNS-12560: TNS: 协议适配器错误

TNS-00516: 拒绝许可

32-bit Windows Error: 5: Input/output error

查看配置：

SQL> show parameter shared_server

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

max_shared_servers integer 20

shared_server_sessions integer 330

shared_servers integer 1

SQL> show parameter dispatchers

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

dispatchers string (PROTOCOL=TCP) (SERVICE=orclXD

max_dispatchers integer 5

mts_dispatchers string (PROTOCOL=TCP) (SERVICE=orclXD

mts_max_dispatchers integer 5

查看监听配置：

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-b467a628)(PORT = 1521))

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = C:\oracle\ora92)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = C:\oracle\ora92)

(SID_NAME = orcl)

)

sqlnet 配置：

# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora

# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

客户端tns配置;

test =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

tnsping :

C:\Windows\System32>tnsping test

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 30-7月 -2014 11:04:40

已使用的参数文件:

D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.5)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME

= orcl)))

OK (40 毫秒)

修改成共享模式后，重启数据库，重启监听，错误依旧：

SQL> show parameter shared_servers

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

max_shared_servers integer 20

shared_servers integer 0

SQL>

SQL> show parameter disp

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

dispatchers string (protocol=tcp)(dispatchers=0)

max_dispatchers integer 5

mts_dispatchers string (protocol=tcp)(dispatchers=0)

mts_max_dispatchers integer 5

SQL>

C:\Windows\System32>sqlplus "scott/oracle"@test"

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 7月 30 10:34:17 2014

ERROR:

ORA-12500: TNS: 监听程序无法启动专用服务器进程

SQL> show parameter sga

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

lock_sga boolean FALSE

pre_page_sga boolean FALSE

sga_max_size big integer 135338868

SQL> show parameter pga

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

pga_aggregate_target big integer 41943040

SQL>

修改pga :

alter system set pga_aggregate_target=100M scope=spfile;

重启oracle,监听，还是报错。。

有高手知道什么原因吗？