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.
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
4096 Columns1 week ago
-
-
-
-
-
-
-
Oracle Cloud & Third party tools4 years ago
-
-
-
Moving Sideways8 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment