Resolved ORA-12154
- Issue
- Oracle
- Chee Boon Ang
- PowerBuilder
- Wednesday, 5 July 2017 11:53 AM UTC
Hi Community,
Just installed Appeon PB2017.
export the DB profile from current PB12.5 and import to Appeon PB2017. ( on the same machine )
Encounter the ORA-12154: TNS: Could not resolve the connect identifier specified.
i have no problems connect from the PB12.5 ( classic ) but face the problems from PB2017.
What could i have missed !
Hi,
It may cause by a bug of Oracle, Oracle doesn’t support the application contains parentheses in the installation path which connect to the Oracle database.
Please upgrade Oracle client or install PB on another path to solve this issue.
https://blogs.msdn.microsoft.com/debarchan/2009/02/03/good-old-connectivity-issue-with-oracle-in-x64-environment/
Regards,
ZhaoKai
I have seen the same error.
The solution was to set the following line in sqlnet.ora file:
#previously set to: (NTS) but gives an error, so now:
SQLNET.AUTHENTICATION_SERVICES = (NONE)
The file is located (in my case) here:
D:\app\miguel\product\11.2.0\client_3\network\admin
Another solution might be to set the TNS_ADMIN variable to where your tnsnames.ora file is located (and sqlnet.ora):
- Create a new environmental variable called TNS_ADMIN and set the value to "C:\xxx\product\xxx\client_x\Network\Admin"
- Restart machine
We always install our Oracle clients onto the C drive directly, when possible.
C:\oracle\product\11.2\client_1\.......
Olan
I got the sam issue, too.
pb 2017 R3 LTS 1880 install on windows 64bit and use oracle instant client 10.2.1.
I can use Oracle instant client to connect to my database successfully.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.