user11081143 wrote:needless to say, you should NOT be getting TNS error while connecting to local DB without using SQL*Net.
I installed a server on a Linux server Oracle184.108.40.206 5.8 from 64 bits.
The user who installed the Oracle software is "oracle" and belongs to oinstall and dba groups.
uid=503(oracle) gid=504(oinstall) groups=504(oinstall),505(dba),506(cvargas) context=user_u:system_r:unconfined_t
The software has been installed correctly and have been able to create two databases. As a requirement of the application, you must create an operating system user that launches processes.
This user belongs to dba.
But when trying to access Oracle via sqlplus gives this error:
-bash-3.2$ sqlplus davinci/xxxxxxx
SQL*Plus: Release 220.127.116.11.0 Production on Fri Dec 7 23:22:40 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ORA-12547: TNS:lost contact
Enter user-name:Yes, problem exists at OS/Networking level
However, if you connect using a network descriptor works correctly.
So there must be a problem with access to local resources.
This user has the same profile file variable (. Bash_profile)
Any idea of how to fix this problem?post results from following OS commands