• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Powerbuilder 2017 Oracle client 11g connectivity issue - ORA 12154

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Powerbuilder 2017 Oracle client 11g connectivity issue - ORA 12154

  1. Issue
0
Votes
Undo
  1. Sharon Mary
    Sharon Mary
  2. PowerBuilder
  3. Tuesday, 19 February 2019 16:22 PM UTC

Hi All,

 

I installed Powerbuilder 2017 and have oracle 11g client 32 bit installed in windows server 2008 machine 64 bit.

When trying to connect to database through DB profile , I am getting error "ORA-12154: TNS:could not resolve the connect identifier specified". Reading the different solutions , I changed my PB directory other than Program files(x86). Still I am getting error.

I am able to connect to database through SQL developer.

 

Please help..

Thanks in advance

  1. Oracle
  2. PowerBuilder (Appeon)
Powerbuilder R3 install - knocks our Infomaker R1
DisableBind parameter and NChar on SQL Server
Accepted Answer
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Tuesday, 19 February 2019 22:30 PM UTC
  2. PowerBuilder
  3. # Permalink

Nine times out of 10 this error means that the entry in the TNSNAMES.ORA file for the database is incorrect.
Take a look at that file to verify that it contains accurate information, and fix it if an error is found.


Another issue is when people have more than one TNSNAMES.ORA file in their system, or pointed to by the PATH variable. Please ensure that you have one and ONLY one of these files.

 

Olan

Comment
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Wednesday, 20 February 2019 11:00 AM UTC
Olan is correct.

I would make sure you can connect using sqlplus before worrying about powerbuilder. If you can connect with sqlplus and not powerbuilder, then check your connection info is correct.



Basically the error you are getting is that the Oracle SID is not found in tnsname.ora
  1. Helpful
There are no comments made yet.
Responses (2)
Sharon Mary
Sharon Mary Accepted Answer Pending Moderation
  1. Wednesday, 20 February 2019 12:52 PM UTC
  2. PowerBuilder
  3. # 1

Thank You Olan.

I had multiple tnsnames.ora file in my machine. I renamed all the other files except which is needed.

I can now connect through Powerbuilder DB profile. Thank You so much

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.