Re: Getting error on connecting to oracle listener

From: Omar Siddique <omar_at_umbc.edu>
Date: 28 Jan 1999 14:23:37 -0500
Message-ID: <78qdfp$7dha@umbc7.umbc.edu>

In article <36AF9EA5.8843A12C_at_werum.de>, Kai Horstmann <horst_at_werum.de> wrote:
>Perhaps try "sqlplus <user/pass>@gl"
>That's what you wrote as Connect string into your tnsnames.ora file.

Thanks for the responses.

I tried this, but no go, I get:

--------<snip>----
SQL*Plus: Release 8.0.3.0.0 - Production on Thu Jan 28 14:10:54 1999

(c) Copyright 1997 Oracle Corporation. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve service name --------<snip>----

I tried both "sqplus user/pass_at_gl" and "sqlplus user/pass_at_GL". Same error with both.

The listener is definitely running. "lsnrctl stat" returns:

--------<snip>-------
LSNRCTL for SVR4: Version 8.0.3.0.0 - Production on 28-JAN-99 14:07:51

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oracle.gl.umbc.edu)(PORT=1521)) STATUS of the LISTENER

---

Alias                     LISTENER
Version                   TNSLSNR for SVR4: Version 8.0.3.0.0 - Production
Start Date                12-JAN-99 13:36:35
Uptime                    16 days 0 hr. 31 min. 16 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /usr/oracle/app/oracle/product/8.0.3/network/admin/listener.ora
Listener Log File         /usr/oracle/app/oracle/product/8.0.3/network/log/listener.log
Services Summary...
  GL            has 2 service handler(s)

The command completed successfully

--------------------<snip>----------

The password I'm using is good, because I can log in to sqlplus if it's just run locally on the server machine.

Any other ideas?? It looks like things should be working, but they're not...

-omar Received on Thu Jan 28 1999 - 13:23:37 CST