Connection Issue on local database

From: Bill Zakrzewski <bill_at_intactus.com>
Date: Thu, 22 Oct 2009 17:58:38 -0400
Message-Id: <91591B29-D263-40F3-9CEE-472217AFE6A2_at_intactus.com>



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
Received on Thu Oct 22 2009 - 16:58:38 CDT

Original text of this message