PL/SQL Developer cannot connect to Oracle 10g, while others get connected [12154]

[Xcom_Cheetah]

i have just downloaded the trial version of the PL/SQL Developer and i m unable to connect it through the oracle 10g database while other programs easily get connected to the database, like form builders and default pl/sql of the oracle database.

The error i get is 12154. i have searched the google and have applied quite a few tips but none has worked. i have checked the sqlnet.ora and tnsnames.ora and listener.ora but haven;t found anything unusual in them.

So can anybody tell me wots the problem.? Thanks

 

[Marco Kalter]

Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[msr]

We just got the same problem with TNS-resolving (ORA-12154)running PL/SQL Developer 6.0.5.931 and 5.1.0.654 versions on Windows XP 64-bit (AMD x86-64). This problem exists only under Windows XP 64-bit SP1. and does not depends on preferences->options.
We've tested JDeveloper 10.1.2 via JDBC, QuestSoftware SQL Navigator, ORACLE enterprise manager and other database applications seems to connect perfect.
To Marco Kalter: we'll sent you the pages you've been asked.

 

[Marco Kalter]

@msr:

I notice you have 2 Oracle Homes:

- Home1 (C:\OraHome_1)
- OraClient10g_home1 (C:\Oracle\product\10.1.0\Client_1)

Can you start PL/SQL Developer, go to Tools > Preferences > Options tab page, select "Home1" from the Oracle Home selection list, restart PL/SQL Developer, and try again?

 

[msr]

to Marko:

I have tried to change home property in preferences as you have advised, but nothing changes. By the way, version 6.0.5.931, have also this problem. As well as any combination of the option at that tab does not help.

I have tried on the other PC (WinXP 64-bit also), having only one Oracle home directory - the same problem.

Thanks for the help.

 

[Marco Kalter]

Can you switch to Single Session mode and try again?

 

[msr]

Thanks for advice, but we've played around with Preferences > Options tab page a lot of time without
success. it'a a great tool and we spend enough time trying to make it work on win64

 

[davidelewis]

Any plans to soon release a version of PL/SQL Developer that is compatible with the 64-bit Oracle Developer Client? We are in the process of upgrading systems from Win2K to Win XP 64 and are having the same "12154" problem ...

 

[Marco Kalter]

We have no short term plans for this, but you can use PL/SQL Developer with a 32bit version of Oracle Net.

 

[davidelewis]

Thanks, Marco!