Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sqlplus connection query
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
Received on Mon Nov 08 1999 - 06:06:09 CST