背景

同事安装了一个数据库. 
方式是用 oracle rpm 方式安装与建库
但是发现存在问题: 
数据库链接不上. 
一开始我怀疑是静态注册的问题. 后来发现并不是.
这里记录一下.

监听检查

su - oracle 
lsnrctl status 看到 ready的service 

修改一下监听信息进行处理

注意需要增加的是第一部分:
SID_LIST_LISTENER =
相关的信息.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = cloudpdb)
      (ORACLE_HOME = opt/oracle/product/19c/dbhome_1 )
      (GLOBAL_DBNAME = cloudpdb)
    )
)
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = centos7)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
)

重启监听后信息为:
Service "cloudpdb" has 1 instance(s).
Instance "cloudpdb", status UNKNOWN, has 1 handler(s) for this service...

如果是动态监听, 效果为:

Service "cloudpdb" has 1 instance(s).
Instance "cloudpdb", status Ready, has 1 handler(s) for this service...

重建数据库-PDB

后来发现CDB 是可以连接的, 但是PDB总是不行.
找了公司里面的方神也没给处理好, 怀疑是PDB创建时有问题, 我这边采用 pdb 重建也无效:
alter system set DB_CREATE_FILE_DEST='/oradata/cloudpdb/cloudpdb1' ;
create pluggable database test admin user test identified by Testxxx ; 
alter pluggable database test open ;
发现依旧不可以.

dbca全新建库

dbca -silent -deleteDatabase -sourceDB  $oracle_sid 
# 输入密码
建库
dbca -silent -createDatabase -templateName General_Purpose.dbc \
 -gdbname cloudpdb -sid cloudpdb -responseFile NO_VALUE \ 
 -characterSet ZHS16GBK -datafileDestination oradata/cloudpdb \
 -memoryPercentage 50 -emConfiguration LOCAL 

等待就可以.