RAC 两个节点只启动一个的情况下监听问题

[复制链接]
查看11 | 回复2 | 2009-9-27 10:21:22 | 显示全部楼层 |阅读模式
RAC 两个节点只启动一个的情况下,连接不上数据库,监听状态为The listener supports no services,
请问大家是什么原因?
[oracle@rac1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 28 15:26:37 2010
Copyright (c) 1982, 2005, Oracle.All rights reserved.
SQL> connect sys/oracle@devdb as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL> exit
[oracle@rac1 ~]$ lsnrctl
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-OCT-2010 15:27:34
Copyright (c) 1991, 2005, Oracle.All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
status".Try "help"command "
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date
28-OCT-2010 15:26:20
Uptime
0 days 0 hr. 1 min. 22 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.mycorpdomain.com)(PORT=1521)))
The listener supports no servicesThe command completed successfully
LSNRCTL> exit
回复

使用道具 举报

千问 | 2009-9-27 10:21:22 | 显示全部楼层
通过 lsnrctl status 命令返回的结果看,应该是listener.ora 文件没有配相关的服务信息
回复

使用道具 举报

千问 | 2009-9-27 10:21:22 | 显示全部楼层
我试着启动单个节点报错误,请问是什么原因?
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行