Oracle Logon pop-up

[jrow]

One the "Database" field. there is an indication that a list of databases exists. From where does this get populated? I seem to remember that several versions back it came from TNSNAMES, but is now always empty.

This is for both v6 and v7Beta.

Thanks - JR

 

[Marco Kalter]

It does still come from the tnsnames.ora file. If the list is empty, maybe you are using a different name resoltion method (e.g. Oracle Names or ezconnect)?

 

[jrow]

I'm using TNSNAMES, still nothing comes up. I specified the ORACLE_HOME in the connection preference, still nothing.

Is there anything that would prevent PLS from finding the TNSNAMES file?

Thanks - JR

 

[Marco Kalter]

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

 

[jrow]

Here it is...

It looks like the "TNS File" entry below is pointing to the wrong place. Where does PLSQL get this value?

Thanks - JR

--- Info ---

PL/SQL Developer
Version 7.1.0.1337
41560 - 1 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 1,039,732 kB (299,696 available)
Paging file : 2,500,336 kB (1,501,016 available)
Virtual memory : 2,097,024 kB (2,007,724 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\row\default.ini

Plug-Ins
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
*Remote command Plug-in (rexec.dll) (C:\Program Files\PLSQL Developer\PlugIns\rexec.dll)
(* is Active)

Aliases

Homes
OraEM10g_home1 (D:\oracle\product\10.1.0\em_1)
OraHome92 (D:\oracle\ora92)

DLLs
D:\oracle\ora92\bin\oci.dll

TNS File
d:\oracle\common_tnsnames.ora\tnsnames.ora

Using
Home: OraHome92
DLL: D:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.6.0

Character Sets
Character size: 1 byte(s)
CharSetID: 1
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: US7ASCII
NLS_NCHAR_CHARACTERSET: AL16UTF16

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = D:\oracle\ora92
ORACLE_HOME_NAME = OraHome92
API = D:\oracle\ora92\dbs
ORACLE_GROUP_NAME = Oracle - OraHome92
NLS_LANG = NA
OLEDB = D:\oracle\ora92\oledb\mesg
OO4O = D:\oracle\ora92\oo4o\mesg
VOBHOME2.0 = D:\oracle\ora92

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = OraHome92
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome92
PATH = D:\oracle\ora92
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

SOFTWARE\ORACLE\AUTOTUNE9.2.0
help_path = ${vobhome2.0}bin/
debug_flags =
startlog = ${home}autotune/%1.log
trace_report = 0
trace_data = 0
collect_int_in_min = 15
analyze_int_in_hrs = 24
max_errors_allowed = 5
wip_batch = 0
wip_window = 0
wip_logfile = 0
wip_logtable = 0

SOFTWARE\ORACLE\EXPERT9.2.0
home = ${vobhome2.0}sysman/expert
help_path = ${vobhome2.0}bin/
xpcoin = ${vobhome2.0}bin/xpcoin
default_rule_file = xpo000
debug_flags =
sample = ${home}sample/
sample_xdl = ${sample}xppso.xdl
startlog = ${vobhome2.0}sysman/temp/xpexpert.log
trace_report = 0
trace_data = 0
max_orphan_txn_reqs = 100
max_cache_txn_reqs = 50
extract_explain_plan = 0
create_tmp_plan_table = 0
tmp_plan_table = xp_tmp_plan
wip_batch = 0
wip_window = 1
wip_logfile = 0
wip_logtable = 0
quicktour_start = ${vobhome2.0}classes/oracle/sysman/qtour/tune/us/tune.htm
report_viewer = write
startup_wizard = 1
collect_trace_stats = 1
standalone_mode = 0

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome92
ORACLE_HOME_NAME = OraHome92
ORACLE_HOME = D:\oracle\ora92
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = D:\oracle\ora92\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
ORACLE_HOME_KEY = Software\ORACLE\HOME0
ORACLE_BASE = D:\oracle
SQLPATH = D:\oracle\ora92\dbs
MSHELP_TOOLS = D:\oracle\ora92\MSHELP
RDBMS_CONTROL = D:\oracle\ora92\DATABASE
RDBMS_ARCHIVE = D:\oracle\ora92\DATABASE\ARCHIVE
ORACLE_SID = rowdb
ORA_nextfare_AUTOSTART = TRUE
ORA_nextfare_SHUTDOWN = TRUE
ORA_nextfare_SHUTDOWNTYPE = i
ORA_nextfare_SHUTDOWN_TIMEOUT = 30

SOFTWARE\ORACLE\HOME0\HTTP_Server
Path = D:\oracle\ora92\bin;D:\oracle\ora92\Apache\Perl\5.00503\bin\mswin32-x86;D:\oracle\ora92\Apache\fastcgi

SOFTWARE\ORACLE\iSQLPlus
ServerCount =

 

[Marco Kalter]

Is d:\oracle\common_tnsnames.ora\tnsnames.ora valid? Have you perhaps set a TNS_ADMIN environment variable?