ORA-12514: TNS:listener does not currently know of service requested in connect
Posted on 2007-08-07
I get quite tired of getting tns wrongly set up. Every time I see the following message I knew it is tns error
Enter password: ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
So how to set Oracle TNS for both oracle 9 and oracle 10g.
I need to know the concept or principle behind, I've so many solution regarding this, but all solutions lead to one thing:
it never give any principal behind it. I mean what is SID? what is service name? Is there a difference in these terms between Oracle 9i and Oracle 10g?