Re: Oracle for linux: login denied

I can't get either method to work with Oracle 8 for linux. I'm trying to talk to a copy of oracle 7.3.3 on a sun box. SQL*Net does work, 'cause I can create a dblink and select from tables. Unfortunately, I need better access than just select and so a dblink isn't good enough for me.

So, how do you guys get sqlplus to connect to a remote oracle database through sqlnet?

On Tue, 20 Oct 1998 08:21:48 -0500, Jack Carter <jccarter_at_flash.net> wrote:
>I had a similar problem with 8.04 on HP-UX 10.20. I was trying to connect
>by typing:
>
>$ sqlplus username_at_database
>
>and then supplying the password at the sqlplus prompt. While this works for
>7.3 it does not work for 8.04. I found that you must supply the @database
>portion after the password; the way you used to have to do it under 6.1.
>
>$ sqlplus username/password_at_database
>
>
>remove kk wrote in message <362bd3d4.449961242_at_news.demon.co.uk>...
>>On Thu, 15 Oct 1998 21:05:51 GMT, spot1111_at_my-dejanews.com wrote:
>>
>>>Hello!
>>>
>>>We had recently installed oracle 8.0.5 on linux 2.0.34 (RedHat 5.1).
>>>We have another server running oracle HP-UX 7.3.3.4.1. When we try to
 connect
>>>from the linux machine to the HP-UX (11.0), using sqlplus we receive the
>>>following message:
>>>
>>>[oracle_at_fw1 oracle]$ sqlplus system/passwd_at_diamprod
>>>
>>>SQL*Plus: Release 8.0.5.0.0 - Production on Thu Oct 15 17:35:25 1998
>>>
>>>(c) Copyright 1998 Oracle Corporation. All rights reserved.
>>>
>>>ERROR:
>>>ORA-01017: invalid username/password; logon denied
>>>
>>>
>>>Enter user-name:
>>>
>>>But username/password are ok!!!!!!!!!!
>>>
>>>When we try to connect from the HP-UX to the linux, we could connect, and
>>>when we try to connect from a windows95 machine with sqlplus, we could
>>>connect also.
>>>
>>>Any idea?
>>>
>>>Tanks
>>>
>>>Eduardo.
>>>
>>>
>>>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>>>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>>Have you enabled remote login on the Linux database?
>>
>>Clive.
>>--
>>Clive Bostock
>
>

-- 

-rupa