Re: sqlplus connection query

The problem is that you are putting the @test with the password instead of the user_name. It should be:

Enter user-name: scott_at_test
Enter password: tiger

NOT Enter user-name: scott
Enter password: tiger_at_test

In any event, you should be able to shorten it all up by doing

Enter user-name: scott/tiger_at_test

<aneela1975_at_my-deja.com> wrote in message news:8079at$fbu$1_at_nnrp1.deja.com...
> In article <806ee4$rji$1_at_pheidippides.axion.bt.co.uk>,
> "Neil" <nc1967_at_hotmail.com> wrote:
> > Why is it that on HP-UX I can connect to sqlplus with a tns alias
> added to
> > the password when prompted, but the same wont work under Solaris
> 2.6 ??
> >
> > Example 2 - HP-UX (obviously the password doesn't actually show)
> > ---------------------------
> >
> > SQL*Plus: Release 3.3.4.0.0 - Production on Mon Nov 8 11:55:09 1999
> >
> > Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
> >
> > Enter user-name: scott
> > Enter password: tiger_at_test
> >
> > Connected to:
> > Oracle7 Server Release 7.3.4.3.1 - Production
> > With the distributed and parallel query options
> > PL/SQL Release 2.3.4.3.1 - Production
> >
> > SQL>
> >
> > Example 2 - Solaris
> > ---------------------------
> >
> > SQL*Plus: Release 8.0.5.0.0 - Production on Mon Nov 8 12:3:19 1999
> >
> > (c) Copyright 1998 Oracle Corporation. All rights reserved.
> >
> > Enter user-name:scott
> > Enter password: tiger_at_test
> > ERROR: ORA-01017: invalid username/password; logon denied
> >
> > Is it a difference in operating system, or has something changes from
> Oracle
> > version 7 (what i'm running on HP-UX) and Version 8 (what i'm running
> on
> > Solaris)
> >
> > Any help appreciated ??
> >
> > NeilC
> >
> > PS - Yes the username / password and tns alias are correct on the
> Solaris
> > installation. I can once connected to the database do a connect
> > scott/tiger_at_test
> > from the SQL > prompt
> >
> >
> I think the problem is not whether it is HP or Sun but it is the
> version of sqlplus you are running.
>
> try connecting
>
> SQL*Plus: Release 8.0.5.0.0 - Production on Mon Nov 8 13:45:3 1999
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Enter user-name: scott_at_test
> Enter password:tiger
>
> It works on both the versions of sqlplus.
>
> Regards
> Anil
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 08 1999 - 14:35:55 CST