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

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 Received on Sun Mar 11 2007 - 09:55:42 CDT