|
-
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
PNRDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|