系统：win7 64位 安装的是oracle xe11.2.0
connect sys/admin as sysdba 没有问题
connect sys/admin@XE as sysdba 提示 ORA-12518 TNS:监听程序无法分发客户机连接
Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Windows\system32>sqlplus/nolog
SQL*Plus: Release 11.2.0.2.0 Production on 星期三 11月 14 22:19:26 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect sys/admin@XE as sysdba
ERROR:
ORA-12518: TNS: 监听程序无法分发客户机连接
SQL> connect sys/admin as sysdba
已连接。
SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 0
log_archive_max_processes integer 4
processes integer 100
SQL> show parameter sessions
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 172
shared_server_sessions integer
SQL> select count(*) from v$session;
COUNT(*)
----------
19