Once i had got a call from application team stating that the dblinks are not working from production database to access objects in other database.
So immediately i have logged into the production server and tried to connect to other database using dblink and it had given the error ORA-12514.
Basically when this error encounters make sure to check the SERVICE_NAME parameter in the connect descriptor matches with the service name known by listener. In my case it was not matching, so i have modified the value such that it matches with the value known by listener and it has solved my problem.
Eg: earlier SERVICE_NAME parameter in connect descriptor was XYZ but the value known by listener(to find this you can give service LISTENER_NAME in lsnrctl prompt) was XYZ.WORLD.So i have changed the SERVICE_NAME value to XYZ.WORLD and it made the trick.
Its All About Oracle 
0 Responses to “Trouble shooting ORA-12514”