暂无图片
oracle rac的LISTENER_SCAN1能够监听asm实例吗
我来答
分享
Asky
2023-09-26
oracle rac的LISTENER_SCAN1能够监听asm实例吗

[grid@rac03 ~]$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 26-SEP-2023 14:49:52

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 26-SEP-2023 09:19:53
Uptime 0 days 5 hr. 29 min. 58 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/grid/grid_home/11.2.0.4/network/admin/listener.ora
Listener Log File /u01/grid/grid_home/11.2.0.4/log/diag/tnslsnr/rac03/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.199)(PORT=1521)))
Services Summary...
Service "service_s1" has 1 instance(s).
Instance "slnngk1", status READY, has 1 handler(s) for this service...
Service "service_s2" has 1 instance(s).
Instance "slnngk1", status READY, has 1 handler(s) for this service...
Service "service_s3" has 1 instance(s).
Instance "slnngk1", status READY, has 1 handler(s) for this service...
Service "slnngk" has 3 instance(s).
Instance "slnngk1", status READY, has 1 handler(s) for this service...
Instance "slnngk2", status READY, has 1 handler(s) for this service...
Instance "slnngk3", status READY, has 1 handler(s) for this service...
Service "slnngkXDB" has 3 instance(s).
Instance "slnngk1", status READY, has 1 handler(s) for this service...
Instance "slnngk2", status READY, has 1 handler(s) for this service...
Instance "slnngk3", status READY, has 1 handler(s) for this service...
The command completed successfully

发现这里scan listener没有监听asm实例。

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
范伟林

登录asm实例,设置remote_listener参数

暂无图片 评论
暂无图片 有用 5
打赏 0
暂无图片
回答交流
Markdown


请输入正文
提交
相关推荐
Oracle 一个表空间由单个数据文件和多个数据文件组成,在性能上有什么差异吗?
回答 2
已采纳
多个。读写会稍微好一些。另外一个有时候也放不下。
oracle rac涉及到的所有端口都有哪些 ?5989和3872 这两个端口是什么组件的?
回答 1
已采纳
3872好像是OEMagent使用的端口5989好像是存储使用的协议端口oracle随机端口很多,可以参考安装时有设置内核参数net.ipv4.iplocalportrange900065500ora
dblink故障
回答 4
通过查看awr,发现dblink虽然排在topevent,但是如下索引对象激烈的热块竞争/itl/rowlock,似乎这个对象相关的sql跟逻辑需要重点关注一下::RFINDXUNIIOLOGINDE
oracle如何使用触发器将A表的指定字段同步到B表
回答 3
已采纳
createorreplacetriggerafterupdateonEMPAforeachrowdeclarebeginif:old.updatetime<>:new.updatetim
集群异常后一个节点无法启动,故障节点找不见/u01/app/11.2.0/grid目录
回答 5
如果是删除了还有办法恢复嘛,还是只能重新部署集群
linux rman 备份集 到win下还原会有坏块,linux 端 validate database 检测,又检测不到坏块,这是为什么?
回答 3
源端是哪,目标端是哪。考虑传输、操作系统编码等情况
有没遇到12c,crs挂掉了,但是数据库和asm是ok的,上网查了下,说是个bug
回答 1
什么Bug?不止在12c中遇到过,都是crsctlstartrescrsdinit启动
提供下19.7.0.0.0的RU p30869156_190000_Linux-x86-64.zip
回答 3
最新的RU更好Patch33806152:DATABASERELEASEUPDATE19.15.0.0.0
windows下OGG extract 进程一直显示Sending START request to MANAGER ('GGMGR') ... EXTRACT EXT_HZ starting 请问是什么情况
回答 2
1、确认下进程是否running2、确认下是否已经添加表级trandata3、同时看下ggserr.log里有无相关信息
进入oracle容器后执行exp命令,导出a.dmp的备份文件,当删除之前备份,多次备份a.dmp,linux环境找不到a.dmp
回答 1
已采纳
oracle容器指的是docker容器的话,a.dmp还在docke内,你需要将其dockercp到Linux文件系统。例如:从容器59拷贝到文件系统dockercpe3fed7f659:/var/l