-
Hi All,
I'm running oracle 9.0.1 on Linux 7.1 . For the past one week , i'm getting a strange error when i'm trying to connect to oracle with SQLPLUS command.
[oracle@cmsprod1 oracle]$ sqlplus
SQL*Plus: Release 9.0.1.0.0 - Production on Fri Aug 23 12:39:55 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: devlcms
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
I looked for LD_LIBRARY_PATH first, it was not set, then i edited in my .bash_profile as
LD_LIBRARY_PATH=$ORACLE_HOME/lib and ran my bash_profile from oracle user. and again when i say, 'env' , this parameter was set.
But still, even after doing all these, i'm getting the same old error. Please suggest me .
Thanks
-
Have you checked this and does it send off any ideas?
/oracle/admin/wmsd/ddl/tables> oerr ora 12547
12547, 00000, "TNS:lost contact"
// *Cause: Partner has unexpectedly gone away, usually during process
// startup.
// *Action: Investigate partner application for abnormal termination. On an
// Interchange, this can happen if the machine is overloaded.
Sorry to be of more help.
-
Perform few tests and/or please answer these questions:
Are you running SQL+ from the same machine where database resides?
Is you listener running on database server?
If connecting from client work station try to ping and tnsping to the database server.
Were you connecting to this server earlier without problems?
Did you re-built Oracle binaries recently?
Hopefully your DB is up and running.
