Re: connect system/password@xe doesn't work

On Mar 11, 2:55 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> Comments embedded.
> On Mar 11, 5:46 am, JL19..._at_HOTMAIL.CO.UK wrote:
>
> > Hi, I am not a DBA, I am interested in Oracle (4 weeks experience
> > mainly at work), and am moving from Windows/SQL Server to Linux/Oracle
> > for my 2 computer home network for learning.
>
> > I have a problem with my new Oracle XE installation. During
> > installation I accepted all the defaults. My problem is that I can
> > connect as some users from computer2 to computer1 (which has Oracle
> > on it) but not all, specifically system/manager. I need to connect as
> > system/manager onto computer1 from computer2 as computer1 doesn't have
> > a monitor/vga card/keyboard.
>
> Interesting. How do you explain your posted output connecting from
> computer1, then?
>
> > Do I need to set something somewhere
> > (init.ora ??) or has my installation failed somehow. You will see what
> > I have tried below for computer1 and computer2 and the Oracle error
> > message I am getting. What I see tells me that the passwords and
> > tnsnames.ora are setup properly too.
>
> > Thank you
> > John
>
> > computer1 (Oracle XE installed. Suse 9 x86):
>
> > sqlplus system/manager_at_xe CONNECTS OK
>
> > sqlplus hr/hr_at_xe CONNECTS OK
>
> Interesting this works without a keyboard/card/monitor.
>
>
>
> > computer2 (Oracle client installed, Ubuntu x86):
>
> > sqlplus hr/hr_at_xe CONNECTS OK
>
> > sqlplus system/manager_at_xe GIVES THE FOLLOWING ERROR
>
> > john_at_ub04:~$ sqlplus system/manager_at_xe
>
> > SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 11 10:35:19 2007
>
> > Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> > ERROR:
> > ORA-01017: invalid username/password; logon denied
>
> > Enter user-name:
>
> It appears your remote password file may be preventing you from
> connecting as system or sys from a remote computer. Still, if you CAN
> connect from computer1 you don't 'need' to connect as these accounts
> from computer2, do you? You reported you have no keyboard, monitor or
> card for computer1 yet you post output from a direct connection
> attempt from that very same computer. How can that be if, as you
> claim, "computer1 doesn't have a monitor/vga card/keyboard."
>
> Strange behaviour, indeed.
>
> David Fitzjarrell

Hello David and thank you for replying on a Sunday.

> from computer2, do you? You reported you have no keyboard, monitor or
> card for computer1 yet you post output from a direct connection
> attempt from that very same computer. How can that be if, as you
> claim, "computer1 doesn't have a monitor/vga card/keyboard."

Oh that's easy to answer. I just ssh'd onto computer1 (which has Oracle installed on it). Computer1 doesn't have a monitor, keyboard or VGA card installed on it really, my desk really isn't big enough :) I could keep doing this but this would be a work around. I want to be able to type "sqlplus system/manager_at_xe" from my second computer.

I read what you have written. I have tried to search on "remote password file site:oracle.com" using Google and the search functionality provided by Oracle but can't find the write pdf describing a value in the init file I should set. I would really appreciate a reference or keyword to search on. My problem is knowing what to search on to find out what I need to do.

Thank you very much

John Received on Sun Mar 11 2007 - 11:10:12 CDT