No databases listed in logon dropdown

[xanthis]

I have a new pc installation and have had pl/sql developer installed. However when i go to logon i no longer have my list of DB's in the database dropdown.

Assuming that this is read from the tnsnames.ora file i copied my old copy into c:\oracle\network\admin\tnsnames.ora however pl\sql still doesn't read this.

Any help on how i can point to this file would be greatly appreciated.

--- Info ---

PL/SQL Developer
  Version 5.1.4.730 (MBCS)
  01.18981 - 10 user license
  Windows XP version 6.0 (build 2600) Service Pack 2

  Physical memory : 2,097,152 kB  (2,097,152 available)
  Paging file     : 4,194,304 kB  (3,753,040 available)
  Virtual memory  : 2,097,024 kB  (2,052,996 available)

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

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

Plug-Ins

Aliases

Homes

DLLs

TNS File

Using
  Home:
  DLL:
  OCI: not initialized

--- Registry ---

SOFTWARE\ORACLE
  inst_loc = C:\Program Files\Oracle\Inventory
  ORA_CRS_HOME = c:\oracle

  SOFTWARE\ORACLE\KEY_OraDb10g_home1
    ORACLE_HOME = c:\oracle
    ORACLE_HOME_NAME = OraDb10g_home1
    ORACLE_GROUP_NAME = Oracle - OraDb10g_home1
    ORACLE_BUNDLE_NAME = Enterprise
    NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
    OLEDB = c:\oracle\oledb\mesg
    ORACLE_SID = orcl
    OO4O = c:\oracle\oo4o\mesg
    SQLPATH = c:\oracle\dbs
    ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraDb10g_home1
    ORACLE_BASE = c:
    MSHELP_TOOLS = c:\oracle\MSHELP
    RDBMS_CONTROL = c:\oracle\DATABASE
    RDBMS_ARCHIVE = c:\oracle\DATABASE\ARCHIVE
    ORA_ORCL_AUTOSTART = TRUE
    ORA_ORCL_SHUTDOWN = TRUE
    ORA_ORCL_SHUTDOWNTYPE = immediate
    ORA_ORCL_SHUTDOWN_TIMEOUT = 90

    SOFTWARE\ORACLE\KEY_OraDb10g_home1\ODP.NET
      TraceFileName = C:\ODPNET.trc
      TraceLevel = 0
      TraceOption = 0

    SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB
      CacheType = Memory
      ChunkSize = 100
      DistribTX = 1
      FetchSize = 100
      OSAuthent = 0
      PLSQLRset = 0
      PwdChgDlg = 1
      SchRstLng = 10000
      UserDefFn = 0
      DisableRetClause = 1
      VCharNull = 1
      TraceCategory = 0
      TraceFileName = c:\OraOLEDB.trc
      TraceLevel = 0
      TraceOption = 0
      SPPrmDefVal = 0

    SOFTWARE\ORACLE\KEY_OraDb10g_home1\OO4O
      CacheBlocks = 20
      FetchLimit = 100
      FetchSize = 4096
      HelpFile = c:\oracle\oo4o\doc\oracleo.hlp
      PerBlock = 16
      SliceSize = 256
      TempFileDirectory = c:\temp
      OO4O_HOME = c:\oracle\oo4o

  SOFTWARE\ORACLE\Ocr
    ocrconfig_loc = c:\oracle\cdata\localhost\local.ocr
    Local_Only = TRUE

  SOFTWARE\ORACLE\SCR

  SOFTWARE\ORACLE\SYSMAN

    SOFTWARE\ORACLE\SYSMAN\OracleDBConsoleorcl
      EMDROOT = c:\oracle
      ORACLE_HOME = c:\oracle
      EMSTATE = c:\oracle\MKDT175.domain.whiteclarkegroup.com_orcl
      CONSOLE_CFG = dbconsole
      ORACLE_SID = orcl
      TIMEOUT = 15
      TRACE_LEVEL = 16

--- Path ---

c:\oracle\bin
c:\oracle\jre.4.2\bin\client
c:\oracle\jre.4.2\bin
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\java\maven-2.0.7\bin

--- TNS names ---

 

[Mark Heckman]

I think you need to upgrade to at least the 5.1.6 version of PL/SQL Developer before it works correctly with the Oracle 10g client you are using. Search the PL/SQL Developer forum for "connecting 10g database" for more info.

 

[xanthis]

Thanks Mark that appears to be the most likely problem, others at our firm have 5.1.6.747 and their installs are working fine and I beleive my old client was Oracle 9i.