db drop down is blank, but I can still connect

[William Peck 195]

It took me a while, but I finally got PL-SQL Developer v14 (64-bit) loaded successfully at home and connected to Oracle (at work) via VPN, using Oracle 64-bit client.

So I'm functional and all good, but the drop-down to the database list (from tnsnames) is blank. So I just type in the d.b. name and I can connect.

Just wondering why the drop-down isn't there?

In Preferences, I have oracle home = C:\oracle_64\network\Admin and that's where tnsnames.ora is located.

I have my path in Windows Environment variables set to go to C:\oracle_64 ...

just trying to clean up this a bit and understand what's going on.

 

[Marco Kalter]

Maybe there is an issue with the tnsnames.ora file, which is used to populate the database list. Can you send the tnsnames.ora file to support@allroundautomations.com, together with the text of the "Info" tab page of the Help > Support Info screen?

 

[William Peck 195]

Here's the file ... but it must be in the right place since I can connect, otherwise, how would it know what are the connection parameters?

Anyway, I'm still working fine and like v 14 - snazzy.

Here a snippet from the file (I only use two d.b.'s)

===========
### ERP Reporting ###

ERPREPORTS.erp.xxxx.edu, ERPREPORTS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = npr-scan01.erp.xxxx.edu)(PORT = 1526))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ERPSTBY.erp.xxxx.edu)
)
)

### Data Store OWB Repository Production ###

STOREDW.erp.xxxx.edu, STOREDW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db-racscan01.erp.xxxx.edu)(PORT = 1525))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = STOREDWP.erp.xxxx.edu)
)
)

 

[Marco Kalter]

Can you send the complete tnsnames.ora file to support@allroundautomations.com?