暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Oracle 可插拔数据库的服务问题

askTom 2018-09-28
737

问题描述

我使用windows server 2012与64位操作系统,并安装Oracle Database 12c企业版12.2.0.1.0-64位生产。
根据以下链接创建可插拔数据库时。
https://www.oracle.com/technetwork/articles/database/multitenant-part1-pdbs-2193987.html

在PDBs中添加服务时,我面临一个问题。

e:\ app \ GROUP1 \ product \ 12.2.0 \ dbhome_1 \ bin>srvctl添加服务-db orcl -s servicepddb11-pdb PDB11
PRCD-1027: 无法检索数据库orcl
PRCR-1070: 无法检查资源ora.orcl.db是否已注册
CRS-0184: 无法与CRS守护进程通信。


所以我也在互联网上搜索这个问题,但我找不到任何合适的解决方案。

专家解答

那篇文章可能应该有更好的背景。当您将数据库服务 (和其他东西) 添加到Oracle Clusterware控制的资源时,您将使用SRVCTL。

如果您没有安装/运行集群软件,而只是运行数据库,则可以通过service_names参数添加服务。例如

--
-- Initial state of listener
--
C:\>lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 01-OCT-2018 09:16:46

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Start Date                21-SEP-2018 12:33:52
Uptime                    9 days 20 hr. 42 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   c:\oracle\product\12.2\network\admin\listener.ora
Listener Log File         c:\oracle\diag\tnslsnr\gtx\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gtx)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "db122" has 1 instance(s).
  Instance "db122", status READY, has 1 handler(s) for this service...
Service "db122XDB" has 1 instance(s).
  Instance "db122", status READY, has 1 handler(s) for this service...
The command completed successfully

--
-- then I alter service_names
--
SQL> alter system set service_names = db122, abc;

System altered.

SQL> alter system register;

System altered.

--
-- New status of listener
--
C:\>lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 01-OCT-2018 09:17:06

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Start Date                21-SEP-2018 12:33:52
Uptime                    9 days 20 hr. 43 min. 13 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   c:\oracle\product\12.2\network\admin\listener.ora
Listener Log File         c:\oracle\diag\tnslsnr\gtx\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gtx)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "ABC" has 1 instance(s).
  Instance "db122", status READY, has 1 handler(s) for this service...
Service "db122" has 1 instance(s).
  Instance "db122", status READY, has 1 handler(s) for this service...
Service "db122XDB" has 1 instance(s).
  Instance "db122", status READY, has 1 handler(s) for this service...
The command completed successfully


但是默认情况下,将为您的容器数据库中的每个PDB自动创建一个服务名称,因此除非您想要 * 其他 * 服务名称,否则您应该可以使用。


「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论