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 FeatherOn Thu, Oct 22, 2009 at 4:58 PM, Bill Zakrzewski <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.2If 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 contactSP2-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 optionsSession altered. dev1-SYSTEM > -Bill -- //www.freelists.org/webpage/oracle-l
