Just installed trial....but TNS: no listener

[rthibault]

Which is a little strange, since it auto-detected all my tnsnames and showed them in the picklist. Using the same login/pwd I use in sqlplus and other db apps....even tried manually setting the Oracle home path in Options, to no avail.

Any ideas?

 

[Marco Kalter]

Perhaps you can use the Oracle Home Selector to select a different Primary Oracle Home? Preferely the same that is used by the SQL*Plus version that works correctly?

------------------
Marco Kalter
Allround Automations

 

[rthibault]

Hmm....well I only have one home...this is a fairly straightforward client installation. SQLPlus, RapidSQL, and TOAD all connect fine......

 

[CTzen]

If you have NAMES.DEFAULT_DOMAIN = set in sqlnet.ora, try to add it to database alias in PL/SQL Developer login dialog box.

sqlnet.ora
NAMES.DEFAULT_DOMAIN = mydomain.com

tnsnames.ora
dbalias.mydomain.com =
...

PL/SQL Developer Login Dialog Box
username
password
dbalias.mydomain.com

 

[rthibault]

Nope, not doing anything like that. I just connect by simple names (DEV, QA, etc.).

Bummer, this looks like a cool tool....

 

[Marco Kalter]

Perhaps you can enable Oracle Net tracing by setting "trace_level_client = USER" in the sqlnet.ora configuration file? The trace file should allow us to determine what is happening.

[*] Edit \network\admin\sqlnet.ora using notepad or wordpad

[*] Change trace_level_client=OFF to trace_level_client=USER (or add this line)

[*] Save the sqlnet.ora file

[*] Run PL/SQL Developer and try to connect

[*] Tracing file is located in PL/SQL Developer's installation directory (sqlnet.log). Please check out this file or send it to me.

[*] Change trace_level_client=USER to trace_level_client=OFF

[*] Save the sqlnet.ora file[/list]

------------------
Marco Kalter
Allround Automations

[This message has been edited by mkalter (edited 02 May 2003).]

 

[BWendling]

I had a similar problem "No listener" in PLSD, although I could connect via SQL*Plus. This was after installing 10g on my local box.

Problem:
The listener resolved my host name to 127.0.0.1, but TNSNAMES resolved my host name to the external Internet IP address which of course did not match.

Solution:
Changed the host name in TNSNAMES.Ora to IP (127.0.0.1).