Posts Tagged ‘connectivity


The world was shouting out loud for some explanations on ORA-12514

I was having a look at my blog stats today and it seems that most of the traffic I got from search engines are triggered by ORA-12514…

Just a simple look at the following table, coming straight from the stats:

ORA-12514 23
ora-12514 13
ORA-12514: TNS:listener does not current 5
dbsnmp password 3
TNS:listener does not currently know of 3
DG_BROKER_START=true scope=both; 2

That’s 78% of the search on this blog.

So what I’m going to do, instead of just a solution to ORA-12514, is a detailed explanation of how connectivity works with Oracle: Listener, sqlnet.ora and tnsnames.ora

I’ll also include some basic best practices as well. All that with as few difficult words as possible and as many simple words as possible.

I don’t pretend to be an Oracle guru but I would be really happy to provide my small piece of work to the greatest community online.

Soon. On this blog…