ORA-12514 Error

[Deb]

Just downloaded pl/sql developer but cannot connect to my instance.

The username/password and database are correct.

Can you give some troubleshooting steps?

 

[CTzen]

Deb,

- can you connect with SQL*Plus?

- Do you have multiple versions of Oracle Client installed on your PC? You can select correct Oracle Home in PL/SQL Developer preferences.

 

[Deb]

Thanks Slava for the suggestions.

I *can* connect with sqlplus and do indeed have multiple Oracle versions installed but have set the Oracle Home directory to both of them using the preferences/connection setting and still no luck.

All my other Oracle tools work.

Any other ideas?

Thanks,
Deb

 

[CTzen]

Deb,

have you looked at Help->Support info? It will show what ORACLE_HOME/tnsnames.ora PLD is using. May be it will help.

If you have 10g client and trying to connect to 9i/10g db, you can use "easy connect" syntax in Logon dialog box, and bypass tnsnames.ora entries completely.

 

[Marco Kalter]

If you can send me the information from the Help > Support Info page, I will check it out.