已解决：ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

 

oracle@hostA:admin $ rman target sys/<passwd>@cdb

Recovery Manager: Release 19.0.0.0.0 - Development on Wed Apr 8 06:19:36 2020
Version 19.1.0.0.0

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: 
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Solution：

SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      cdb.us.oracle.com

SQL> show parameter local_listener 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string       LISTENER_CDB


SQL> create pfile from spfile;

Then remove "local listener" lines in initcdb.ora

SQL> shutdown immediate;
SQL> startup pfile='/u01/oracle/dbs/initcdb.ora';
ORACLE instance started.

Total System Global Area 1.9931E+10 bytes
Fixed Size                 14335872 bytes
Variable Size            2684354560 bytes
Database Buffers         1.7180E+10 bytes
Redo Buffers               52772864 bytes
Database mounted.
Database opened.
SQL> show parameter local_listener 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string

SQL> create spfile from pfile;
SQL> exit