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

Question

Oracle

My listener.ora:

# LISTENER =
#  (ADDRESS_LIST=
#	(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
#	(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))	

# SID_LIST_<lsnr>
#   List of services the listener knows about and can connect 
#   clients to.  There is no default.  See the Net8 Administrator's
#   Guide for more information.
#
# SID_LIST_LISTENER=
#   (SID_LIST=
#	(SID_DESC=
#			#BEQUEATH CONFIG
#          (GLOBAL_DBNAME=orz)
#          (SID_NAME=ORZ)
#          (ORACLE_HOME=c:/oracle/product/12.1se/)
#			#PRESPAWN CONFIG
#         (PRESPAWN_MAX=20)
#	  (PRESPAWN_LIST=
#           (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
#         )
#        )
#       )

There is no SERVICE_NAME parameter in tnsnames.ora

Answer 1

In your listener.ora, all lines are commented out (The # sign comments on a line)