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 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