Re: Getting error on connecting to oracle listener

Try
Sqlplus user_at_gl
The provide the password when prompted..... .

omar_at_umbc.edu (Omar Siddique) wrote:

>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
>

To reply please remove the 'nospam' part of the address Received on Thu Jan 28 1999 - 16:34:07 CST