Home » SQL & PL/SQL » SQL & PL/SQL » sqlplus connection issue - ora -01017
sqlplus connection issue - ora -01017 [message #262185] Fri, 24 August 2007 19:07 Go to next message
guruzu
Messages: 2
Registered: August 2007
Junior Member
oracle version - 9.2.0.1.0

I am able to connect using system/manager. after the connection is established we are kicking up scripts some of which try to connect again. that is when I am getting ORA-01017 error. I do not think the connect command again should be doing that. Do I need to set something here???

pasted below is a copy

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Aug 24 16:58:01 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> show user
USER is "SYSTEM"
SQL> connect system/manager
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> show user
USER is ""
SQL>
SQL>
Re: sqlplus connection issue - ora -01017 [message #262186 is a reply to message #262185] Fri, 24 August 2007 19:13 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
>oracle version - 9.2.0.1.0
a VERY,VERY buggy version of Oracle

What Operating system name & version?
Is more than 1 instance/DB involved?


If/when I have to pick between the correctness of an Oracle error message & a doubting user;
I'll assume Oracle is correct 100% of the time until conclusive evidence is independently verified.

My assumption is that one way or another an invalid combination of username/password is being presented to Oracle.

[Updated on: Fri, 24 August 2007 19:20] by Moderator

Report message to a moderator

Re: sqlplus connection issue - ora -01017 [message #262279 is a reply to message #262186] Sat, 25 August 2007 21:33 Go to previous messageGo to next message
guruzu
Messages: 2
Registered: August 2007
Junior Member
OS - windows xp
and only one instance of db is involved.

Re: sqlplus connection issue - ora -01017 [message #262284 is a reply to message #262185] Sat, 25 August 2007 22:53 Go to previous message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
> I am able to connect using system/manager
Please provide proof of this statement.
Previous Topic: Dynamically controlling the flow of the script
Next Topic: What could be wrong with DBMS_STATS
Goto Forum:
  


Current Time: Fri Dec 09 11:39:20 CST 2016

Total time taken to generate the page: 0.12440 seconds