RE: local connections fail, but listener connections succeed

From: <Christopher.Taylor2_at_parallon.net>
Date: Thu, 3 Jan 2013 08:58:11 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856A2DCE39_at_NADCWPMSGCMS10.hca.corpad.net>



Also something to check -

What is the name of the SERVICE that is running on that particular box?

When you do _at_db_name you're using an alias in the tnsnames.ora file.

When you do local connection it looks up the SERVICE name.

Chris

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Uzzell, Stephan Sent: Thursday, January 03, 2013 8:54 AM To: 'Andrew Kerber'
Cc: oracle-l_at_freelists.org; Uzzell, Stephan Subject: RE: local connections fail, but listener connections succeed

The SID, yes. The HOME - we've never needed to. Setting the HOME doesn't seem to make any difference though... Stephan Uzzell

From: Andrew Kerber [mailto:andrew.kerber_at_gmail.com] Sent: Thursday, 03 January, 2013 09:51
To: Uzzell, Stephan
Cc: oracle-l_at_freelists.org
Subject: Re: local connections fail, but listener connections succeed

This is kind of obvious, but did you set ORACLE_SID and ORACLE_HOME? On Thu, Jan 3, 2013 at 8:44 AM, Uzzell, Stephan <SUzzell_at_micros.com<mailto:SUzzell_at_micros.com>> wrote: Hey list,
This is backwards enough that I don't quite know where to start with it. This morning we noticed that for one environment, we cannot make direct local connections... but we can connect to our hearts' content via the listener. I'm used to seeing the listener act up and being able to connect directly but not via the listener - not this.

Oracle 11.2.0.2 on Win 2003 x64

W:\>set ORACLE_SID=MMP52

W:\>sqlplus usdcdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 3 09:39:13 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name: usdcdba_at_mmp52
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name from v$instance;

INSTANCE_NAME



mmp52

Any ideas?

Thanks!

Stephan Uzzell

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 03 2013 - 15:58:11 CET

Original text of this message