467,166 Members | 1,027 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,166 developers. It's quick & easy.

Listener/tnsnames.ora issue ORA-12514

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
  • viewed: 3236

Post your reply

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

Similar topics

1 post views Thread by Adam Ruth | last post: by
6 posts views Thread by bdj | last post: by
6 posts views Thread by Ellen K. | last post: by
2 posts views Thread by Miori | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.