Recently, you need to perform some stored procedure tests. You can only test the stored procedure in your local database instance. The results show that an error occurred while logging on to the previously created database instance.
The error message is as follows:
ORA-12514: TNS: Listeners Program The service that cannot identify the request in the connection Descriptor
I found a lot of information on the Internet and finally solved the problem.
I installed the Oracle 10g server and found my installation directory.
Path-"F: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin \
Find the file listener. ora in this directory.
Add the red section to listener. ora:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Program = EXTPROC)
)
(Sid_desc =
(Global_dbname = test) -- Mestest: name of the database you created
(ORACLE_HOME = F: \ oracle \ product \ 10.2.0 \ db_1)
(Sid_name = test)
)
)
After modification, save the file and restart the tnslistener listening service.
