Connection Issue on local database

  • From: Bill Zakrzewski <bill@xxxxxxxxxxxx>
  • To: "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 22 Oct 2009 17:58:38 -0400

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: