RE: Connection Issue on local database
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "bill@xxxxxxxxxxxx" <bill@xxxxxxxxxxxx>, "piontekdd@xxxxxxxxx" <piontekdd@xxxxxxxxx>
- Date: Thu, 22 Oct 2009 18:32:31 -0400
Is your oracle binary SUID to oracle id?
ls -l $ORACLE_HOME/bin/oracle
-Mark
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bill Zakrzewski
Sent: Thursday, October 22, 2009 6:17 PM
To: piontekdd@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxxxxx<mailto:bill@xxxxxxxxxxxx>> 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@oracle ~]$ echo $ORACLE_SID
dev1
[bzakrzewski@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@oracle ~]$ sqlplus system@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
