Connection Issue on local database
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-lReceived on Thu Oct 22 2009 - 16:58:38 CDT