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 -> sqlplus connection query

sqlplus connection query

From: Neil <nc1967_at_hotmail.com>
Date: Mon, 8 Nov 1999 12:06:09 -0000
Message-ID: <806ee4$rji$1@pheidippides.axion.bt.co.uk>


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

Original text of this message

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