如何使用新创建的LISTENER注册可插拔数据库(PDB) [英] How to Register Pluggable Database(PDB) with new created LISTENER
问题描述
我正在使用 centos 7
中的 Oracle 19c
.安装Oracle之后,我使用DBCA用可插拔数据库(PDB)创建了新的容器数据库(CDB).
I am working with Oracle 19c
in centos 7
. After Oracle installation, i created new Container Database(CDB) with Plugguble Database(PDB) using DBCA.
我正在使用端口号= 1522
[oracle@ol8-19 ~]$ lsnrctl start LISTENER_TST
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-AUG-2020 16:02:02
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /opt/Oracle19c/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/Oracle19c/network/admin/listener.ora
Log messages written to /opt/oraclebase19c/diag/tnslsnr/ol8-19/listener_tst/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ol8-19.localdomain)(PORT=1522)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ol8-19.localdomain)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER_TST
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 17-AUG-2020 16:02:02
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/Oracle19c/network/admin/listener.ora
Listener Log File /opt/oraclebase19c/diag/tnslsnr/ol8-19/listener_tst/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ol8-19.localdomain)(PORT=1522)))
The listener supports no services
The command completed successfully
这是我的 Listener.ora 文件.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
LISTENER_TST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ol8-19.localdomain)(PORT = 1522))
)
)
这是我的 tnsnames.ora 文件.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = ol8-19.localdomain)(PORT = 1521))
LISTENER_ABC =
(ADDRESS = (PROTOCOL = TCP)(HOST = ol8-19.localdomain)(PORT = 1522))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ol8-19.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ABC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ol8-19.localdomain)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ABC)
)
)
我的可插入数据库名称是PDB.如何通过1522端口向侦听器注册PDB?
My pluggable Database name is PDB. How can i Register PDB with my listener with port 1522??
推荐答案
连接到空闲实例并启动该实例
Connect to an idle instance and startup the instance
[oracle@ol8-19 ~]$ sqlplus / as sysdba
SQL> startup;
将容器更改为该可插入数据库
change container to that pluggable database
SQL> alter session set container=pdb;
Session altered.
然后打开
SQL> alter pluggable database pdb open;
现在,您设置 local_listener
SQL> alter system set local_listener='(address=(protocol=tcp)(host=ol8-19.localdomain)
(port=1522))' scope=spfile;
System altered.
并发出以下命令以便立即注册服务
and issue the following command in order to register the service immediately
SQL> alter system register;
System altered.
并重新启动可插拔数据库
and restart pluggable database
SQL> alter pluggable database pdb close immediate;
SQL> alter pluggable database pdb open;
SQL> exit;
然后启动监听器
[oracle@ol8-19 ~]$ lsnrctl start
并重新检查侦听器的当前状态
and recheck listener's current status
[oracle@ol8-19 ~]$ lsnrctl status
应该在半分钟内开始.
这篇关于如何使用新创建的LISTENER注册可插拔数据库(PDB)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!