Re: sqlplus connection query

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 - 13:46:38 CST