Re: Connection Issue on local database

From: Bill Zakrzewski <bill_at_intactus.com>
Date: Thu, 22 Oct 2009 18:16:56 -0400
Message-Id: <D01550FE-C61E-415E-93FC-51BE33593827_at_intactus.com>



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>
> 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:16:56 CDT

Original text of this message