ORA-12514: TNS: Listener Could Not Resolve SERVICENAME Given in Connect Descriptor. Something went wrong on our end. Please try again later. 1) Go to 'Net Manager' in 'Configuration and Migration tools'. 3) Change 'Listening Locations' tab to 'Database Services'. 4) Add your DB entry by giving your DB SID,Name and Oracle Home directory. 4) Select Save from file menu and save that. 6) Restart your DB and Listener service. ORA-12514: TNS: Listener does not currently know of service requested in connect descriptor How do I prevent this form of the ORA-12514 error? Also, I often get a TNS-12514 along with the ORA-12514. Are these the same error? If not, how do I avoid the TNS-12514? ORA-12514 TNS:listener does not currently know of service requested in connect descriptor #389 gunkaragoz opened this issue Sep 11, 2018 16 comments Comments. ORA-12514: TNS:listener could not resolve SERVICENAME given in= connect descriptor SQL What is puzzling to me is that if i issue the oradim -shutdown= followed by the oradim -startup commands the database is then= open and I am able to connect to it and execute sql commands ok=2E= I think my problem lies in the listener file as when i check=.
Active2 years ago
I run an instance of Oracle 11g locally on my development machine and can connect to the local instance directly via SqlPlus:
But I cannot connect to it via the listener:
Similarly, if I connect via SqlDeveloper I get an error (albeit
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
). This instance has been stable and working fine for a year or more until today, a Monday morning. Our corporate IT do sometimes push new policies and updates over the weekend, so I'm assuming that something has changed, but I've not been able to work out what.
I've restarted the service and the listener several times, the listener log doesn't give any clues.
The listener seems fine:
Port 1521 seems ok:
(PID 4368 is TNSLSNR.exe process.)
Also, I can
tnsping
to the XE service: The
listenerr.ora
file: Additionally, and I've no idea if it is related, I can't seem to access apex on
https://127.0.0.1:8080/apex
(even though the permissions for that seem fine). So where else should I be looking?
Update with requested information:
Update2: as @miracle173 correctly points out, the listener was not fine. With the updated 'local_listener' parameter now shows extra information:
Unsliced
UnslicedUnslicedOra-12504
33611 gold badge22 silver badges1313 bronze badges
1 Answer
Gps apps for ipad. So, with thanks to @YasirArsanukaev for the time he put in, I have found a solution which works, but which I can't really explain.
Riffing on the
LOCAL_LISTENER
thought, I was reading this other answer where it said: The database uses the LOCAL_LISTENER parameter to identify the listener it should register with. By default that is null, which according to the documentation is equivalent to hostname:1521.
So I tried to ping my own hostname and couldn't - it looks like some IPv6 problem, receiving a general failure message.
So I took the advice from that answer
and it now works, presumably because it can resolve the localhost reference, where it was failing the resolve the actual hostname.
Community♦
UnslicedUnsliced33611 gold badge22 silver badges1313 bronze badges
protected by Community♦Sep 20 '17 at 17:48
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged oracleoracle-11glistener or ask your own question.
Active3 days ago
Ora 12514 Error
I have configured oracle 12c on Rhel 7. When I try to connect database using following command it gets connected with no issues:
I'm facing problem when I try to put the connection string with
hostname
and port
as shown below:Error occurred is
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
I have gone through the questions asked before, but none of them helped me solve this problem.
Following are my
tnsnames.ora
, sqlnet.ora
and listener.ora
files.tnsnames.ora
listener.ora Free script font with swash.
sqlnet.ora
hosts file
Marco3,74033 gold badges1818 silver badges2424 bronze badges
Abhaya GhatkarAbhaya Ghatkar
4 Answers
Since you have the following error message that mean either
hostname
is not correct and/or the domain you are using.How to know if everything is working fine or not?You need to execute
hostname
command, lets say the output is oracle_12C
, and execute cat /etc/resolve.con
lets say the domain name mydomain.com
, then you need to edit /etc/hosts
like the followingNote if you are not using domain then
/etc/hosts/
should be like the followingNow lets move to
tnsnames.ora
, inside this file you need to search for your database section (in your question orcl) replace it like the following (note you need to take a backup from this file before doing any changes):Note for host if you have doming then
HOST = oracle_12C.mydomain.com
, else it should be HOST = oracle_12C
Now save the file and close it.
After that lets move to
listener.ora
, take a backup from it and edit it like the following:Now restart your listener by executing
Ahmad AbuhasnaAhmad Abuhasnalsnrctl stop
and lsnrctl start
then try to connect to the database by using the following commands2,11833 gold badges1616 silver badges3131 bronze badges
Ora-12514 Oracle Xe Windows
Below process is solved my problem.
- Connect to server using sqlplus / as sysdba command
- check whether local listener exists or not by using SQL> show parameter local_listener command. For me local_listener value is empty
- set the listener dynamically by usingSQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=LOCALHOST)(PORT=1521))' scope=both; command
- Then do register by using alter command SQL> alter system register;
- Now check whether listener is added or not SQL> show parameter local_listener.Now listener is added successfully with Value = (ADDRESS=(PROTOCOL=TCP)(HOST=LOCALHOST)(PORT=1521))
- After adding local listener I am able to connect successfully.
Ora-12514 Oracle 12c Windows 10
prasadgprasadg
Make sure your host should be 0.0.0.0 in listener.ora and tnsnames.ora.
Also you must register your SID_name in listner.ora as mentioned below.for example if your SID_NAME is ORCLCDB, listener.ora should look like this.
The tnsnames.ora file should look like this.
hot2use9,27555 gold badges2626 silver badges6363 bronze badges
Prateek SenPrateek Sen
Below worked for me:
- Checked services using
services.msc
- Restarted the services
OracleOraDB12Home1TNSListener
andOracleServiceORCL
After that connected using SQL developer. It worked!
user188304user188304