Re: RAC -- unable to Connect using service name
From: kathryn axelrod <kat.axe_at_gmail.com>
Date: Wed, 28 Mar 2012 08:56:40 -0700
Message-ID: <CAEbHM47BVajd0xZpnUKaRvGVg229emUjx9onQ_mWSdUuLMoTtQ_at_mail.gmail.com>
Is there an entry in the tnsnames in the home you are running "sqlplus system/******_at_test" from?
Date: Wed, 28 Mar 2012 08:56:40 -0700
Message-ID: <CAEbHM47BVajd0xZpnUKaRvGVg229emUjx9onQ_mWSdUuLMoTtQ_at_mail.gmail.com>
Is there an entry in the tnsnames in the home you are running "sqlplus system/******_at_test" from?
If so, I have also seen a situation where everything appeared proper but the db gave an ORA-12514 and the fix was to manually (no copy/paste) rewrite the listener.ora entry. Apparently it had some hidden character/space/other format glitch that caused issues as the rewrite fixed it. (Manually rewriting the tnsnames entry is worth trying as well.)
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 28 2012 - 10:56:40 CDT