lsnrctl 中 关于status 状态的说明，lsnrctlstatus
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lixora)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 11-AUG-2014 00:42:37
Uptime 0 days 0 hr. 24 min. 32 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u02/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lixora)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora10g" has 1 instance(s).
Instance "ora10g", status READY, has 1 handler(s) for this service...
Service "ora10gXDB" has 1 instance(s).
Instance "ora10g", status READY, has 1 handler(s) for this service...
Service "ora10g_XPT" has 1 instance(s).
Instance "ora10g", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
关于‘Instance "ora10g", status READY, has 1 handler(s) for this service...’
中status 状态解释：
这个status 指的的是instance 的状态
Instance Specifies the name of the instance associated with the service along
with its status and number of service handlers associated with the
service
Status can be one of the following:
■ A READY status means that the instance can accept connections.
-----实例是动态由pmon注册，所以显示的status 当然是‘ready’
■ A BLOCKED status means that the instance cannot accept connections.
-----实例无法接受连接，一般是实例处于nomount 状态下，pmon 无法将注册到监听，因为这时数据库还没有打开pmon无法确定db能否对外服务
■ A READY/SECONDARY status means that this is a secondary instance in an Oracle9 i Real Application Clusters
primary/secondary configuration and is ready to accept connections.
■ An UNKNOWN status means that the instance is registered statically in the listener.ora file rather than dynamically
with service registra tion. Therefore, the status is non known.
------这个‘unknown’ 表征实例是静态注册到监听
你是否是用administrator用户登录并运行的，如果不是请用administrator用户执行，或进行如下操作后用普通用户执行。
1。管理员登录，控制面板->管理工具->本地安全策略
2.本地策略->用户权限分配->创建全局对象->双击->添加用户或组
3.将需要的用户或组添加到列表当中，确定保存
4.普通用户注销后重新登陆即可。
还有查看一下oracle是否启动成功了，在cmd 中输入 lsnrctl status 如出现类似4行说明启动成功：
服务 "PLSExtProc" 包含 1 个例程。
例程"PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "orcl" 包含 1 个例程。
例程 "orcl", 状态 READY, 包含此服务的 1 个处理程序...
服务 "orclXDB" 包含 1 个例程。
例程 "orcl", 状态 READY, 包含此服务的 1 个处理程序...
服务 "orcl_XPT" 包含 1 个例程。
例程 "orcl", 状态 READY, 包含此服务的 1 个处理程序...
还有就是删除neyca
在命令行输入netca
然后不是有监听配置么，点删除，然后删除之后点新建
直接下一步下一步，就OK了！很简单的！
楼上的也是一种方法，不过对于新手来说可能不太清楚。我补充下
1.在运行中输入lsnrctl start试试
2.到开始-程序-Oracle home/配置和移植工具/Net Manager中为监听器添加一个服务名
3.在Oracle安装目录下有一个文件名叫NETWORK/ADMIN/tnsnames.ora的文件，打开后看前面的语句 比如
test1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.56)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test1)
)
)
你在此文件复制粘贴，把test1换成你的数据库实例名/服务名 Ip地址换成你的Oracle数据库的服务器IP地址，我想就可以连上了