Re: RAC -- unable to Connect using service name
Date: Wed, 28 Mar 2012 20:56:56 +0100
The error you are receiving means that you are asking to connect to a different service name than the one the listener knows. The listener knows about test.domain.com : I suggest you check what the tnsnames entry that has the alias "test" refers to.
On Wed, Mar 28, 2012 at 5:53 PM, Krishna <krishna.setwin_at_gmail.com> wrote:
> Yes, I have an entry in tnsnames.ora for "test"
> I have attached tnsnames.ora && listener.ora
> I will rewrite tnsnames.ora...
> How to re-write listener.ora ??
> please let me know
> On Wed, Mar 28, 2012 at 11:56 AM, kathryn axelrod <kat.axe_at_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.)
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 28 2012 - 14:56:56 CDT