2006-5-17 14:51
smallflower
listener.ora作了配置,可是lsnrctl status看不到Service??
listener.ora文件
SID_LIST_P5TEST =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /vol5/ora92/product/9.2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dbtest)
(ORACLE_HOME = /vol5/ora92/product/9.2)
(SID_NAME = dbtest)
)
)
P5TEST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = apstest)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCp5test))
)
)
大侠看看为什么阿
?多谢!
2006-5-18 09:17
SunnyXu
这是我的:
LISTENER_SEC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
)
)
)
SID_LIST_LISTENER_SEC =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = xxx)
(ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
(SID_NAME = xxx)
)
)
lsnrctl stat
LSNRCTL for Linux: Version 8.1.7.4.0 - Production on 18-5月 -2006 09:19:43
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 8.1.7.4.0 - Production
Start Date 10-4月 -2006 09:50:59
Uptime 37 days 23 hr. 28 min. 43 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/8.1.7/network/admin/listener.ora
Listener Log File /oracle/app/oracle/product/8.1.7/network/log/listener.log
Services Summary...
PLSExtProc has 1 service handler(s)
xxx has 1 service handler(s)
The command completed successfully
我可以看到Service
建议你先启动listener,然后再启动database试试。
2006-5-18 11:39
smallflower
找到问题了
停止启动的时间应该用listener stop P5TEST
listener start P5TEST
这样就有了新建库dbtest得service ,怀疑是建库的时候没有正常结束?
应该加上具体的listener 名字,这样就不会只刷新缺省的1istener?
页:
[1]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.