PL/SQL Developer Won't Logon After Oracle Re-Install

[mattruwe]

Due to some problems with Oracle on my system I was forced to re-install the client software. Now PL/SQL Developer will not connect to the database giving a "ORA-12154: TNS:could not resolve the connect identifier specified"

I've seen this error before so I assumed that PL/SQL Developer was pointed to the wrong Oracle Home. I only have one home, but tried to specify this directly instead of having it auto detect. I still get the same error. My next guess was that it had something to do with the TNSName file, so I checked that but everything looks fine. I also have a copy of Benthic Golden, which is able to connect without any problem. Also SQL Plus is working fine too. I tried re-installing PL/SQL Developer and deleted the entire installation directory after uninstalling, but I still have the same difficulty.

I'm out of ideas. Can someone please point me in the right direction?

Information retrieved from support info:

PL/SQL Developer
  Version 7.0.2.1076 (MBCS)
  251.36388 - 50 user license
  Windows XP version 5.5 (build 3790) Service Pack 1

  Physical memory : 1,048,040 kB  (387,096 available)
  Paging file     : 2,532,808 kB  (1,917,320 available)
  Virtual memory  : 2,097,024 kB  (1,931,792 available)

Parameters
  C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
  Session mode: Multi
  OCI Library:
  Use OCI7: False

Preference Files
  C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
  C:\Program Files\PLSQL Developer\Preferences\ruwem\default.ini

Plug-Ins

Aliases
  auto
  cf00
  cf01
  cf02
  cf03
  ...

Homes
  OraClient10g_home1  (C:\Oracle\product.2.0\client_1)

DLLs
  C:\Oracle\product.2.0\client_1\bin\oci.dll

TNS File
  C:\Oracle\product.2.0\client_1\Network\Admin\tnsnames.ora

Using
  Home: OraClient10g_home1
  DLL: C:\Oracle\product.2.0\client_1\bin\oci.dll
  OCI: version 9.2

Thanks,
Matt

 

[Marco Kalter]

Perhaps you can enable SQL*Net tracing by setting "trace_level_client = USER" in the sqlnet.ora configuration file? The trace file may shed some light on this.

1. Edit C:\Oracle\product\10.2.0\client_1\Network\Admin\sqlnet.ora using notepad or wordpad
2. Change trace_level_client=OFF to trace_level_client=USER (or add this line)
3. Save the sqlnet.ora file
4. Run PL/SQL Developer and try to connect
5. Tracing file is located in PL/SQL Developer directory (sqlnet.log). Please send this file to me.
6. Change trace_level_client=USER to trace_level_client=OFF
7. Save the sqlnet.ora file

 

[mattruwe]

I changed the setting as you requested, opened PL/SQL Developer and then tried to logon. After receiving the error message, I searched my entire computer for the file (sqlnet.log) but couldn't find it. Is there some other setting that I need to check?

Thanks for your help...

 

[CTzen]

@mattruwe: Can you connect to you db with sqlplus?

 

[mattruwe]

After consulting with my DBA he found that my OracleHome environment variable was not set. After correcting this, everything appears to be working fine.

By the way, SQL Plus was NOT working (despite what I originally said). But Benthic Golden was... weird.

At any rate, thank you for you assistance. Please conside my issue resolved.

Thanks,
Matt