ORA-12514 and ORA-28547 troubleshooting
Oracle 10 Gb is installed on the local machine. The website is dynamically obtained by the company. It is normal to log on to the database with SQL plus. When you open the database with pl/SQL, the error "ORA-12514: TNS: Listeners cannot identify the Service requested in the connection descriptor" is reported ".
Solution:
Open the oracle \ product \ 11.1.0 \ db_1 \ network \ admin \ listener. ora file with the following content:
# Listener. ora Network Configuration File: D: \ oracle \ product \ 10.1.0 \ db_1 \ network \ admin \ listener. ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D: \ oracle \ product \ 10.1.0 \ db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC ))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))
)
)
)
Change (SID_NAME = PLSExtProc) to (SID_NAME = orcl) and restart listener.
Log On again with pl/SQL with the error "ORA-28547: TNS: failed to connect to the server, may be a Net8 management error ."
Delete (PROGRAM = extproc) from the above file, restart listener, and log on to the system using pl/SQL. I don't know why.