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: External authenticated user

Re: External authenticated user

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Fri, 07 Jul 2006 17:40:12 GMT
Message-ID: <00xrg.1354$Wh7.1236@trnddc07>


FreddyLi wrote:
> Any ideas for below???
>
> I have set up external authenticated user rajeshext I can log on use
> "sqlplus /" but I can not log on using "sqlplus /@ORA10G". Any ideas?
>
>
> [rajeshext_at_fedora ~]$
> [rajeshext_at_fedora ~]$
> [rajeshext_at_fedora ~]$ . /usr/local/bin/oraenv
> ORACLE_SID = [rajeshext] ? ORA10G
> [rajeshext_at_fedora ~]$ sqlplus /
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Thu Jul 6 18:51:40 2006
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> quit
> Disconnected from Oracle Database 10g Enterprise Edition Release
> 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
> [rajeshext_at_fedora ~]$ sqlplus /@ORA10G
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Thu Jul 6 18:51:49 2006
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
>
> Enter user-name:
>

For remote authentication (i.e. using "@ora10g") you'll need to set up and use a password. You can still authenticate with just "/" locally as long as it's an ops$ user, even if the database has a password stored for the user. Received on Fri Jul 07 2006 - 12:40:12 CDT

Original text of this message

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