I have a weird problem.
I login to a pc using non admin user. Then I installed sqlclient 64 bit for oracle 11.2. Installation went fine, no errors. Then i tried to login using sqlplus from command prompt. It gives out error
"ORA-12545: Connect failed because target host or object does not exist"
Then I try to run the command prompt using windows admin account. Then it works. i can connect to oracle.
Can anyone explain this behavior ? How can i run sqlplus without using windows admin account ?
Here is what i run :
C:\Windows\system32>sqlplus SQL*Plus: Release 18.104.22.168.0 Production on Thu Dec 13 09:52:00 2018 Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: username@xxx Enter password:
This is my tnsnames.ora :
xxx.domain.yyy = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.255.1.80)(PORT = 1523)) ) (CONNECT_DATA = (SID = xxx) ) )