RE: Connection Issue on local database

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Thu, 22 Oct 2009 18:32:31 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F2328FFBC_at_AAPQMAILBX02V.proque.st>

Is your oracle binary SUID to oracle id? ls -l $ORACLE_HOME/bin/oracle

-Mark

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bill Zakrzewski Sent: Thursday, October 22, 2009 6:17 PM To: piontekdd_at_gmail.com
Cc: Oracle-L_at_freelists.org
Subject: Re: Connection Issue on local database

Yes, I copied the "oracle" user's profile to my profile. To add one more caveat, I can log in to the local databases logged into the oracle account, but not my account.

-Bill

On Oct 22, 2009, at 6:03 PM, Bradd Piontek wrote:

Have you verified that your $ORACLE_HOME is set exactly to the value that was used to start the database? I've seen local issues like this, but not usually the TNS error (this may be dependent on the listener.ora settings).

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
        direction."

• William Feather

On Thu, Oct 22, 2009 at 4:58 PM, Bill Zakrzewski <bill_at_intactus.com<mailto:bill_at_intactus.com>> wrote: This is probably something I am overlooking, but I am unable to connect to a local database. Here are the details.....

Oracle 10.2.0.4.0
RH Linux 5.2

If I try to connect using the listener it connects, but with just the ORACLE_SID set it returns an error.

[bzakrzewski_at_oracle ~]$ echo $ORACLE_SID dev1
[bzakrzewski_at_oracle ~]$ sqlplus system

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Oct 22 17:53:04 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter password:
ERROR:
ORA-12547: TNS:lost contact

Enter user-name:
ERROR:
ORA-12547: TNS:lost contact

Enter user-name:
ERROR:
ORA-12547: TNS:lost contact

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus [bzakrzewski_at_oracle ~]$ sqlplus system_at_dev1

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Oct 22 17:53:26 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

Session altered.

dev1-SYSTEM >

-Bill

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 22 2009 - 17:32:31 CDT