admin 管理员组文章数量: 887021
2023年12月23日发(作者：soapclient卡住php)
PDB2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = omain) ) )vim /opt/oracle/product/12.2.0.1.0/dbhome_1/network/admin/增加 SID_LIST_LISTENER 配置，修改后的内容如下：[oracle@localhost admin]$ cat
# Network Configuration File: /opt/oracle/product/12.2.0.1.0/dbhome_1/network/admin/# Generated by Oracle configuration ER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) #cdb db_name (SID_NAME = ORCL) ) (SID_DESC = (GLOBAL_DBNAME = ORCLPDB) #pdb db_name (SID_NAME = ORCL) ) (SID_DESC = (GLOBAL_DBNAME = PDB2) #pdb db_name (SID_NAME = PDB2) ))重启监听后，再tnsping测试，全部OK：[oracle@localhost admin]$ tnsping orclTNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 21-NOV-2020 21:29:36Copyright (c) 1997, 2016, Oracle. All rights parameter files:/opt/oracle/product/12.2.0.1.0/dbhome_1/network/admin/
Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = omain)))OK (0 msec)[oracle@localhost admin]$
[oracle@localhost admin]$ tnsping orclpdbTNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 21-NOV-2020 21:29:42Copyright (c) 1997, 2016, Oracle. All rights parameter files:/opt/oracle/product/12.2.0.1.0/dbhome_1/network/admin/d TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = omain)))OK (0 msec)[oracle@localhost admin]$
[oracle@localhost admin]$ tnsping pdb2TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 21-NOV-2020 21:29:46Copyright (c) 1997, 2016, Oracle. All rights parameter files:/opt/oracle/product/12.2.0.1.0/dbhome_1/network/admin/d TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = omain)))OK (10 msec)[oracle@localhost admin]$
PDB2连接测试OK：IP:1521ServieNAme: PDB2TEST/1q2w3eORCLPDB连接测试OK:IP:1521ServieNAme: ORCLPDBTEST/1q2w3eCDB连接测试OK：IP:1521ServieNAme: ORCLC##TEST/1q2w3e
版权声明：本文标题：Centos7静默安装Oracle12c(12.2.0.1.0)DBCA创建CDBPDB 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.freenas.com.cn/jishu/1703297832h445947.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论