Did You Know #24 – Blocked Instances

存储架构 amitzil (源链)

Even after years of working with something, you can always learn new stuff. Today I tried to create a standby database using the duplicate command. When you duplicate a database you need to connect to both instances (primary as target and standby as auxiliary) using SQL*Net (and not “/”). Since the standby is in nomount, the listener blocks connections to it, so when trying to connect to it using the listener we get “ORA-12528: TNS:listener: all appropriate instances are blocking new connections”.

Usually I just create a static registration entry in the listener.ora file and bounce the listener, this time I didn’t want to (this is a RAC environment with a lot of instances and I didn’t want to start playing with the listener.ora file and bounce the listener).

Searching for this issue I found a really cool trick. A small addition to the tnsnames.ora allows the client to connect to an instance, even if it’s in BLOCKED mode (when the instance is started or mounted).

This is what the tnsnames entry should look like (note the “(UR=A)” after the service_name):



(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))



(SERVICE_NAME = mydb) (UR=A)



I couldn’t find anything about that in the documentation, but MOS has a note
about that.


给梦梦的debug本子 debug的关键: 复制/提炼关键词,比如把个人项目的名字,个人的变量名这些网上不可能有人跟你一样的东西都删除掉,到网上搜索。 尽可能利用二分法打印,确定程序出错的部位,具体哪一个语句 获取出错位置的上下文,...
Texas Child Abuse Data: The Grim Count Credit the Austin (Texas) American Statesman with assuming the most disagreeable, but perhaps necessary, task of recording and expounding instances of...
Pretty Patterns All in a Row Now that I have things mostly sorted out let's actually do some code or at least some pseudo-code on how I going to make it work. I could go the pur...
Back to the Big Easy and SQL Saturday #628 in Bato... I’ve been fortunate enough to get to the Baton Rouge SQL Saturday a number of times. I think I’ve been 3 times and am heading back in a week for m...
GreenPlum数据库故障恢复测试 本文介绍gpdb的master故障及恢复测试以及segment故障恢复测试。 环境介绍: Gpdb版本:5.5.0 二进制版本 操作系统版本:CentOS linux 7.0 Master segment: hostname: mfsmaster...
责编内容来自:amitzil (源链) | 更多关于

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » Did You Know #24 – Blocked Instances

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录