Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connect system/password@xe doesn't work

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

From: <JL19348_at_HOTMAIL.CO.UK>
Date: 11 Mar 2007 04:57:15 -0700
Message-ID: <1173614235.180097.3940@p10g2000cwp.googlegroups.com>


On 11 Mar, 11:42, "Matthias Hoys" <a..._at_spam.com> wrote:
> <JL19..._at_HOTMAIL.CO.UK> wrote in message
>
> news:1173609999.661295.6820_at_n33g2000cwc.googlegroups.com...
>
>
>
>
>
> > 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. 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
>
> > 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:
>
> Incorrect password for the SYSTEM user ? Can you connect with SYSTEM on the
> PC where XE runs ?

Yes.

> > computer1 (Oracle XE installed. Suse 9 x86):
>
> > sqlplus system/manager_at_xe CONNECTS OK
>
> > sqlplus hr/hr_at_xe CONNECTS OK

But for computer 2

> > computer2 (Oracle client installed, Ubuntu x86):
>
> > sqlplus hr/hr_at_xe CONNECTS OK
>
> > sqlplus system/manager_at_xe GIVES THE FOLLOWING ERROR
Received on Sun Mar 11 2007 - 06:57:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US