Oracle Internet access and Oracle Internet access

Oracle Internet access and Oracle Internet access

Environment: centos7 + oracle 11gr2

Public Network: fixed IP Address

Symptoms: port 1521 is normal, netmanager configuration test is normal, plsql connection prompts ORA-12514: TNS: listener does not currently know of service requested in connect descriptor

Solution:

AddSID_LIST_LISTENER=

 

LISTENER=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = tcp) (HOST = sales-server) (PORT = 1521 ))

(ADDRESS = (PROTOCOL = ipc) (KEY = extproc ))))

SID_LIST_LISTENER=

(SID_LIST =

(SID_DESC =

(SID_NAME = plsextproc)

(ORACLE_HOME =/oracle10g)

(PROGRAM = extproc )))

 

Reference: https://docs.oracle.com/cd/B28359_01/network.111/b28316/listenercfg.htm