Re: local connections fail, but listener connections succeed

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 3 Jan 2013 14:59:54 -0600
Message-ID: <CAJvnOJYAagcscTfuRVpgTUZ=Bv5-_RD80H8UGkEy14Cx=Wp+0Q_at_mail.gmail.com>

Hmm. Just occurred to me. Are you sure you are connecting locally when using the tns entry? Did you look at the instance name from v$instance? On Thu, Jan 3, 2013 at 2:46 PM, Fergal Taheny <ftaheny_at_gmail.com> wrote:

> Could be that the check script that crs is using actually connects to the
> db but can't do that due to your original issue and so reports the db as
> down.
> On the original issue, any changes to your sqlnet.ora? I made some changes
> to sqlnet.ora before for oracle password store which broke local
> connections. And be careful cause you could be picking up a sqlnet.ora in a
> location you don't expect.
>
> Regards,
> Fergal
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 03 2013 - 21:59:54 CET