Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!newscon06.news.prodigy.com!prodigy.net!news-east.rr.com!news.rr.com!peer01.cox.net!cox.net!cyclone1.gnilink.net!spamkiller.gnilink.net!gnilink.net!trnddc07.POSTED!c015d11f!not-for-mail
From: Chuck <skilover_nospam@bluebottle.com>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: External authenticated user
References: <1152231913.745717.42150@k73g2000cwa.googlegroups.com>
In-Reply-To: <1152231913.745717.42150@k73g2000cwa.googlegroups.com>
X-Enigmail-Version: 0.94.0.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Lines: 43
Message-ID: <00xrg.1354$Wh7.1236@trnddc07>
Date: Fri, 07 Jul 2006 17:40:12 GMT
NNTP-Posting-Host: 71.244.103.183
X-Complaints-To: abuse@verizon.net
X-Trace: trnddc07 1152294012 71.244.103.183 (Fri, 07 Jul 2006 13:40:12 EDT)
NNTP-Posting-Date: Fri, 07 Jul 2006 13:40:12 EDT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270590

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@fedora ~]$
> [rajeshext@fedora ~]$
> [rajeshext@fedora ~]$ . /usr/local/bin/oraenv
> ORACLE_SID = [rajeshext] ? ORA10G
> [rajeshext@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@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.