Database Connection issue between Powerbuilder 11.1 build 8123 and Oracle 10g

[Former Member]

Hi,

I install Powerbuilder 11.1 and Oracle 10g 32 bit client in my machine (OS- Win7, 64 Bit).

When i run my PB application or create DB profile it produce error "ORA-12154: TNS:could not resolve the connect identifier specified" but my tnsping is ok and i am able to connect my SQLPlus with run as admin mode.

I also able to run my PB application exe (Run as admin) which is generated on my other team member.

Please help, it is urgent.

Thanks

Vikrant.

[Former Member]

Hi,

You might try the PowerBuilder Developer Center for such questions;

Connection problems with Oracle have been discussed there before; although maybe different errors:

http://scn.sap.com/community/developer-center/powerbuilder

http://scn.sap.com/thread/3465025

http://scn.sap.com/thread/3464576

For the error "ORA-12154"maybe the issue is due to a typo; try this link for tips:

http://ora-12154.ora-code.com/

Are you perhaps using a local version of Oracle, then you could use the local address 2: as server in PB.

You should see the services that are defined with:

select value from v$parameter where name = 'service_names'

The entry for this service in the tnsnames.ora file should have that service as service name and your powerbuilder connection profile server property should have the entry name in the tnsnames.ora

Please try to see if they match.

Without further information there is little we can say,

Regards,

Ben

[Former Member]

Hi Ben,

I am new in this community. Thanks for your suggestion and links, i already read these links.

1. My TNSPING is ok, that means no error in tnsname.ora.

2. I am able to login in SQLPlus when it is run as admin.

My problem is when i create dbprofile in powerbuilder it raises below error.

[Former Member]

Hi,

SQLPlus is not comparable, it may use a completely different connection method.

I am not an Oracle administrator, but normally I would expect to see something like:

(CONNECT_DATA = (SERVICE_NAME = name))

So check:

select value from v$parameter where name = 'service_names'

Check if you can login with the user account with SQLPlus instead of the administrator.

You could also try if a "trace_level_client = 16" set in the sqlnet.ora reveals anything in the trace.

I have no other tips,

Ben

[CobyKako]

Hello Vikrant,

Root cause could be that programs (Oracle or/and PowerBuilder) are installed in folders with parenthesis in their names, something like "C:\Program Files (x86)\..."

This could be a problem when installing Oracle 32-bit clients on X64 environments.

Check this useful link for more details:

Connectivity Issue with Oracle in x64 Environment “ORA-12154: TNS:could not resolve the connect ide...

Hope this helps.

Jacob

[Former Member]

Hi Jacob,

Thanks for your helful link. Finally I got solution after installing the instant client of oracle 11g with oracle 10g in my machine and my problem is resolved.