Re: Connection Issue on local database

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Thu, 22 Oct 2009 17:03:38 -0500
Message-ID: <e9569ef30910221503vecc59flc416fd7fcb5b4fab_at_mail.gmail.com>

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:03:38 CDT