Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01017 - Gee, it's never done THAT before!

EdStevensNov 29 2017 — edited Dec 5 2017

Oracle 11.2.0.4.0 SE-One on Windows 7 Professional.

Connect as sysdba, shutdown, but on startup (in the same sqlplus session) ...

g:\scripts>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 29 07:52:06 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> create spfile from pfile;

File created.

SQL> startup

ORA-01017: invalid username/password; logon denied

SQL> exit

Disconnected from Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

g:\scripts>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 29 07:55:48 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:

ORA-01017: invalid username/password; logon denied

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2018
Added on Nov 29 2017
48 comments
1,770 views