Oracle_bug文档
5墨值下载
2018/12/25 文档 1448717.1
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=15fsx5wbd1_897&id=1448717.1 1/5
版权所有 (c) 2018，Oracle。保留所有权利。Oracle 机密。
SCAN Registration Issue: Services Fail to Register to SCAN Listeners (文档 ID 1448717.1)
In this Document
Symptoms
Changes
Cause
Solution
References
APPLIES TO:
Oracle Net Services - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.
This issue might occur in an environment where RAC / SCAN was configured and where the Applications or E-
Business Suite utility AutoConfig was used to configure the database environment. This issue might also occur
when a customer attempts to use a TNS connect string (versus the EZCONNECT setting) for REMOTE_LISTENER
where the single SCAN address is specified. See below.
SYMPTOMS
Services are failing to register in new installation of RAC with SCAN configuration.
Lsnrctl services LISTENER_SCAN<n> shows no services registered.
The REMOTE_LISTENER setting might be set in either of the following 2 ways:
1) REMOTE_LISTENER is set to EZCONNECT style string:
For our example:
REMOTE_LISTENER='SCANHOST:1521'
Where SCANHOST is the SCAN address that resolves to unique ip addresses.
OR:
2) REMOTE_LISTENER is set to a tnsnames entry created by the user where only the SCAN hostname is listed in a
single address:
e.g.
REMOTE_SCAN_LISTENERS=
(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=SCANHOST)(PORT=1521)))
2018/12/25 文档 1448717.1
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=15fsx5wbd1_897&id=1448717.1 2/5
SCANHOST resolves to 2 or 3 unique ip addresses.
CHANGES
This is likely a new installation of RAC with SCAN or this is an EBusiness Suite environment and the
AutoConfig utility has recently been run in this environment. In an E-Business or Applications environment, the
AutoConfig utility might be run to configure the database environment. This could also be a SCAN configuration
and the DBA has chosen to set REMOTE_LISTENER to a tnsnames entry versus the recommended EZCONNECT
style string.
CAUSE
First case example:
If AutoConfig has been run in this environment, it is likely the following bug is involved:
Unpublished BUG:10049430: Issue with S_INSTLOCALLISTENER/REMOTELISTENER Customized Values in
11.2 RAC
AutoConfig will check the value for REMOTE_LISTENER and LOCAL_LISTENER and create a connect string based
on its findings. In our example and due to this defect AutoConfig will create a tnsnames entry for the
REMOTE_LISTENER setting of: SCANHOST:1521
The tnsnames.ora file entry might be in $TNS_ADMIN or $ORACLE_HOME/network/admin.
See also:
Bug:12946495 Services Fail to Register to all SCAN Listeners
There is some mention of this in:
Document 823587.1Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business
Suite Release 12
In this case, per our setting for REMOTE_LISTENER, the tnsnames.ora file entry would look like this:
SCANHOST:1521 =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=SCANHOST)(PORT=1521))
)
)
The issue with AutoConfig should be resolved in release 12.1.2.4 per the following unpublished defect:
BUG:8595044: AUTOCONFIG SUPPORT FOR 11GR2 GRID INFRASTRUCTURE
Second case example:
A similar situation arises when REMOTE_LISTENER is intentionally set to a tnsnames.ora file entry and only the
SCAN hostname is used in the string:
of 5
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论