Different users use tnsping + client service name with different results

Suse10sp2 install oracle11g client, create aipcti user, tnspingvsm (vsm is the service name under the client) failed, error: TNS-03505: Failedtoreso

Suse10sp2 install oracle11g client, create aipcti user, tnsping vsm (vsm is the service name under the client) Failed, error: TNS-03505: Failed to reso

Problem description;

Install the Oracle11g client in SUSE10sp2 and create an aipcti user. If tnsping vsm (vsm is the service name under the client) fails, an error is returned:
TNS-03505: Failed to resolve name, Used parameter files:
/Opt/oracle/product/11g/db/network/admin/sqlnet. ora.
It is no problem to directly execute this command under an oracle user.


Troubleshooting:
1. If you use aipcti to directly use tnsping + database IP address, no problem is found.
Used EZCONNECT adapter to resolve the alias for parsing.

2. Open sqlnet. ora under the client, which has the sequence of accessing the database server through the client. We can see that the access sequence in this file is to first access tnsnames. If there is no relevant content in the file or the access fails, then access through EZCONNECT.

Oracle @ urp1vsmdb2:/opt/oracle/product/11g/db/network/admin> more sqlnet. ora
# Sqlnet. ora Network Configuration File:/opt/oracle/product/11g/db/network/admin/sqlnet. ora
# Generated by Oracle configuration tools.

NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT)

3. Display tnsname. ora permissions:
Oracle @ urp1vsmdb2:/opt/oracle/product/11g/db/network/admin> ll-al tnsnames. ora
-Rw-r ----- 1 oracle oinstall 493 tnsnames. ora

It is found that the aipcti user has no permission to execute the file, causing access failure.
Modify tnsnames. ora Permissions
Oracle @ urp1vsmdb2:/opt/oracle/product/11g/db/network/admin> chmod 644 tnsnames. ora
Oracle @ urp1vsmdb2:/opt/oracle/product/11g/db/network/admin> ls-al tnsnames. ora
-Rw-r -- 1 oracle oinstall 493 tnsnames. ora

4. After the modification, the tnsping client can be executed again under aipcti.
Tnsping vsm

TNS Ping Utility for Linux: Version 11.1.0.7.0-Production on 26-9 ?? -14:38:04 2011

Copyright (c) 1997,200 8, Oracle. All rights reserved.

Used parameter files:
/Opt/oracle/product/11g/db/network/admin/sqlnet. ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.110.153.64) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = uivr )))
OK (0 msec)



The output results are compared in the following two ways:
1. Use tnsping + database IP address for aipcti users
Tnsping 10.110.153.64

TNS Ping Utility for Linux: Version 11.1.0.7.0-Production on 26-9 ?? -14:05:27 2011

Copyright (c) 1997,200 8, Oracle. All rights reserved.

Used parameter files:
/Opt/oracle/product/11g/db/network/admin/sqlnet. ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION = (CONNECT_DATA = (SERVICE_NAME =) (ADDRESS = (PROTOCOL = TCP) (HOST = 10.110.153.64) (PORT = 1521 )) (ADDRESS = (PROTOCOL = TCP)

(HOST = 10.110.153.64) (PORT = 1521) (ADDRESS = (PROTOCOL = TCP) (HOST = 10.110.153.64) (PORT = 1521 )))
OK (0 msec)

2. Use tnsping + service name for aipcti users. Normal:
Oracle @ urp1vsmdb2:/opt/oracle/product/11g/db/network/admin> tnsping vsm

TNS Ping Utility for Linux: Version 11.1.0.7.0-Production on 26-SEP-2011 14:28:37

Copyright (c) 1997,200 8, Oracle. All rights reserved.

Used parameter files:
/Opt/oracle/product/11g/db/network/admin/sqlnet. ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.110.153.64) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = uivr )))
OK (10 msec)