By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,180 Members | 1,016 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,180 IT Pros & Developers. It's quick & easy.

Listener/tnsnames.ora issue ORA-12514

P: 1
I'm running 10gR2 RAC in Prod, Test and DEV and after doing a clone to the DEV environment I'm getting a wierd ORA-12514 error for only one node. I can tnsping the node and it comes back fine. Oracle Home is shared, so I'm using the same listener.ora file and tnsnames.ora file from both nodes. I can connect using sqlplus @<node1> fine and @<service name> fine but when I try to connect @<node2> I get the ORA-12514. This is odd because I have a second database on the same servers using the same listener.ora file and I'm able to connect to node2 of that database w/o error. I'm looking for fat-fingered errors but so far none. Any ideas?
Sep 16 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.