监听的问题,再贴些信息出来吧:
1. cmd下lsnrctl services
lsnrctl stop
lsnrctl start
lsnrctl stat
2. listener.ora
3. tnsnames.ora
C:\oracle>sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 2月 17 13:19:19 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. 请输入用户名: sys/licheng@sales as sysdba
ERROR:
ORA-12541: TNS: 无监听程序 C:\oracle\product\10.2.0\crs\BIN>crs_unregister.exe C:\>lsnrctl services LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 15:0
3:18 Copyright (c) 1991, 2005, Oracle. All rights reserved. 正在连接到 (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error C:\>lsnrctl stop LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 15:0
3:26 Copyright (c) 1991, 2005, Oracle. All rights reserved. 正在连接到 (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error C:\>lsnrctl start LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 15:0
3:33 Copyright (c) 1991, 2005, Oracle. All rights reserved. 启动tnslsnr: 请稍候... Failed to open service <OracleOraDb10g_home1TNSListener>, error 1060.
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
系统参数文件为E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入E:\oracle\product\10.2.0\db_1\network\log\listener.log的日志信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac02)(PORT=1521))) 正在连接到 (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
启动日期 17-2月 -2009 15:03:37
正常运行时间 0 天 0 小时 0 分 2 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 E:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 E:\oracle\product\10.2.0\db_1\network\log\listener.log 监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac02)(PORT=1521)))
监听程序不支持服务
命令执行成功 C:\>lsnrctl stat LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 15:0
3:43 Copyright (c) 1991, 2005, Oracle. All rights reserved. 正在连接到 (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
启动日期 17-2月 -2009 15:03:37
正常运行时间 0 天 0 小时 0 分 8 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 E:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 E:\oracle\product\10.2.0\db_1\network\log\listener.log 监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac02)(PORT=1521)))
服务摘要..
服务 "sales.koorka.com" 包含 1 个例程。
例程 "sales1", 状态 READY, 包含此服务的 1 个处理程序...
服务 "salesXDB.koorka.com" 包含 1 个例程。
例程 "sales1", 状态 READY, 包含此服务的 1 个处理程序...
服务 "sales_XPT.koorka.com" 包含 1 个例程。
例程 "sales1", 状态 READY, 包含此服务的 1 个处理程序...
命令执行成功 C:\>
listener.ora内容:
# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools. SID_LIST_LISTENER_RAC02 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
) SID_LIST_LISTENER_RAC01 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
) LISTENER_RAC02 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.152.14.109)(PORT = 1521)(IP = FIRST))
)
) LISTENER_RAC01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.152.14.110)(PORT = 1521)(IP = FIRST))
)
)
tnsnames.ora内容:
# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools. SALES =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sales.koorka.com)
)
) LISTENERS_SALES =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521))
) SALES2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sales.koorka.com)
(INSTANCE_NAME = sales2)
)
) SALES1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sales.koorka.com)
(INSTANCE_NAME = sales1)
)
) EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
系统hosts文件
127.0.0.1 localhost
211.152.14.110 rac01.koorka.com rac01
211.152.14.210 vip01.koorka.com vip01
10.10.10.1 node1211.152.14.109 rac02.koorka.com rac02
211.152.14.209 vip02.koorka.com vip02
10.10.10.2 node2
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_RAC1
mts_listener_address string
mts_multiple_listeners boolean FALSE
remote_listener string LISTENERS_RAC rac2: SQL> show parameter listener NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_RAC2
mts_listener_address string
mts_multiple_listeners boolean FALSE
remote_listener string LISTENERS_RAC
rac3:
SQL> show parameter listener NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_RAC3
mts_listener_address string
mts_multiple_listeners boolean FALSE
remote_listener string LISTENERS_RAC
tnsnames: rac1:
# Generated by Oracle configuration tools. LISTENERS_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
)
RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac2)
)
)
RAC3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac3)
)
) LISTENER_RAC1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac1)
)
) INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
) RAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = rac)
)
)
failover =
(DESCRIPTION =
(enable=broken)
(LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.82)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.83)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(failover_mode=(type=select)(method=basic))
)
)
----------------------------------------------------- rac2:tnsnames
# Generated by Oracle configuration tools. LISTENERS_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
) LISTENER_RAC2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac2)
)
)
RAC3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac3)
)
)
RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac1)
)
) INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
) RAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = rac)
)
)
failover =
(DESCRIPTION =
(enable=broken)
(LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.82)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.83)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(failover_mode=(type=select)(method=basic))
)
)
rac3:tnsnames.
# Generated by Oracle configuration tools. LISTENERS_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
) LISTENER_RAC3 =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac2)
)
)
RAC3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac3)
)
)
RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac1)
)
) INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
) RAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = rac)
)
)
failover =
(DESCRIPTION =
(enable=broken)
(LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.82)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.83)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = rac)
(failover_mode=(type=select)(method=basic))
)
) ==================================================================== listener.ora rac1. # Generated by Oracle configuration tools. LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBSSAPP)(PORT = 1521))
)
)
) SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/rac/oracle/ora9i/app/oracle/product/902)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /oracle/rac/oracle/ora9i/app/oracle/product/902)
(SID_NAME = rac1)
)
)
------------------------------------------------------------- rac2. # Generated by Oracle configuration tools. LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBASAPP)(PORT = 1521))
)
)
) SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/rac/oracle/ora9i/app/oracle/product/902)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /oracle/rac/oracle/ora9i/app/oracle/product/902)
(SID_NAME = rac2)
)
) ----------------------------------------------
rac3. # Generated by Oracle configuration tools. LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBAS)(PORT = 1521))
)
)
) SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/rac/oracle/ora9i/app/oracle/product/902)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /oracle/rac/oracle/ora9i/app/oracle/product/902)
(SID_NAME = rac3)
)
)
========================================================== client:
ractest =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.82)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.36.83)(PORT = 1521))
)
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVICE_NAME = rac)
(FAILOVER_METHOD =
(TYPE = SESSION)
(METHOD = BASIC)
)
)
)
我在创建集群数据库时出现的错误是:
无法启动集群数据库"sales","CRS-0215:无法启动资源'ora.rac02.LISTENER_RAC02.lsnr'."
的节点"[rac02]"上的监听程序
忽略这个错误,就会出现上面的问题
因为一直不了解,vm下到底是怎样模拟磁盘的