>However, I still can't log in sqlplus with the new password.
While I will accept above is true, it is totally & 100% devoid of any actionable detail.
is COPY & PASTE broken for you?
There are a gazillion different reasons why you can't login.
Without knowing the complete error code & message from Oracle, I won't guess any possible solution.
my car won't go
tell me how to make my car go.
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 220.127.116.11.0 Production on Wed Sep 11 17:45:13 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> connect sys/foobar as sysdba
SQL> connect sys/ID10T as sysdba
SQL> connect sys/does_not_matter as sysdba
Last edited by anacedent; 09-11-13 at 20:46.
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.