| No Successful connection from a TNSPING. [message #412300] |
Wed, 08 July 2009 10:04  |
sh014d1054
Messages: 2
Registered: July 2009
Location: Blackburn
|
Junior Member |
|
|
Hi,
I have a server running an Oracle 9i database.
I have installed the Oracle 9i Client software onto a client Pc (an IBM laptop). This Pc is on the same network/domain as the database server.
When I try a TNSPING command to the database name I am not getting a successful connection, I get the following message:
Message 3511 not found; No message file for product=NETWORK, facility=TNSM
3512 not found; No message file for product=NETWORK, facility=TNSAttempti
contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
UB11)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = BarcoDB)))
Message 3509 not found; No message file for product=NETWORK, facility=TNS
Strange thing here is that if I logon to the client Pc as an Administrator of that Pc then I get a successful database connection.
I get the above message only when logged on with a lower level user.
My tnsnames and sqlnet files are ok.
I have given Everyone on the Client Pc full security access to c:\oracle\ora92, and I know that the lower level users can access the tnsnames file (I can brwose and open these files while logged on as the lower level user).
Why should being an Administrator of the Pc make any difference?
Could it be that port 1521 is blocked for the lower level user?
I have added port 1521 into the Firewall exceptions.
Thanks.
Simon.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
