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

Error:

Enter user-name: sys@orcl as sysdba
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Cause:
Listerner does not have information about this service.

Solution:
1. Check listener has register ORCL service as used in SQLPLUS command

lsrnctl service

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IXC1-LT8TBDWT2.FNFIS.com)(PORT=1521)))
Services Summary...
Service "pdb1" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:6 refused:0 state:ready
LOCAL SERVER
Service "xepdb1" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:6 refused:0 state:ready
LOCAL SERVER
The command completed successfully


2. We need to register the service from the ORCL with listener in listener.ora file.
Add manually entry which shown bold below and save listener file and reload the listener(lsnrctl reload).

(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\Oracle\dbhomeXE)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\dbhomeXE\bin\oraclr18.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\Oracle\dbhomeXE)
(SID_NAME = ORCL)
)
)


3. You find the service as ORCL in lsnrctl service command:

Service "ORCL" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER