ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Solution:
================
Your problem is solved after bellows two step
1. Regestration you Listener from Dynamically to static like below.
Make a listerner.ora for you database with your DB Information.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = H:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp-bb88068f9f5d)(PORT = 1521))
)
then stop and start the listener.
The data within the SID_DESC section is written about instance is referred to as 'static information' for that instance.
Note : [all static information in the listener.ora is overwritten when the instance is dynamically registered with the listener.]
2. increase PROCESSES parameter in the initSID.ora file or in spfile like
see your alert_log file first.
SQL> alter system set processes = 400 scope=spfile;
reboot the database.
Fedora 41 and Oracle
3 days ago
No comments:
Post a Comment