用PDB 用户在服务器上登陆时,碰到无监听的error:
SQL> conn hr/hr@ORCLPDB;
ERROR:
ORA-12541: TNS:no listener
原因:没有在服务器上的TNS中加入该连接。在tnsnames.ora 中加入如下连接即可:
ORCLPDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dborcl)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCLPDB)
)
)