For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I am setting my pluggable data base the cmd result "lsnrctl status" with issue here is my listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
SID_LIST_LISTENER = (SID_DESC = (GLOBAL_DBNAME = pbt19c) (ORACLE_HOME = /opt/oracle/product/19.0/dbhome_1) (SID_NAME = pbt19c) ) below is my tnsnames.ora When try to connect with sqlplus, below error shows up ORA-12514: TNS:listener does not currently know of service requested in connect descriptor